Duration
14 hours (usually 2 days including breaks)
Overview
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
Course Outline
Performanace and Management
- Enhanced Database Caching
- Query data store
- In-Memory OLTP in SQL Server 2016
Development
- Temporal Database
- Temporary Table and Variable Table in-memory
- Native JSON
High Availability and Security
- Enhanced AlwaysOn
- Always Enrypted
- Row-level Security
- Dynamic Data Masking
Data Insight and Business Intelligence
- Operational Analytics
- New functionality Columnstore Index
- Direct Query in SSAS Tabular
- R Integration (language R in SQL Server)
- Enhanced SSIS
- Enhanced MDS
Reporting Services
- New Report Server
- Mobil Reports
- SQL Server Mobile Report Publisher
Cloud and Hybrid
- Stretch Database
- Enhanced backup to Azure
- Migration SQL Server to Azure
- SSIS and Data Factory