Skip to main content

SQL

Structured Query Language (SQL) is the foundational skill for every data analyst. This section teaches you how to query, transform, and analyze data stored in relational databases — from your first SELECT statement to advanced window functions.

What You'll Learn​

  • Writing queries to retrieve and filter data
  • Aggregating and grouping records
  • Joining multiple tables together
  • Using subqueries and CTEs for readable, modular SQL
  • Window functions for running totals, rankings, and comparisons
  • Performance basics: indexes and query planning

Lessons​

LessonDescription
Introduction to SQLWhat SQL is, how databases work, and your first queries
Prerequisites

No prior experience required. A basic understanding of spreadsheets is helpful but not necessary.