Skip to main content

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