Training Program · SQL Server
SQL Server / T-SQL Training Program
40 hours across three phases — from relational design and T-SQL querying to performance tuning, production administration, and modern data literacy.
Who It's For
Built Around Real Data Roles
Each phase builds toward a different level of ownership over a production database.
Developers & Analysts New to SQL
Start with data modeling, normalization, and T-SQL querying — from SELECT basics to joins, subqueries, and CTEs.
Engineers Writing Production Code
Build stored procedures, views, and triggers, then learn to read execution plans and tune indexes for real workloads.
DBAs & Ops-Focused Engineers
Own backup/recovery, HA/DR strategy, routine maintenance, and modern data-store literacy for production systems.
Curriculum
What Each Phase Covers
T-SQL & Database Design Foundations
Relational modeling and core T-SQL querying, from ER diagrams to joins and set operations.
- Entity modeling, keys, and ER diagrams through normalization (1NF–BCNF)
- SELECT fundamentals: filtering, sorting, NULL handling, CASE expressions
- INNER/OUTER/self joins, CROSS and OUTER APPLY
- Aggregates, GROUP BY/HAVING, subqueries, CTEs and set operators
- DML (INSERT/UPDATE/DELETE/MERGE) and DDL with constraints
- Capstone: design & query a normalized retail database
Programmability & Performance
Stored procedures, views, and triggers, then indexing and execution-plan-driven tuning.
- Views (including indexed/materialized), stored procedures, error handling & transactions
- Triggers, dynamic SQL, and SQL injection awareness
- Indexing: clustered/nonclustered, covering & filtered indexes, fragmentation
- Query tuning: SARGable predicates, parameter sniffing, execution plan reading
- Window functions, PIVOT/UNPIVOT, JSON basics
- Capstone: diagnose & optimize a slow reporting query
Administration & Modern Data
Backup/recovery, high availability, routine maintenance, and modern/NoSQL data literacy.
- Recovery models and full/differential/log backup strategy
- Restore sequencing, point-in-time recovery, corruption checks (DBCC CHECKDB)
- HA/DR concepts: Always On, log shipping, replication, RPO/RTO
- Automated maintenance, SQL Server Agent jobs, and DMV-based monitoring
- NoSQL data models (document/key-value/column/graph) and CAP trade-offs
- Capstone: backup/recovery runbook & NoSQL fit assessment
Hands-On & Tools
Tools & Environment Used Throughout
Capstone Projects
Each phase closes with a capstone tied to a shared retail schema — designing and querying a normalized database, diagnosing and optimizing a slow reporting query, then producing a backup/recovery runbook and NoSQL fit assessment — reviewed through code/design review and a live demo.
The AI Angle
Why This Still Needs a Human
AI Writes the Query. It Doesn't Own the Database.
AI can write a passable SELECT statement from a plain-English description. It's much less reliable at spotting why a query plan degrades at scale, designing a schema that won't need a rewrite in a year, or making the call on index strategy for a multi-terabyte table. That's the layer this program targets — the judgement behind the query, not just the query.
Outcomes
What Participants Can Do Afterward
Design & Query with Confidence
Design normalized relational schemas and write confident, complex T-SQL — joins, subqueries, CTEs, and window functions.
Diagnose & Tune Performance
Diagnose and tune slow queries using execution plans, indexing strategy, and dynamic management views.
Operate Production Databases
Own backup/recovery, HA/DR planning, and routine maintenance — with informed NoSQL literacy.