SQL Project Skill Matrix
This matrix maps technical competencies and engineering practices across the 5 curriculum projects in the SQL Database Ingestion Track.
Technical Competency Matrix
| Competency / Skill Area | Project 01: Northwind | Project 02: pubs | Project 03: AdventureWorks | Project 04: AdventureWorksDW | Project 05: Production Pipeline |
|---|---|---|---|---|---|
| SQL Fundamentals (SELECT, WHERE, ORDER BY) | ✓ | ✓ | ✓ | ✓ | ✓ |
| Multi-Table Relational JOINs | ✓ | ✓ | ✓ | ✓ | ✓ |
| Bridge Tables & M:N Resolution | — | ✓ | — | — | — |
| Avoiding Measure Multi-Counting | — | ✓ | — | — | — |
| CTEs (Common Table Expressions) | — | ✓ | ✓ | ✓ | ✓ |
| Window Functions (LAG, DENSE_RANK) | — | ✓ | ✓ | — | — |
| Multi-Schema Enterprise OLTP (3NF) | — | — | ✓ | — | — |
| B2B Reseller vs B2C Segmentation | — | — | ✓ | ✓ | ✓ |
| Kimball Star Schema (Facts vs Dims) | — | — | — | ✓ | ✓ |
| Surrogate Key Navigation | — | — | — | ✓ | ✓ |
SQL Semantic Views (CREATE OR ALTER VIEW) |
✓ | ✓ | ✓ | ✓ | ✓ |
| Power Query SQL Connector | ✓ | ✓ | ✓ | ✓ | ✓ |
| Query Folding Optimization | ✓ | ✓ | ✓ | ✓ | ✓ |
| Dynamic Server Parameterization | — | — | — | — | ✓ |
| Power Pivot Semantic Data Model | — | — | ✓ | ✓ | ✓ |
| DAX Measures (Explicit Calculations) | — | — | ✓ | ✓ | ✓ |
| Executive UI/UX Dashboard Design | ✓ | ✓ | ✓ | ✓ | ✓ |
Modular VBA Automation (modRefresh, etc.) |
— | — | — | — | ✓ |
| Fail-Safe Error Handling & Logging | — | — | — | — | ✓ |
| 4-Tier Financial Reconciliation Audit | ✓ | ✓ | ✓ | ✓ | ✓ |