← All courses
beginner

SQL and database fundamentals

Write queries you can defend, and design tables that hold up.

8 weeks · 13 sessions · certificate on completion

A short, practical course for developers, analysts and testers. You will move from your first SELECT to window functions and query performance, and learn enough database design to avoid the mistakes that are expensive to undo later.

Included with every programme

Bonus Free AI Training with each module

Every module you study comes with its own hands-on AI training, free of charge — so alongside the subject itself you learn how to do that work with the tools the industry actually uses.

  • Real tools, hands-onChatGPT, Copilot and the AI assistants teams actually use day to day.
  • Tied to each moduleThe AI session covers the same code, data or design work that module just taught.
  • Support while you learnBring your doubts to the AI sessions running alongside your regular classes.
  • No extra chargeIncluded for every student, in classroom batches and live online alike.

Curriculum

4 modules · 13 sessions

1Getting started with SQL3 sessions
Why databases existFree preview
Your first SELECT queryFree preview
Filtering and sorting results
2Querying with confidence4 sessions
Aggregation and GROUP BY
Joins explained properly
Subqueries and common table expressions
Window functions
3Designing a database3 sessions
Tables, keys and relationships
Normalisation without the jargon
Indexes and query performance
4Working with real systems3 sessions
Transactions and consistency
Backups and migrations
Connecting SQL to an application