Introduction & Architecture
SQL Server architecture overview
Instances, databases, files, and filegroups
SSMS (SQL Server Management Studio) usage

SQL Fundamentals
SELECT queries, joins, subqueries
Constraints, views, stored procedures
Functions, triggers, indexing
Transactions and locking

T-SQL Programming
Variables, control-of-flow statements
Error handling (TRY…CATCH)
Common table expressions (CTE)
Window functions

Administration
Security: logins, users, roles
Backup and restore planning
Performance tuning, indexing strategies
SQL Profiler & Query Store

Advanced SQL Server Features
SSIS basics
SSRS basics
Replication and mirroring
Always On Availability Groups