> > > 10986 Detailed outline

Upgrading your Skills to SQL Server 2016 (10986)

Course Description Schedule Course Outline

Detailed Course Outline

Module 1: Introduction to SQL Server 2016

Describe key capabilities and components of SQL Server 2016

Lessons
  • 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

After completing this module, you will be able to:

  • Describe the key elements of SQL Server 2016
  • Describe the components and editions of SQL Server 2016
  • Install SQL Server 2016
  • Describe the enhancement to SQL Server Management Studio
Module 2: What’s New in SQL Server Performance

This module describes new and enhanced features in SQL Server performance.

Lessons
  • Columnstore Indexes for Operational Analytics
  • In-memory OLTP Enhancements
  • The Query Data Store
  • Native JSON
  • Temporal Tables
Lab: Implementing SQL Server 2016 Performance Improvements

After completing this module, you will be able to:

  • Describe the use of Columnstore indexes for operational analytics
  • Describe the enhancements to in-memory OLTP
  • Use the query data store
  • Use Native JSON
  • Describe and use temporal tables
Module 3: What’s New in SQL Server Security?

This module describes new and enhanced features in SQL Server security.

Lessons
  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking
Lab: Implementing SQL Server 2016 Security Improvements

After completing this module, you will be able to:

  • Implement a logical design for a data warehouse
  • Implement a physical design for a data warehouse
Module 4: What’s New in SQL Server Availability and Scalability?

This module introduces what’s new in SQL Server Availability and Scalability.

Lessons
  • Enhanced AlwaysOn Availability Groups
  • What’s New in Database Caching?
  • Using Windows Server 2016
Lab: Availability and Scalability with SQL Server 2016

After completing this module, you will be able to:

  • Describe the enhancements to AlwaysOn availability groups
  • Describe what’s new in database caching
  • Use Windows Server 2016 with SQL Server 2016
Module 5: What’s New in SQL Server Reporting and BI

This module introduces reporting and BI enhancements and new features in SQL Server 2016.

Lessons
  • Reporting Services Enhancements
  • PowerBI Enhancements
Lab: Implementing PowerBI

After completing this module, you will be able to:

  • Describe the enhancements to reporting services
  • Describe the enhancements to PowerBI
Module 6: What’s New in SQL Server Data Access?

At the end of this module you will be able to describe data access enhancements in SQL Server 2016.

Lessons
  • PolyBase
  • Enhancements to Integration Services
Lab: Using PolyBase

After completing this module, you will be able to:

  • Describe and install PolyBase
  • Describe enhancements to SSIS
Module 7: New and Enhanced Features in SQL Server OLAP

This module describes enhancements in SQL Server OLAP.

Lessons
  • New and Enhanced Features in SQL Server OLAP
  • What’s New in SQL Server Analysis Services
Lab: OLAP with SQL Server

After completing this module, you will be able to:

  • Describe new and enhanced features in SQL Server OLAP
  • Describe new and enhanced features in SQL Server analysis services
Module 8: What’s New for SQL Server in the Cloud?

This module describes new SQL Server cloud functionality.

Lessons
  • 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

After completing this module, you will be able to:

  • Describe stretch databases and why you would use them
  • Understand the enhanced backup options
  • Be aware of SQL Server hybrid cloud
  • Describe what’s new in SQL Server Azure database
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!