Terminus Expanse
CurriculumBlogPricingSign in
Back to catalog
Expert (optional)

Database Systems at Scale

Optional, elite-tier: the techniques that keep a database fast and correct once it outgrows a single machine and a handful of users — advanced indexing, partitioning, sharding, and the OLTP/OLAP split.

What you'll actually learn

The techniques that keep a database correct with ten users stop being enough somewhere past a few million rows or a few thousand concurrent connections — this elite-tier track covers exactly what changes: indexing strategies beyond a basic B-tree, partitioning a table too large for one disk to serve fast, sharding across multiple machines, and why analytical (OLAP) and transactional (OLTP) workloads eventually need to be pulled apart entirely.

What you'll be able to do

You'll take a database that's failing under realistic scale and diagnose exactly which technique fixes it — not by guessing, but by understanding what each one actually trades away. That's the specific, elite-tier judgment call that separates someone who can design a schema from someone trusted with a system that can't afford to go down.

Syllabus

1Advanced Indexing: Partial, Covering, and GIN Indexesexpert~14 min
2Table Partitioning at Scaleexpert~13 min
3OLTP vs OLAP: Two Different Jobs for a Databaseexpert~12 min
4Sharding: Splitting a Database Across Machinesexpert~13 min
5ETL and Data Pipelinesexpert~12 min
6Capstone: Scale This Databaseexpert~30 min

Frequently asked

How long does Database Systems at Scale take to complete?

Roughly 2 hours across 6 hands-on quests — you can go at your own pace and pick up exactly where you left off.

What do I need to know before starting Database Systems at Scale?

You should be comfortable with Administering PostgreSQL, NoSQL Databases first — the skill tree unlocks Database Systems at Scale once you've cleared those.

Is Database Systems at Scale free to learn?

Yes — Database Systems at Scale is fully available on the free tier, starting with a free first quest and no payment method required to sign up. Plus and Elite remove pacing limits but don't gate any of the Database Systems at Scale curriculum behind a paywall.

Start this skill for free

Create a free account and begin your first quest — no card required.

Start free