Back to Backend Engineer
🗄️
Phase 2
Database Design & SQL
Data modeling, relational SQL, transactions, indexing, and query performance for backend systems.
1
SQL Fundamentals: DDL, DML, DCL, and TCL in Practice
A staff-engineer guide to SQL statement categories and how CRUD operations actually behave against a production relational database.
backend-engineersqlddl
2
Schema Design and Normalization for Backend Systems
A practical guide to keys, relationships, normal forms, and when to deliberately denormalize a production schema.
backend-engineerschemanormalization
3
Advanced SQL: Joins, Window Functions, CTEs, and Pagination
A staff-engineer guide to joins, aggregation, window functions, CTEs, views, and production-safe pagination patterns.
backend-engineerjoinswindow-functions
4
Transactions and Concurrency: ACID, Isolation, and Locking
A staff-engineer guide to ACID guarantees, isolation levels, locking, and deadlocks in production relational databases.
backend-engineeracidisolation
5
Indexing and Query Performance: EXPLAIN, Composite Indexes
A staff-engineer guide to how indexes work, composite and covering indexes, and reading EXPLAIN plans to fix slow queries.
backend-engineerindexingexplain