Database Design
SQL Server modeling, indexing and query tuning.
10 topics · ~25h
Progress0%
0 of 10 complete
IntermediateComing Soon
Intro to SQL Server
Editions, tooling and SSMS.
IntermediateComing Soon
SQL Basics
SELECT, JOIN, GROUP BY, subqueries.
IntermediateComing Soon
Normalization
1NF–3NF, denormalization trade-offs.
IntermediateComing Soon
Indexes
Clustered, non-clustered, included, covering.
IntermediateComing Soon
Stored Procedures
Parameters and error handling.
IntermediateComing Soon
Views
Views vs indexed views.
IntermediateComing Soon
Functions
Scalar, inline and table-valued functions.
AdvancedComing Soon
Query Optimization
Execution plans and statistics.
AdvancedComing Soon
Transactions & Locks
Locking, deadlocks and prevention.
AdvancedComing Soon
Isolation Levels
Read uncommitted → serializable, snapshots.
