All topics

DBMS

Relational modelling, SQL, indexing, and transactions

43 chapters across 10 modules
1

Foundations of Databases

4 chapters

1

Why Databases Exist

7 min read

2

Data Models and the Relational Choice

5 min read

3

DBMS Architecture

6 min read

4

ACID: the Promise a Database Makes

7 min read

2

The Relational Model

4 chapters

1

Relations, Tuples and Domains

7 min read

2

Keys and Constraints

7 min read

3

Relational Algebra

7 min read

4

From Algebra to SQL

6 min read

3

SQL Fundamentals

6 chapters

1

DDL: Defining Schema

6 min read

2

Querying with SELECT

7 min read

3

Joins

8 min read

4

Aggregation and Grouping

7 min read

5

Subqueries and CTEs

8 min read

6

Views, Transactions and DML

8 min read

4

Database Design

5 chapters

1

Entity-Relationship Modelling

7 min read

2

From ER to Relational Schema

7 min read

3

Functional Dependencies

7 min read

4

Normalisation

8 min read

5

When to Denormalise

7 min read

5

Storage and Indexing

5 chapters

1

How a Database Stores Data

7 min read

2

B+ Tree Indexes

8 min read

3

Hash and Specialised Indexes

8 min read

4

Choosing Indexes

7 min read

5

The Buffer Pool

8 min read

6

Query Processing and Optimization

4 chapters

1

The Life of a Query

7 min read

2

Join Algorithms

7 min read

3

Cost-Based Optimization

7 min read

4

Reading and Fixing Query Plans

8 min read

7

Transactions and Concurrency

5 chapters

1

Transactions in Depth

6 min read

2

Anomalies and Isolation Levels

7 min read

3

Locking and Two-Phase Locking

7 min read

4

Multi-Version Concurrency Control

7 min read

5

Deadlocks and Practical Concurrency

8 min read

8

Recovery and Reliability

3 chapters

1

Failures and the Write-Ahead Log

7 min read

2

Checkpoints and Crash Recovery

7 min read

3

Backup, Replication and Availability

8 min read

9

Beyond Relational

4 chapters

1

Why NoSQL Appeared

7 min read

2

The NoSQL Families

8 min read

3

CAP, Consistency and Sharding

8 min read

4

Choosing a Database

8 min read

10

Practice and Capstone

3 chapters

1

Performance Tuning in Practice

8 min read

2

Capstone: Designing a Real System

11 min read

3

Where to Go Next

6 min read