Thank you for sending your enquiry! One of our team member will contact you shortly.
Thank you for sending your booking! One of our team member will contact you shortly.
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
Testimonials
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
Related Courses
SQL language in MSSQL
14 hours
SQL in SQL Server
14 hours
Transact SQL Advanced
7 hours
Transact SQL Basic
14 hours
Administration with Powershell
35 hours
Business Intelligence with SSAS
14 hours