← 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

Free AI Training & Support

Every course, career path and internship comes with hands-on AI training at no extra cost — so you leave knowing how to use the tools the industry actually works with.

  • Real tools, hands-onChatGPT, Copilot and the AI assistants teams actually use day to day.
  • Applied to your subjectUse AI on the same code, data or design work your course already covers.
  • 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