What is SQL Server & where it fits in the data ecosystem
Editions & versions of SQL Server
SQL Server components (Database Engine, SSIS, SSAS, SSRS)
SQL Server Management Studio (SSMS) overview
Installing SQL Server (demo: setup & configuration)
Understanding databases, schemas, and objects
Tables, views, indexes, and stored procedures
Primary keys, foreign keys, constraints
Introduction to T-SQL (basic queries, DDL, DML)
Authentication: Windows vs SQL Server
Logins, users, and roles
Permissions and access control
Best practices for securing SQL Server
Backup types (full, differential, transaction log)
Restoring databases (full, point-in-time recovery)
Automating backups (Maintenance Plans, SQL Agent Jobs)
Recovery models (simple, full, bulk-logged)
Query execution plans
Indexing strategies (clustered vs non-clustered)
Statistics and fragmentation
Monitoring with SQL Profiler & Extended Events
Common performance bottlenecks & fixes
Introduction to HA/DR concepts
Log shipping
Database mirroring
Failover clustering
Always On Availability Groups
SQL Server Agent & Jobs
Alerts & notifications
Maintenance plans (index rebuilds, integrity checks)
Monitoring with Dynamic Management Views (DMVs)
Partitioning databases & tables
Auditing & compliance features
Resource Governor (managing workloads)
Managing large databases (VLDB strategies)
Common errors & how to resolve them
Troubleshooting failed jobs
Database corruption & DBCC CHECKDB
Practical labs: recovering from failure scenarios
Setting up a SQL Server instance
Creating & securing a database
Implementing backup & recovery strategy
Simulating failover with Availability Groups
Performance tuning exercise on sample workload
Text Us
