Duration:

3 Days

Audience:

Employees of federal, state and local governments; and businesses working with the government.

Course Description:

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.

Learning Objectives:

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2016
  • Describe new and enhanced features in SQL Server performance
  • Describes new and enhanced features in SQL Server security
  • Describe what’s new in SQL Server Availability and Scalability
  • Describe new and enhanced features in reporting and PowerBI in SQL Server 2016
  • Describe new and enhanced data access features
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new SQL Server cloud functionality

Course Outline

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
  • Lab: Installing SQL Server 2016
2 – WHAT’S NEW IN SQL SERVER PERFORMANCE
  • Columnstore Indexes for Operational Analytics
  • In-memory OLTP Enhancements
  • The Query Data Store
  • Native JSON
  • Temporal Tables
  • Lab: Implementing SQL Server 2016 Performance Improvements
3 – WHAT’S NEW IN SQL SERVER SECURITY
  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking
  • Lab: Implementing SQL Server 2016 Security Improvements
4 – WHAT’S NEW IN SQL SERVER AVAILABILITY & SCALABILITY
  • Enhanced AlwaysOn Availability Groups
  • What’s New in Database Caching?
  • Using Windows Server 2016
  • Lab: Availability and Scalability with SQL Server 2016
5 – WHAT’S NEW IN SQL SERVER REPORTING & BI
  • Reporting Services Enhancements
  • PowerBI Enhancements
  • Lab: Implementing PowerBI
6 – WHAT’S NEW IN SQL SERVER DATA ACCESS
  • PolyBase
  • Enhancements to Integration Services
  • Lab: Using PolyBase
7 – NEW & ENHANCED FEATURES IN SQL SERVER OLAP
  • New and Enhanced Features in SQL Server OLAP
  • What’s New in SQL Server Analysis Services
  • Lab: OLAP with SQL Server
8 – WHAT’S NEW FOR SQL SERVER IN THE CLOUD
  • Stretch Database
  • Enhanced Backups to Azure
  • Introduction to SQL Server 2016 Hybrid Cloud
  • What’s New in SQL Server Azure Database
  • Lab: Using SQL Server in a Hybrid Cloud