Updating Your Skills to SQL Server 2016 vB

Course information
Price: € 1,495.00
Day(s): 3
Course Code: M10986
GTC: 21
Version: B

Overview

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.

Pre-Requisites

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

Content

  • 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
  • Lab : Installing SQL Server 2016
  • Module 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
  • Module 3: What’s New in SQL Server Security?
  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking
  • Lab : Implementing SQL Server 2016 Security Improvements
  • Module 4: What’s New in SQL Server Availability and Scalability?
  • Enhanced AlwaysOn Availability Groups
  • What’s New in Database Caching?
  • Using Windows Server 2016
  • Lab : Availability and Scalability with SQL Server 2016
  • Module 5: What’s New in SQL Server Reporting and BI
  • Reporting Services Enhancements
  • PowerBI Enhancements
  • Lab : Implementing PowerBI
  • Module 6: What’s New in SQL Server Data Access?
  • PolyBase
  • Enhancements to Integration Services
  • Lab : Using PolyBase
  • 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
  • Lab : OLAP with SQL Server
  • Module 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

Objectives

  • 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

Target Audience

The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016. Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.
Schedule
Course Details
03 Jul - 05 Jul, 2017
Virtual Training
16 Aug - 18 Aug, 2017
Virtual Training
04 Dec - 06 Dec, 2017
Virtual Training

Key to symbols +

  • gauranteed Indicates a guaranteed course
  • special offer Indicates a special offer
  • late availability Indicates a late availability course
  • GTC What are GTCs?

Course description

Download a PDF document of the complete course description: Updating Your Skills to SQL Server 2016 vB

All course dates
Date & Location Language Ver
June
19 Jun - 21 Jun, 2017 Oslo, Global Knowledge Public Classroom
28 Jun - 30 Jun, 2017 København (Hvidovre) Public Classroom
28 Jun - 30 Jun, 2017
Virtual Training
Virtual Learning
July
03 Jul - 05 Jul, 2017
Virtual Training
Virtual Learning
03 Jul - 05 Jul, 2017 London - Old Broad Street Public Classroom
10 Jul - 12 Jul, 2017 RUEIL ATHENEE Public Classroom
17 Jul - 19 Jul, 2017 Gent - Regus (Gaston Crommenlaan 4) Public Classroom
August
14 Aug - 16 Aug, 2017 Apeldoorn (Soerenseweg 73) Public Classroom
16 Aug - 18 Aug, 2017 København (Hvidovre) Public Classroom
16 Aug - 18 Aug, 2017
Virtual Training
Virtual Learning
16 Aug - 18 Aug, 2017 Wokingham Public Classroom
16 Aug - 18 Aug, 2017
Virtual Training
Virtual Learning
16 Aug - 18 Aug, 2017 Leeds Public Classroom
September
06 Sep - 08 Sep, 2017 Oslo, Global Knowledge Public Classroom
25 Sep - 27 Sep, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
25 Sep - 27 Sep, 2017
Virtual Training
Virtual Learning
October
09 Oct - 11 Oct, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
09 Oct - 11 Oct, 2017
Virtual Training
Virtual Learning
09 Oct - 11 Oct, 2017 Drachten (Amperelaan 1c) Public Classroom
09 Oct - 11 Oct, 2017 RUEIL ATHENEE Public Classroom
16 Oct - 18 Oct, 2017 Nieuwegein (Iepenhoeve 5) Public Classroom
16 Oct - 18 Oct, 2017
Virtual Training
Virtual Learning
16 Oct - 18 Oct, 2017 Eindhoven (Evoluon Noord Brabantlaan 1) Public Classroom
16 Oct - 18 Oct, 2017
Virtual Training
Virtual Learning
30 Oct - 01 Nov, 2017 Oslo, Global Knowledge Public Classroom
November
08 Nov - 10 Nov, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
08 Nov - 10 Nov, 2017
Virtual Training
Virtual Learning
08 Nov - 10 Nov, 2017 Nieuwegein (Iepenhoeve 5) Public Classroom
08 Nov - 10 Nov, 2017
Virtual Training
Virtual Learning
08 Nov - 10 Nov, 2017 Rotterdam (Barbizonlaan 25) Public Classroom
08 Nov - 10 Nov, 2017
Virtual Training
Virtual Learning
27 Nov - 29 Nov, 2017 London - Old Broad Street Public Classroom
27 Nov - 29 Nov, 2017
Virtual Training
Virtual Learning
December
04 Dec - 06 Dec, 2017 København (Hvidovre) Public Classroom
04 Dec - 06 Dec, 2017
Virtual Training
Virtual Learning
04 Dec - 06 Dec, 2017 Apeldoorn (Soerenseweg 73) Public Classroom
18 Dec - 20 Dec, 2017 Oslo, Global Knowledge Public Classroom
27 Dec - 29 Dec, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
27 Dec - 29 Dec, 2017
Virtual Training
Virtual Learning
27 Dec - 29 Dec, 2017 Nieuwegein (Iepenhoeve 5) Public Classroom
27 Dec - 29 Dec, 2017
Virtual Training
Virtual Learning

This item has been added to your basket