How to Learn SQL

There are 5 components of SQL language:

  1. DDL - Data Definition Language: CREATE/ DROP/ ALTER
  2. DQL - Data Query Language: SELECT
  3. DML - Data Manipulation Language: INSERT/ UPDATE/ DELETE
  4. DCL - Data Control Language: GRANT/ REVOKE
  5. TCL - Transaction Control Language: START/ COMMIT/ ROLLBACK

Để code BE thì cần biết hết các components trên. Để làm Data Analyst thì cần focus vào DQL.