Quick SQL guide and cheat sheet: Essential Commands

The guide simplifies SQL, focusing on commonly used commands for effective data handling. You can also download an extensive SQL cheat sheet here.

Key SQL commands include:

DML

SELECT, INSERT, UPDATE, DELETE

• Retrieve data: SELECT name FROM employees WHERE department = 'Sales';.


• Add data: INSERT INTO employees (name, department) VALUES ('Jane', 'HR');.

DDL

CREATE, ALTER, DROP

• Create new table: CREATE TABLE projects (id INT, title VARCHAR(100));.


• Modify table: ALTER TABLE projects ADD budget DECIMAL;.

FAQ

What is a subquery?

A …

data download employees guide jane key sales sql update values