Premium course
PostgreSQL
15 hours
PostgreSQL: Database Design
From the first table to a live system under load. Learn not to memorize answers but to spot the forks: which key, which type, which lock, how to migrate the schema without taking prod down.
- Design schemas that won't be rewritten in a year under load
- Implement tricky cases — history, hierarchies, JSONB — without code-side hacks
- Ship migrations on big tables without 'we'll need a one-hour outage'
29 lessons
Certificate upon completion
This course is part of Premium — along with the other advanced courses, the AI assistant and certificates.
schema.sql
UUID or BIGINT?
JSONB or a separate table?
Soft delete or change history?
What changes after the course
Now
After the course
The schema is sketched by feel — a year later it gets rewritten
You pick keys and types you won't regret under load
JSONB everywhere, because “it’s flexible”
You know where JSONB fits and where it becomes a landmine
Hierarchies and change history live on hacks in app code
You model them with native PostgreSQL patterns
A production migration means “take the service down for an hour”
You roll out schema changes with zero downtime
Course curriculum
Each lesson is short theory with runnable examples plus practice in the trainer with automatic checking.
About the course: from SQL queries to data architecture
Table design basics
Naming and conventions
Primary keys
Integrity constraints
Normalization and denormalization
Atomic values (1NF)
Overloaded tables
Denormalization
Choosing data types
Financial data
Handling time
Storing state
Textual data
Architecture of complex relationships
Polymorphic relationships
Hierarchies and trees
Entity change history
Working with JSONB
Dynamic attributes
JSONB antipatterns
Transactions and concurrency
Race condition
Locking mechanisms
Schema evolution and scaling
Zero downtime schema changes
Logical deletion
Partitioning
Designer checklist
How the learning works
01
Read a lesson with live examples
No-fluff theory: every query in a lesson can be run and tweaked right in your browser.
02
Solve exercises on a real database
You write SQL in the trainer and your answer is automatically checked against a real database. Nothing to install.
03
Stuck? The AI mentor helps
The built-in assistant points out what's wrong with your query and nudges you towards the solution without giving it away.
Who this course is for
Backend developers
Every feature starts with a data schema. Learn to design it so it doesn't have to be rewritten under load a year later.
Team leads and reviewers
Review other people's schemas with arguments: keys, types, locks, zero-downtime migrations.
System design candidates
Hierarchies, change history, polymorphic relations — the typical forks discussed in architecture interview rounds.
You'll need solid SQL basics and experience with any relational database. If you're missing them, start with the free course.
A certificate you can verify
Complete all lessons and receive a personalized course certificate. Attach it to your CV or LinkedIn profile.
Your name and the course title
QR code and verification link
What learners say
Anna
After completing the course, I got promoted to data analyst. The course paid for itself in just one working day with my new salary!
Nikolay
Excellent presentation of the material! Very pleased with tasks from interviews at large IT companies.
Liza
The site is great! Tasks are interesting, UX is at a high level! Verification based on query results, not the query itself like on other sites.
One Premium — all courses at once
You're not buying a single course but the whole SQL Academy Premium: three advanced courses and every trainer feature.
FAQ
Who is this course for?
Backend developers and Data Engineers who want to deepen their DB design knowledge.
Do I need to know SQL?
Yes, we assume you are comfortable with basic SELECTs, JOINs, and DML operations.
Can I get a certificate for the course?
Yes, after completing every lesson in the course, you can get a personalized certificate.
What's included in Premium besides this course?
All advanced courses — query optimization, SQL for data analysis and database design — plus the AI assistant, interview tasks from top companies, reference solutions and certificates.
How long does access last?
6 months from the moment of payment — more than enough to complete all three advanced courses.
Log in to your account
Log in to access the course.
Log in