SQL techniques
Advanced SQL patterns and query techniques
How-to guides
How to import CSV to Postgres
Source CSV we'll be using as an example
Difficulty: intermediate • Time: 7 min
"Find-or-insert" using a single query
Difficulty: beginner • Time: 5 min
How to format SQL (SQL style guide)
Difficulty: beginner • Time: 6 min
How to generate fake data
Difficulty: beginner • Time: 5 min
How to use lib_pgquery in shell to normalize and match queries from various sources
Difficulty: beginner • Time: 5 min