slug: sql-fundamentals
title: "SQL — Queries, Joins, and Data Modeling Essentials"
version: 1.0.0
description: "Master SQL queries, joins, aggregation, and database normalization."
category: data
tags: [sql, databases, queries, joins, data-modeling]
difficulty: beginner

xp:
  read: 10
  walkthrough: 30
  exercise: 20
  quiz: 15
  quiz-perfect-bonus: 10
  game: 20
  game-perfect-bonus: 10

time:
  quick: 5
  read: 15
  guided: 45

prerequisites: []
related: [system-design]

triggers:
  - "How do SQL joins work?"
  - "How do I write a SQL query?"
  - "What's the difference between INNER and LEFT join?"
  - "How do I design a database schema?"

visuals:
  diagrams: [diagram-mermaid]
  quiz-types: [quiz-drag-order, quiz-fill-blank]
  game-types: [command-sprint, bug-hunt]
  playground: bash
  web-embeds: true

sources:
  - url: "https://www.postgresql.org/docs/"
    label: "PostgreSQL Docs"
    type: docs
  - url: "https://sqlbolt.com"
    label: "SQLBolt"
    type: docs