Databases · beginner
SQL & Database Design
Master SQL from first query to database architecture. Learn PostgreSQL, write complex joins and window functions, design normalised schemas, optimise with indexes, and understand transactions. Curriculum validated against The Odin Project and Stephen Grider's top-selling SQL course.
- 11 hours
- 25 lessons
- 7 modules
- updated April 2026
try it
Try it before you sign up
Read a full lesson from Module 1. No account needed.
free lesson · read · 20 min
What is a Relational Database?
A relational database organises data into tables (also called relations). Each table has: Choosing the right data type is important for correctness, storage, and performance: Coined by E.F. Codd at IBM in 1970. Data is…
curriculum
7 modules, 25 lessons
The whole course is free.
- readWhat is a Relational Database?20 min
- videoSQL Crash Course — Beginner to Intermediate35 min
how it's built
Built by the CloudaQube team
No celebrity instructor — here is exactly what goes into the course instead.
- 01 Last updated April 2026.
- 02 Any module can become a hands-on lab in Labs Studio.
outcomes
What you'll be able to do
- 01 Write confident SQL queries: SELECT, JOIN, aggregate functions, subqueries
- 02 Design normalised database schemas with proper relationships
- 03 Understand and apply indexes to optimise slow queries
- 04 Use transactions and understand ACID properties
- 05 Work with advanced PostgreSQL features: CTEs, window functions, JSONB
- 06 Read EXPLAIN ANALYZE output to diagnose query performance
before you start
- — No prior database experience required
- — Basic programming knowledge helpful but not required
questions
Before you start
How long does it take?
About 11 hours of lessons, videos and hands-on walkthroughs across 7 modules.
What’s free?
The whole course is free — no card required.
get started