Data
Databases & SQL
Where all the real data lives, and how to work with it well.
Databases & SQL — Professional
High-availability database engineering and administration at scale.
108 study hours
680 pages
10 modules
PDF ebook
What is inside
01
High availability, failover and clustering
02
Sharding and horizontal partitioning
03
Read replicas and connection pooling
04
Schema migrations with zero downtime
05
Deep query tuning and execution plans
06
Analytical databases: ClickHouse, BigQuery
07
Vector search with pgvector
08
Database security, encryption and auditing
09
Capacity planning and cost management
10
Disaster recovery testing
By the end you can
- Run highly available databases in production
- Migrate schemas without downtime
- Plan capacity and control database cost