Previous Lecture
Complete and continue
Mastering SQL & Relational Database Design for Analytics
SQL Foundations & Relational Thinking
Relational Database Architecture & PostgreSQL Setup
(09:46)
Filtering, Sorting & Text Matching with WHERE, LIKE & BETWEEN
(22:38)
Aggregate Functions: COUNT, SUM, AVG & Grouping Logic
(12:15)
Multi-Table Joins & Common Table Expressions
Mastering INNER, LEFT, RIGHT, and FULL OUTER JOINs
(12:28)
Subqueries vs Common Table Expressions (WITH Clauses)
(11:55)
Conditional Logic with CASE WHEN Expressions
(21:11)
Window Functions & Performance Optimization
Window Functions Part 1: Running Totals & Moving Averages
(20:23)
Window Functions Part 2: LAG, LEAD, and Period-over-Period Growth
(20:15)
Query Optimization: B-Tree Indexes & Reading EXPLAIN ANALYZE
(16:33)
Lecture
Subqueries vs Common Table Expressions (WITH Clauses)
Lecture content locked
If you're already enrolled,
you'll need to login.
Enroll in Course to Unlock
Log In
×
E-Mail Address
Password
Remember Me
Forgot Your Password?
Login
Don't have an account?
Sign up