Learn Analytics Engineering

Home
Back to the Basics with SQL
Data Warehouse December
Sponsorships
About

SQL

3 SQL CASE Statement Alternatives
How to write cleaner, more performant code
2
SQL JOINs with Comparison Operators (>, <, >=, <=)
How to use SQL to find MRR and session events
Back to the Basics with SQL- QUALIFY
A simple way to reduce the number of CTEs with window functions
SQL Order of Execution (with Examples!)
Breaking down your queries to gain deeper understanding
2
To EXISTS or NOT EXISTS...
A deep dive into this SQL operator
Back to the Basics With SQL- Date Functions
The most helpful date functions to know when interviewing and for everyday use
Mastering the SQL Technical Interview
How to prepare, concepts to know, and what to keep in mind
SQL Functions to Make Messy Data Clean
Top SQL functions for cleaning raw data
Back to the Basics With SQL- Aggregates
How you can use SUM and COUNT
Back to the Basics with SQL- Joins
3 Types of Joins and a Problem I Need Your Help Solving
8
Swap Your SQL Code With These Functions
3 ways to make your code faster and more readable
Let's Learn SQL Window Functions
The top window functions and how to use them (with code examples!)
2
© 2025 Madison Mae
Privacy ∙ Terms ∙ Collection notice
Start WritingGet the app
Substack is the home for great culture