topic · SQL

Schema Design & Normalization (1NF / 2NF / 3NF / BCNF)

SQL skills for the Database Administrator (DBA) career path. Filter, model, and reason about the real data this role works with every day.

Professional Mid priority 1 Project-Based Sandbox & Interactive Quiz

What you'll learn

SQL skills for the Database Administrator (DBA)

Building on Indexing Strategies, this lesson focuses on the practical SQL toolkit a working Database Administrator (DBA) reaches for on the job.

sqlschemanormalizationdata-modelinger-diagram

Sandbox preview

Try the first query

-- SQL — your first interaction
SELECT example, value
FROM sql_dataset
WHERE priority = '1'
AND career = 'Database Administrator (DBA)';

▸ preview · Sprint-2 will replace this with a live runner

Next up in this path

Stored Procedures & Triggers

Once this topic clicks, the recommended next step keeps the learning streak going on adjacent skills in the same career path.

continue path →

Build status

Sprint-1 stub

This is the Sprint-1 stub for ai.careerplane.technology.dba.sql.schema-design. The fully-generated topic page (sandbox + quiz + AI hints + interactive tooling) lands in Sprint-2 at static/content/technology/Database Administrator (DBA)/SQL/Schema Design & Normalization (1NF / 2NF / 3NF / BCNF)/index.html (per arch/memo.md → D-2026-04-22-13). The //go:embed all:static directive auto-serves it on the next container rebuild — no server-code change needed.

Help CareerPlane grow

Share this topic with a colleague learning SQL. Every share helps the catalog grow.