Skip to content
NDLab Blog
Sign in
Completed 3 episodes ~ 37 min total read

Database Engineering: SQL Deep Dive

Start series
Share Episodes About

Episodes

3 items • ~37 min
  1. 1

    Advanced SQL: Window Functions, CTEs and Recursive Queries

    Updated

    Window functions and CTEs turn 20-line subquery nightmares into clean SQL. Master ROW_NUMBER, RANK, LAG/LEAD, recursive CTEs, and the patterns that appear in real codebases.

    Published Jun 5, 2026 • 12 min read
  2. 2

    Query Optimization: How to Read EXPLAIN Plans and Fix Slow Queries

    New

    A slow query in production is a fire. EXPLAIN plans show exactly where the database wastes time — if you know how to read them. This post teaches you how, with real examples.

    Published Jun 6, 2026 • 11 min read
  3. 3

    Schema Design: Normalization vs Denormalization and When to Choose Each

    New

    Normalization keeps data consistent. Denormalization makes reads fast. Every real schema is a trade-off between them — this post teaches you how to make that call deliberately.

    Published Jun 7, 2026 • 14 min read