SQL Foundations: Core Queries

Query databases like a professional. Learn SELECT, WHERE, JOINs, aggregates, and GROUP BY from zero.

~10h total

7 lessons

~4h content

Free Course

✦ Includes mini project

⭐ Certificate of completion

No setup required · 100% browser-based

What You'll Learn

Write SELECT queries to extract data

Filter and sort results with WHERE and ORDER BY

Aggregate data with COUNT, SUM, AVG

Group data with GROUP BY and HAVING

Write basic INNER JOIN queries

Course Syllabus

7 lessons · ~215 minutes

Your First SELECT

20 min

Code-Along

Filtering with WHERE

25 min

Code-Along

Sorting & LIMIT

20 min

Code-Along

Aggregate Functions

30 min

Code-Along

GROUP BY & HAVING

30 min

Code-Along

Joining Tables (INNER JOIN)

40 min

Code-Along

Mini Project: Sales Report Query

50 min

Project

Prerequisites

✓ None — This course is beginner-friendly

Tools Used

PostgreSQLBrowser SQL Editor

Continue Your Journey

This course is part of the SQL Foundations Track

Learn the core SQL skills needed to query, summarise, and combine relational data with confidence.

SQL Foundations: Core Queries

What You'll Learn

Course Syllabus

Prerequisites

Tools Used

This course is part of the SQL Foundations Track

Ready to start SQL Foundations: Core Queries?