10 essential commands
(KDnuggets)

SELECT

DISTINCT

WHERE

LIKE

ORDER BY

AS

JOIN

UNION

GROUP BY

CASE

DISTINCT

WHERE

LIKE

ORDER BY

AS

JOIN

UNION

GROUP BY

CASE

4 page cheat sheet
(Steve Nouri via LinkedIn)

Basics (functions, classes, clauses)

Join types

Examples (easy to advanced)

Advanced topics:

- recursive queries

- window functions

- common table expressions (CTEs)

- pivot tables

- analytic functions

- triggers

- stored procedures

- indexes

- cursor-based processing

Join types

Examples (easy to advanced)

Advanced topics:

- recursive queries

- window functions

- common table expressions (CTEs)

- pivot tables

- analytic functions

- triggers

- stored procedures

- indexes

- cursor-based processing

6 lesser-known SQL techniques
(towards data science)

1. Finding and deleting duplicate records from a table

2. Querying the most recent set of records from a table

3. Aggregate daily data at monthly or week-beginning/week-ending level

4. Aggregating data on custom (CASE WHEN) categories

5. Find the difference between today and yesterday (or any two dates) in the same table

6. Merge data from one table into another (the easy way)

2. Querying the most recent set of records from a table

3. Aggregate daily data at monthly or week-beginning/week-ending level

4. Aggregating data on custom (CASE WHEN) categories

5. Find the difference between today and yesterday (or any two dates) in the same table

6. Merge data from one table into another (the easy way)

Advanced SQL operations
(towards data science)

DISTINCT

UNION

ORDER BY

LIMIT and OFFSET

WINDOW

UNION

ORDER BY

LIMIT and OFFSET

WINDOW

Conditional statements
(towards data science)

GROUP BY & aggregate functions
(towards data science)

Joins with CSV files
(John D Cook)

MongoDB vs SQL
(towards data science)

Practice databases & Python
(towards data science)

Rank & Dense Rank functions
(towards data science)

SQL not-so-sexy concepts
(KDnuggets)

1. SQL Views

2. Stored Procedures

3. Scalar functions

2. Stored Procedures

3. Scalar functions

SQL on GPUs in Python
(nvidia)

Sqlite-utils (importing data into sqlite)
(Julia Evans)