SQL & Databases Developer Roadmap
Follow our day-by-day structured curriculum. Click on any active timeline node to instantly unpack the textbook theory, study beginner analogies, and complete sandboxed WASM database tasks right on screen!
SQL SELECT & Projection
Master the entry point of data extraction: querying columns and renaming with AS.
WHERE Filters & Conditional Logic
Learn to surgically extract specific rows of data using conditional filtering.
ORDER BY & LIMIT Sorting
Sort your query results and cap outputs to show top rankings easily.
SQL Aggregations & COUNT
Compile high-level math summaries like sums and averages over row matrices.
GROUP BY & HAVING Aggregations
Segment your summaries across specific categories and filter aggregated stats.
INNER JOIN Table Relations
Unlock the power of relational databases: link multiple tables together.
LEFT OUTER Joins
Preserve left-hand records and locate missing or orphaned data relationships.
Subqueries & Nested Compiles
Write queries inside query blocks to form complex in-memory compilers.
Common Table Expressions (CTEs)
Write clean, highly readable, multi-stage pipelines using the WITH clause.
Advanced Window Functions
Compute moving averages, cumulative sums, and department rankings.
DDL: Tables & Data Types
Define relational physical table blueprints, data types, primary keys, and constraints.
Relational Integrity Constraints
Enforce primary keys, foreign keys, unique tags, check thresholds, and defaults.
DML: Insert & Identity Management
Populate table entities with single or multiple row records instantly.
DML: UPDATE & DELETE
Mutate existing cell values or eradicate specific rows using surgical WHERE conditions.
The MERGE Statement (Upsert)
High-performance conditional insert, update, or delete in a single pass.
Inner & Outer Joins Review
Master the fundamental differences between strict intersection and outer preservation.
Set Operators (UNION vs UNION ALL)
Stack query results vertically and evaluate deduplication performance overhead.
Self Joins & Hierarchical Data
Join a table to itself to resolve recursive organizational trees or parent ledgers.
Non-Equi Joins & Theta Joins
Link tables across unequal thresholds, date ranges, or salary grade brackets.
CROSS APPLY & OUTER APPLY
Apply table-valued functions or correlated subqueries to each row of an outer table.
Correlated vs Uncorrelated Subqueries
Evaluate subquery caching mechanics and avoid correlated performance collapse.
Common Table Expressions (CTEs)
Modular query structuring with WITH, enabling clean, chained data pipelines.
Recursive CTEs
Navigate tree structures, bill of materials (BOM), and organizational charts using UNION ALL.
Ranking Window Functions
Assign sequential indices, rank ties, and divide rows into equal quartile buckets.
Analytic Window Functions (LEAD & LAG)
Fetch preceding or subsequent row values to calculate period-over-period growth.
Running Totals & Moving Averages
Utilize dynamic window framing to calculate cumulative cash flows and trends.
PIVOT & UNPIVOT
Rotate row-level dimensions into columnar aggregations for cross-tabulation reports.
JSON & XML Processing
Extract structured relational tables from raw document payloads and webhooks.
Variables & Flow Control
Declare local @variables and construct IF...ELSE and WHILE procedural loops.
Temp Tables vs Table Variables
Compare scope, physical TempDB logging, and index allocation differences.
Stored Procedures (Stored Procs)
Encapsulate complex multi-table business workflows with input/output parameters.
User-Defined Functions (UDFs)
Eliminate scalar UDF performance bottlenecks and deploy Inline TVFs.
Cursors & Iteration (RBAR Refactoring)
Deconstruct row-by-agonizing-row cursors into high-speed set-based logic.
Structured Error Handling (TRY...CATCH)
Trap runtime execution exceptions and log system error metadata gracefully.
THROW & Custom Error Generation
Generate custom application alerts and re-throw transactional exceptions.
ACID Transactions & Rollbacks
Control explicit BEGIN TRAN, COMMIT, and ROLLBACK durability safeguards.
Isolation Levels & Locking
Evaluate dirty reads, repeatable reads, and row-versioning concurrency.
DDL & DML Triggers
Query virtual inserted and deleted transition tables inside automated triggers.
Dynamic SQL & Injection Prevention
Parameterize runtime query strings using sp_executesql to thwart injection attacks.
Query Tuning & Execution Plans
Inspect B-Tree index seeks, covering index scans, and eliminate parameter sniffing.