Module 3: Instructor Walkthrough – SQL Performance Optimizations – Analytics Engineering

Return to course: Analytics Engineering Analytics Engineering

Previous Lesson Previous Next Next Lesson

Analytics Engineering

Grades

Resources

Course Introduction

Module 1: Lesson

Module 2: Instructor Lesson
Interactive Lesson: Data Architecture Challenge
Interactive Lesson: Data Detective Challenge

Module 2: Homework - BigQuery Data Structures

Module 2: Homework - Fivetran BigQuery ELT

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 Aggregations, String Filtering, Having
Module 3: Instructor Walkthrough - SQL Inner, Left, and Complex Joins
Module 3: Instructor Walkthrough - SQL Subqueries in FROM and WHERE
Module 3: Instructor Walkthrough - SQL CASE Statements
Module 3: Instructor Walkthrough - SQL Set Operators & DateTime Functions
Module 3: Instructor Walkthrough - SQL String Functions
Module 3: Instructor Walkthrough - SQL Scalar and Numeric Functions
Module 3: Instructor Walkthrough - SQL Performance Optimizations
Module 3: Instructor Walkthrough - SQL Styling and Formatting
Module 3: Instructor Walkthrough - SQL Interview Questions & Tips
Interactive Lesson: SQL Rescue Quest
Interactive Lesson: Advanced SQL Space Station

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

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

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

Module 7: Lesson
Interactive Lesson: Python Food Delivery

Module 8: Lesson
Interactive Lesson: Dashboard Design Simulator

Module 8: Homework - Looker Studio Marketing Sales and Spend

Interactive Lesson: AI Tools for Analytics Engineering

Capstone Intro

Module 3: Instructor Walkthrough – SQL Performance Optimizations

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Log In

Log In