Databases

The practical half of data: SQL you'll actually write, schema design, indexes and choosing the right database.

intermediate~25 hours14 topics~23h of lessonsRoadmap Level 3

Nearly every real system is data-backed; understanding storage and querying decides how well it scales.

Learning Path
07 stages
14 topics · 7 stages0/14 completed
01

Fundamentals

Start from zero. Build the vocabulary.

Databases in Practice~30 minbeginnerCore SQL: CRUD and Filtering~75 minbeginnerAggregation and Grouping~60 minbeginner
02

Core Concepts

The ideas you cannot skip.

Joins in Practice~75 minintermediateSchema Design and Relationships~90 minintermediateIndexes in Practice~75 minintermediate
03

Intermediate

Connect ideas and go deeper.

Transactions and Locking~75 minintermediateWindow Functions~75 minintermediateQuery Optimization~60 minintermediate
04

Advanced

Beyond the basics.

Migrations, Backups and Maintenance~60 minintermediateReplication and Sharding~60 minadvanced
05

Practice

Solve problems until it sticks.

Practice: SQL Drill~180 minintermediate
06

Projects

Apply everything in real work.

Project: Sales Analytics DB~360 minadvanced
07

Interview Prep

Convert knowledge into offers.

Database Interview Questions~90 minadvanced