← All tutorials
Skill Zuno · skillzunos.com · System Design
Relational Database tutorial
Learn Relational Database on Skill Zuno. This Relational Database tutorial covers New, Easy, Medium, Hard, and Diff levels so you can study practical Relational Database problems on skillzunos.com.
Open Relational Database on Skill ZunoAlso see the Relational Database interview questions.
Relational databases such as PostgreSQL and MySQL store data in tables with a fixed schema and query it with SQL. They give ACID transactions, joins and strong consistency, which makes them the default choice for most systems. Interviews cover normalisation, indexes, transactions and isolation levels, and how to scale a relational database with replicas, partitioning and sharding.
Relational Database topics covered
- Tables, keys and relationships — Primary keys, foreign keys, and modelling one-to-many and many-to-many relationships.
- ACID transactions — Atomicity, consistency, isolation and durability, and why they matter for money and inventory.
- Isolation levels — Read committed, repeatable read and serializable, and the anomalies each allows.
- Indexes — How B-tree indexes speed up reads, slow down writes, and when composite indexes help.
- Normalisation and denormalisation — Removing duplication for integrity, and adding it back carefully for read speed.
- Scaling relational databases — Read replicas, connection pooling, partitioning and sharding.
What you can learn
- Relational Database tutorial for beginners and experienced developers
- Level-based practice: New, Easy, Medium, Hard, and Diff
- System Design topics alongside Relational Database on skillzunos.com