#queries
Posts on SQL databases queries – beginner friendly posts on joins, indexes, CTEs, and making tweaks to help things run faster.
Conditional logic with the CASE expression
Why You Need SQL Window Functions (part 2)
Why You Need SQL Window Functions (part 1)
Bite-Sized Videos For Beginners
All About SQL Aggregate Functions
6 Ways to Search with System Tables
10 Ways to Tweak Slow SQL Queries
Have you VACUUMed your tables lately?
