L? trnh SQL Server

H??ng d?n ton di?n ?? h?c SQL Server, t? cc truy v?n c? b?n ??n qu?n tr? nng cao.

Trở về lộ trình
Giai ?o?n Ch? ?? chnh N?i dung & Ho?t ??ng h?c t?p M?c tiu & S?n ph?m
1 Gi?i thi?u & Ci ??t
  • Cc khi ni?m CSDL Quan h?
  • Ci ??t Mi tr??ng
  • Lm quen v?i SSMS
  • Ci ??t mi tr??ng v hi?u cc khi ni?m c? b?n.
2 N?n t?ng C? s? d? li?u
  • T?o v Qu?n l C? s? d? li?u
  • Cc ki?u d? li?u
  • T?o b?ng
  • Kha chnh & Kha ngo?i
  • H?c cch t?o v c?u trc m?t c? s? d? li?u.
3 Ngn ng? Truy v?n D? li?u (DQL)
  • SELECT v FROM
  • WHERE
  • ORDER BY
  • TOP, DISTINCT, ALIASES
  • Vi?t cc truy v?n c? b?n ?? l?y d? li?u.
4 Ngn ng? Thao tc D? li?u (DML)
  • INSERT
  • UPDATE
  • DELETE
  • S?a ??i d? li?u trong cc b?ng.
5 Truy v?n Nng cao
  • JOINs
  • Cc hm t?ng h?p
  • GROUP BY & HAVING
  • UNION v UNION ALL
  • Vi?t cc truy v?n ph?c t?p ?? l?y v t?ng h?p d? li?u.
6 Ngn ng? ??nh ngh?a D? li?u (DDL)
  • ALTER TABLE
  • DROP TABLE
  • Cc rng bu?c
  • S?a ??i c?u trc c?a c? s? d? li?u.
7 Ch? m?c & Hi?u su?t
  • Index l g?
  • Clustered vs. Non-Clustered
  • K? ho?ch th?c thi
  • Hi?u v c?i thi?n hi?u su?t truy v?n.
8 L?p trnh T-SQL
  • Bi?n v Lu?ng ?i?u khi?n
  • Th? t?c l?u tr? (Stored Procedure)
  • Hm do ng??i dng ??nh ngh?a (UDF)
  • Trigger
  • T? ??ng ha cc tc v? v xy d?ng logic nghi?p v?.
9 Qu?n l Giao d?ch
  • Cc thu?c tnh ACID
  • BEGIN, COMMIT, ROLLBACK
  • ??m b?o tnh ton v?n c?a d? li?u trong qu trnh ho?t ??ng.
10 B?o m?t C? s? d? li?u
  • ??ng nh?p v Ng??i dng
  • Vai tr (Roles)
  • GRANT, DENY, REVOKE
  • Qu?n l quy?n truy c?p c?a ng??i dng.
11 Qu?n tr? C? b?n
  • Sao l?u v Ph?c h?i
  • SQL Server Agent
  • Th?c hi?n cc tc v? qu?n tr? c? s? d? li?u c?n thi?t.

T? duy C?t li cho ng??i lm vi?c v?i SQL Server

1. D? li?u l Ti s?n V gi

Lun ??t tnh ton v?n, chnh xc v b?o m?t c?a d? li?u ln hng ??u. M?i thao tc ??u ph?i ???c cn nh?c c?n th?n ?? b?o v? ti s?n quan tr?ng nh?t ny.

2. T? duy theo T?p h?p

SQL l ngn ng? khai bo, ho?t ??ng trn cc t?p h?p d? li?u, khng ph?i x? l t?ng dng m?t. Hy h?c cch suy ngh? v? cc thao tc trn ton b? t?p d? li?u.

3. Hi?u n?ng l Vua

M?t truy v?n km hi?u qu? c th? lm ch?m c? h? th?ng. Lun ngh? v? ch? m?c (index), k? ho?ch th?c thi v cch t?i ?u ha ?? ??m b?o t?c ??.

4. C?u trc l N?n t?ng

M?t thi?t k? c? s? d? li?u t?t (chu?n ha) s? ng?n ch?n v s? v?n ?? trong t??ng lai. Dnh th?i gian thi?t k? c?n th?n l m?t kho?n ??u t? x?ng ?ng.