L? trnh MySQL

H??ng d?n ton di?n ?? h?c MySQL, 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 Cng c?
  • 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
  • LIMIT, 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
  • Truy v?n con
  • 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?
  • Cc lo?i Index
  • L?nh EXPLAIN
  • Hi?u v c?i thi?n hi?u su?t truy v?n.
8 L?p trnh SQL
  • Bi?n v Lu?ng ?i?u khi?n
  • Th? t?c l?u tr?
  • Hm
  • 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
  • START TRANSACTION, 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
  • T?o v Qu?n l Ng??i dng
  • Quy?n h?n
  • 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
  • Storage Engines
  • 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 MySQL

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

Lun ?u tin tnh ton v?n, chnh xc v b?o m?t c?a d? li?u. M?i ho?t ??ng ??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 theo t?ng hng. H?c cch suy ngh? v? cc ho?t ??ng trn ton b? t?p d? li?u.

3. Hi?u su?t l Vua

M?t truy v?n khng hi?u qu? c th? lm ch?m ton b? h? th?ng. Lun suy ngh? v? ch? m?c, k? ho?ch th?c thi v cch t?i ?u ha ?? ??t t?c ?? nhanh nh?t.

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 s? ??u t? x?ng ?ng.