Module 3: Walkthrough – SQL Window Functions – Analytics Engineering

Return to course: Analytics Engineering Analytics Engineering

Previous Lesson Previous Next Next Lesson

Analytics Engineering

Grades

Resources

Course Introduction

Module 1: Intro Video
Module 1: Lesson

Module 2: Intro Video
Module 2: Lesson
Interactive Lesson: Data Architecture Challenge
Interactive Lesson: Data Detective Challenge

Module 2: Homework - BigQuery Data Structures

Module 2: Homework - Fivetran Snowflake ELT

Module 3: Intro Video
Module 3: Lesson
Module 3: Walkthrough - SQL SELECT / DISTINCT
Module 3: Walkthrough - SQL Filtering / WHERE
Module 3: Walkthrough - SQL ORDER BY / LIMIT
Module 3: Walkthrough - SQL Aggregations
Module 3: Walkthrough - SQL Filtering & Pattern Matching
Module 3: Walkthrough - SQL HAVING
Module 3: Walkthrough - SQL Inner Joins
Module 3: Walkthrough - SQL Left Joins
Module 3: Walkthrough - SQL Multi-Table Joins
Module 3: Walkthrough - SQL Subqueries
Module 3: Walkthrough - SQL Case Statements
Module 3: Walkthrough - SQL String Functions
Module 3: Walkthrough - SQL Set Operators
Module 3: Walkthrough - SQL Date & Time Functions
Module 3: Walkthrough - SQL Numeric and Scalar Functions
Module 3: Walkthrough - SQL Window Functions
Module 3: Walkthrough - SQL CTEs
Module 3: Walkthrough - SQL Performance Optimizations
Module 3: Walkthrough - SQL Styling and Formatting
Module 3: Walkthrough - SQL Interview Questions & Tips
Interactive Lesson: SQL Rescue Quest
Interactive Lesson: Advanced SQL Space Station

Module 4: Intro Video
Module 4: Lesson
Interactive Lesson: Data Modeling
Interactive Lesson: Normalization Ride Share
Interactive Lesson: Slowly Changing Dimensions

Module 4: Homework - CityBike Data Modeling

Module 5: Intro Video
Module 5: Lesson
Interactive Exercise: Github Workflows
Interactive Exercise: dbt Incremental Materialization

Module 6: Intro Video
Module 6: Lesson
Interactive Lesson: Anomaly Detection Bollinger Bands
Interactive Lesson: Data Quality Investigation
Interactive Lesson: Great Expectations
Interactive Lesson: dbt Testing

Module 7: Intro Video
Module 7: Lesson
Module 7: Walkthrough - Python, Airflow, Orchestration
Interactive Lesson: Python Food Delivery

Module 8: Intro Video
Module 8: Lesson
Interactive Lesson: Dashboard Design Simulator

Module 8: Homework - Looker Studio Marketing Sales and Spend

ChatGPT Intro
ChatGPT Projects
Create your own GPT
Claude for Coding
Cursor for AI Agent Automation
Interactive Lesson: AI Tools for Analytics Engineering

Capstone Intro
Google Account Creation
Github Repo Creation
Google Cloud (BigQuery) & Service Account
dbt Cloud Initial Setup
dbt Cloud Github Connection
dbt Project Initialization
dbt Project & Packages yml
dbt Seed Files pt 1/2
dbt Seed Files pt 2/2
dbt Macros
Staging Orders
Staging Order Items
Staging Customers
Staging Adspend
dbt Snapshots SCD2
Intermediate Order Items Enriched
Intermediate ROAS
Mart ROAS
Mart Order Item Customers
Dim Customers

Module 3: Walkthrough – SQL Window Functions

You are unauthorized to view this page.

Login with Google

OR

Username

Password

Remember Me

Forgot Password

No thanks

Free 25-Page Guide to Analytics Engineering Mastery

Get it by email. No spam. Unsubscribe anytime.

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Log In

Log In