← Back to Training Workshop

SQL for Analysts

The lingua franca of data. Learn to query databases, clean raw data, and answer questions directly from the source.

💾

Workshop Overview

Structured Query Language (SQL) is the most valuable skill for any data professional. This workshop moves fast: we start with basic SELECT statements and quickly move to complex joins, window functions, and CTEs.

What You'll Learn

  • 01. Fundamentals: filtering, sorting, and aggregating data.
  • 02. Relating Data: Inner, Left, and Outer joins. Understanding cardinality.
  • 03. Advanced Logic: Case statements, subqueries, and Common Table Expressions (CTEs).
  • 04. Window Functions: Running totals, rankings, and lead/lag analysis.

Who is this for?

Analysts, Marketers, and Product Managers who want to stop relying on others to pull data for them.