This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.
Click here to print this page »
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2014.
- Familiarity with the Windows Server 2012 R2 operating system and networking.
· Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.
Detailed Class Syllabus
Module 1: Introduction to SQL Server 2016
Overview of SQL Server 2016
SQL Server 2016 Editions and Components
Installing SQL Server 2016
SQL Server Management Studio Enhancements
Module 2: What’s New in SQL Server Performance
In-memory OLTP Enhancements
Live Query Statistics
Module 3: What’s New in SQL Server Security?
Using Always Encrypted
Dynamic Data Masking
Module 4: What’s New in SQL Server Availability and Scalability?
Enhanced AlwaysOn Availability Groups
What’s New with tempdb?
Use Windows Server 2016 with SQL Server 2016
Module 5: What’s New in SQL Server Reporting and BI
Reporting Services Enhancements
Mobile Report Publisher
Module 6: What’s New in SQL Server Data Access?
What’s new in Integration Services
Working with SSIS and Azure
Module 7: New and Enhanced Features in SQL Server OLAP
New and Enhanced Features in SQL Server OLAP
What’s New in SQL Server Analysis Services
Module 8: What’s New for SQL Server in the Cloud?
Enhanced Backups to Azure
Introduction to SQL Server 2016 Hybrid Cloud
What’s New in SQL Server Azure Database