sql-exercises

A repository for revising all essential sql operations.

Resources:

https://www.sql-practice.com/

https://www.toptal.com/sql/interview-questions#form

https://zhuanlan.zhihu.com/p/103501133

https://sqlzoo.net/wiki/SQL_Tutorial

There are three types of SQL Commands: Data Definition Language (DDL), Data Manipulation Language (DML) and Data Control Language (DCL).

DDL: CREATE, DROP, ALTER

DML: SELECT, INSERT, UPDATE, DELETE

DCL: COMMIT, ROLLBACK, GRANT, REVOKE

In reality, 90% of SQL commands belong to DML, which is the focus of this repository.