Giới thiệu
hocvietcode.com là website chia sẻ và cập nhật tin tức công nghệ, chia sẻ kiến thức, kỹ năng. Chúng tôi rất cảm ơn và mong muốn nhận được nhiều phản hồi để có thể phục vụ quý bạn đọc tốt hơn !
Liên hệ quảng cáo: trienkhaiweb@gmail.com
Introduction to Transact-SQL (T-SQL)
Introduction to Transact-SQL (T-SQL), introduces syntax, query concepts, Transact-SQL statement sequence, and SELECT clause
Introduction to Microsoft SQL Server
A basic introduction to Microsoft SQL server, the main components of this DBMS, and current versions.
Create and administer the database, create users in SQL Server
how to create and administer databases and users and assign database permissions to users in Microsoft SQL Server using T-SQL and SSMS
Common Table Expression (CTE) – Common Table Expression in SQL Server
Common Table Expression (CTE) Concept - Common Table Expression in SQL Server, how to use WITH clause to define CTE
Combine Data Using (SET OPERATORS) UNION, INTERSECT, and EXCEPT in SQL Server
Introducing a solution to combine data using SET OPERATORS (set operator), UNION, INTERSECT and EXCEPT operators in SQL Server
SQL Server Pivot and Grouping Set Operators
Introduction to SQL Server pivot concepts and unpivot, which change the direction of data when displayed to the user
Programming and control of flow in Transact SQL
Programming in T-SQL, introducing controls of flow SQL, IF...ELSE , CASE WHEN in SQL
Transaction in SQL Server
Introduction to transaction in SQL Server, commit transaction , rollback transaction, save transaction in SQL Server.
Subqueries (subqueries) in SQL Server
Subquery concept in SQL Server, nested subqueries concept, correlated queries in SQL Server
SQL Server GROUP BY clause
Introducing the GROUP BY clause in SQL Server, how to combine GROUP BY with WHERE, NULL, ALL , HAVING
Index in SQL Server
Introduction to index in SQL Server, explanation of clustered index, non-clustered index, unique index, columnstore index, filtered index, xml index, introduction to index
Fix error “The stream or file “laravel.log” could not be opened in append mode: failed to open stream: Permission denied ” Ubuntu/mac Os/Windows
I encountered this error when dealing with problems in the Mac Os environment, when I downloaded the laravel project and initialized it on the local environment for further development, because I was not familiar with the concept of decentralization in this environment, it took quite a while, so I write this article to guide you […]
Constants in PHP and how to declare constants
Introduction to constants in PHP and how to define constants through the define() function. Introducing magic constants in PHP
Functions that work with strings in PHP
Introduce some built-in functions that work with string data type ( string ) in PHP and how to use
Expressions in AngularJS
Concept of expression in angualrajs and tutorial on using expressions, advantages and disadvantages of expression in angularjs
Data binding mechanism in AngularJS
Introduce and describe the concept of data binding mechanism in angularjs, two way data binding, preliminary role of ng-model directive
Event handling in angularJS
Introducing event handling in angularJS, how to handle events in angularJS through ng
Filter (filter) in angularJS
The concept of filter in angularjs, self-defined custom directive for angularjs application
Route (routing) in angularJS
the concept of routes in angularJs, explaining the client side rendering mechanism and the current Javascript framework in use
