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
Entity-relational model (ER model) and data normalization (normalization)
A data model is a group of conceptual tools used to describe data, their relationships, and their meanings. They also include consistency constraints that the data should follow. In the Entity – Relationship model, the network relationship or the hierarchical model are all examples of data models, see the article Introduction to database models. , […]
Introducing Azure SQL
Introducing Azure SQL, Microsoft's cloud based database
