SQL

  1. (very good) DDL, DQL, DML, DCL and TCL - by geek for geeks

    1. DDL – Data Definition Language (create, drop, alter, truncate)

    2. DQl – Data Query Language (select)

    3. DML – Data Manipulation Language (update, insert, delete, lock)

    4. DCL – Data Control Language (grant, revoke)

    5. TCL - Transaction Control Language (commit, rollback, savepoint, set transaction)

  2. Introduction, index, keys, joins, aliases etc., newer

  3. Sql cheat sheet

  4. Primary key

  5. Foreign key, a key constraint that is included in the primary key allowed values

  6. Index, i.e., book index for fast reading

  7. Sharding vs Partioning

PreviousML ArchitectureNextTools

Last updated