Learn Analytics Engineering

Learn Analytics Engineering

Home
Data Pipeline Summer
Data 101
Back to the Basics with SQL
Data Modeling
Sponsorships
About

SQL

SQL Challenge: Monster Sightings
Use QUALIFY, comparison joins, and window functions to solve this data mystery!
Hidden Behaviors of SQL Window Functions
Why you need to test your code as you write it
3 SQL CASE Statement Alternatives
How to write cleaner, more performant code
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
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
© 2025 Madison Mae
Privacy ∙ Terms ∙ Collection notice
Start your SubstackGet the app
Substack is the home for great culture