Course Introduction – Analytics Engineering

Return to course: Analytics Engineering Analytics Engineering

Next Next Section

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

Course Introduction

Watch this video before starting the course!

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Course
Games
Exercises
Quizzes
Premium Projects
Leaderboard

Log In

Log In