Beginner → Intermediate · 6–8 weeks
SQL Server
Relational database fundamentals through production-grade T-SQL: normalization, joins, stored procedures, indexing and performance tuning.
who it's for
- ›Beginners to relational databases
- ›Developers who want to stop guessing at query performance
- ›Anyone pairing this with the .NET Full Stack track
curriculum
Fundamentals → AI-assisted build → capstone
01
Relational Fundamentals
Normalization, keys, relationships, ER modeling.
02
T-SQL
Joins, subqueries, window functions, stored procedures.
03
Indexing & Performance
Execution plans, indexing strategy, query tuning.
04
AI-Assisted Query Building
Pair with Claude/Codex to write and optimize queries under mentor review.
05
EF Core / Dapper Integration
Connecting SQL Server to a real application layer.
06
Capstone Exercise
Design and query a real-time schema end to end.
outcomes
- ✓Design normalized, production-ready SQL Server schemas
- ✓Write and tune non-trivial T-SQL confidently
- ✓Read an execution plan and fix a slow query
Ready to start SQL Server?
Tell us a bit about your background and we'll help you get started.