SQL for Analytics Course Index — Dataplexa

SQL for Analytics

SQL for Analytics
Course Index

28 Lessons · 3 Sections

Master SQL for Analytics — the most in-demand skill in data analytics. Covers window functions, CTEs, funnel analysis, cohort analysis, retention analysis & A/B testing across BigQuery, Snowflake . Includes 4 builds: sales dashboard dataset, cohort retention report, funnel analysis query & A/B test results analysis.

Start Course →← Back to Learning Hub

28Lessons

3Sections

4Projects

FreeAccess

Section 1SQL Analytics FundamentalsLessons 1–10

SQL for Analytics vs SQL for Development

SELECT Deep Dive: Filtering, Sorting & Aliasing

Aggregations: GROUP BY, HAVING & COUNT/SUM/AVG

JOINs for Analytics: INNER, LEFT, RIGHT & FULL

Subqueries & CTEs: WITH Clause

Window Functions: ROW_NUMBER, RANK & DENSE_RANK

LAG, LEAD & Running Totals with Window Functions

Date & Time Functions for Analytics

String Functions & Pattern Matching in SQL

CASE WHEN: Conditional Logic in SQL

Section 2Advanced Analytics & ProductionLessons 11–22

Pivot & Unpivot Tables in SQL

Funnel Analysis with SQL

Cohort Analysis with SQL

Retention Analysis with SQL

Revenue & Financial Metrics with SQL

SQL for A/B Testing Analysis

Time Series Analysis with SQL

Query Performance: EXPLAIN & Index Optimisation

SQL in BigQuery: Analytic Functions & Arrays

SQL in Snowflake: Variants & Semi-Structured Data

SQL in dbt: Transforming Data with SQL

SQL for Analytics in 2026: AI-Assisted Querying

Section 3Anti-Patterns, Best Practices & ProjectsLessons 23–28

SQL Analytics Anti-Patterns

SQL Analytics Best Practices 2026

Build a Sales Dashboard Dataset with SQL

Build a Cohort Retention Report with SQL

Build a Funnel Analysis Query with SQL

Build an A/B Test Results Analysis with SQL

Ready to Start?

SQL for Analytics Course Index

Start Course →← Back to Learning Hub