14 hours (usually 2 days including breaks)
As a core of the Microsoft data platform, SQL Server is a leading operational database management system.
Performanace and Management
- Enhanced Database Caching
- Query data store
- In-Memory OLTP in SQL Server 2016
- 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
- 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
Help in designing the actual database we intend to build based on the knowledge of the course; Quickly create reports.
Carlsberg Shared Services Sp. z o. o.
I liked the practical and immediate application of concepts to lectures.
Nordex Energy GmbH