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