How lenhattung/sqlserver works
This repository is a Vietnamese SQL Server learning collection, accompanied by a Northwind database asset. Its principal user workflow is to study standalone lesson files covering query construction, advanced querying, and database operations; the Northwind files provide a sample database resource. The tree documents topics but no execution framework or links between lessons and the database. With no README content or source excerpts, relationships between these components cannot be established, so the graph shows the documented learning areas without inferred call or data-flow edges.
Components 34
Query Basics
- SELECT
04-Cau lenh SELECT.sql - SELECT DISTINCT
05-Cau lenh SELECT DISTINCT.sql - SELECT TOP
06-Cau lenh SELECT TOP.sql - Aliases
07-Alias - Bi danh -Tên thay the.sql - Min Max Count
08-Tim gia tri Min Max.sql - Count Sum AVG
09-Count-Sum-AVG.sql - Ordering
10-Order By.sql - Arithmetic
11-Cac phep toan cong, tru, nhan, chia, modulo.sql - WHERE
12-Menh de Where.sql - Logical Operators
13-And-Or-Not.sql - BETWEEN
14-Toan tu BETWEEN.sql - LIKE
15-Toan tu LIKE.sql - Wildcards
16-Wildcard.sql - IN Operators
17-IN-NOT IN.sql - NULL Checks
18-IS NULL - IS NOT NULL.sql - GROUP BY
19-GROUP BY.sql - Date Parts
20-Day-Month-Year.sql - HAVING
21-HAVING.sql - Query Exercises
22-Bai tap On tap.sql
Advanced Queries
- Multi-table Queries
23-Truy van du lieu tu nhieu Table.sql - Multi-table Exercises
24-Bai tap truy van du lieu tu nhieu Table.sql - UNION
25-Union - ket hop du lieu tu nhieu ket qua.sql - JOIN Variants
26-Cac cau lenh JOIN - LEFT JOIN - RIGHT JOIN - FULL JOIN.sql - JOIN Exercises
27-Bai tap cac cau lenh JOIN.sql - Subqueries
28-Sub query.sql - Subquery Exercises
29-Bai tap SUBQUERY.sql - Execution Order
30-Thu tu thuc thi cau lenh SQL.sql - Common Table Expressions
31-Common Table Expression.sql - Recursive Queries
32-Truy vấn đệ quy.sql - Window Functions
33-Windows Functions.sql
Database Operations
- Create Database
35-Tạo cơ sở dữ liệu.sql - Create Table
36-Tạo Table.sql - INSERT
38-Câu lệnh INSERT.sql - SELECT INTO
39-Câu lệnh SELECT INTO.sql