Data
Databases & SQL
Where all the real data lives, and how to work with it well.
Databases & SQL — Advance
Schema design, performance and working with NoSQL alternatives.
54 study hours
390 pages
10 modules
PDF ebook
What is inside
01
Relational design and normalisation
02
Indexes and how queries actually execute
03
Query optimisation and EXPLAIN
04
Transactions, isolation levels and locking
05
Stored procedures, views and triggers
06
PostgreSQL advanced features
07
MongoDB and document databases
08
Redis for caching and sessions
09
Backups, replication and recovery
10
Connecting databases to applications securely
By the end you can
- Design a schema that scales
- Diagnose and fix slow queries
- Choose correctly between SQL and NoSQL