- Overview of SQL Server (Editions, Components, Installation)
- New features in SQL Server (Transact-SQL functions, spatial data, queries, storage)
- Performance improvement through buffer pool extension and in-memory tables
- Scripting SQL Server (Management Views, PowerShell)
- Security: Row Level Security, Always Encrypted, Dynamic Data Masking
- Data Quality Services (Cleansing Data, Deduplicating Data)
- Master Data Services
- Overview of higher and high availability concepts: Basic High Availability, AlwaysOn Failover Cluster Instances (FCI), and AlwaysOn Database Availability Groups (DAG)
- Overview of what's new in SQL Server Integration Services, Reporting Services and Analysis Services