SQL for Data Analysis (Beginner)

Practice querying and reasoning about structured relational data.

Start Free Practice

Learning path

Chapters

Beginner
Relational Databases and Safe Querying
Understand tables, grain, keys, relationships, data dictionaries, and a safe read-only query workflow.
10 practices
Beginner
Selecting Columns and Naming Results
Retrieve only needed columns and label a result clearly with readable aliases.
10 practices
Beginner
Filtering Rows with WHERE
Filter rows with comparison operators, quoted values, and boundary checks.
10 practices
Beginner
Multi-condition and Pattern Filters
Combine business rules with logical, list, range, pattern, and NULL predicates.
10 practices
Beginner
Sorting, Limiting, and Distinct Results
Create deterministic sorted, top-N, and distinct result sets.
10 practices
Beginner
Calculated Columns, CASE, and NULL
Create calculated fields, business labels, and deliberate missing-value behavior.
10 practices
Beginner
Text and Date Analysis
Normalize text and analyze date ranges with documented dialect choices.
10 practices
Beginner
Aggregate Functions
Summarize rows with COUNT, SUM, AVG, MIN, and MAX.
10 practices
Beginner
Grouping and Filtering Summaries
Summarize rows with aggregate functions, GROUP BY, and group-level filters.
10 practices
Beginner
Joining Related Tables
Connect related tables while preserving grain, keys, and unmatched records intentionally.
10 practices
Beginner
Set Operations and Subqueries
Stack compatible results and answer one question inside another query.
10 practices
Beginner
CTEs and Introductory Window Functions
Build stepwise queries and add group-aware context to detail rows.
10 practices
Beginner
Workplace Reporting and Query Quality
Clarify, build, validate, explain, and hand off a workplace query.
10 practices