Welcome to our Analytics Engineering course! Below you will find the 12 different modules with videos from our instructor Eric. Eric is a seasoned Analytics Engineer with over a decade of experience in data analytics. You will also find our AI assistant, ask for any question you might have regarding setup, the course, or analytics engineering topics in general.
Ask Analytics Tutor
Course Curriculum
-
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