Perfectly Awesome

10 essential commands   (KDnuggets)
SELECT
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
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)
Advanced SQL operations   (towards data science)
DISTINCT
UNION
ORDER BY
LIMIT and OFFSET
WINDOW
Conditional statements   (towards data science)
GROUP BY & aggregate functions   (towards data science)
Inserting one billion records into SQlite in under a minute   (avi.im)
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
SQL on GPUs in Python   (nvidia)
Sqlite-utils (importing data into sqlite)   (Julia Evans)