Updating Your Skills to SQL Server 2016 vB

Course information
Price: € 1,495.00 Excl. VAT
Day(s): 3
Course Code: M10986
GTC: 21
Version: B
Delivery Method: Public Classroom

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.

Public Classroom Schedule

Dates available on request. Please contact us.

Course description

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

Dates for all Delivery Methods
Date & Location Language Ver Delivery Method
July
Guaranteed Event 03 Jul - 05 Jul, 2017
Virtual Training
Virtual Learning
August
16 Aug - 18 Aug, 2017
Virtual Training
Virtual Learning
November
27 Nov - 29 Nov, 2017
Virtual Training
Virtual Learning
All course dates
Date & Location Language Ver
July
Guaranteed Event Late Availability 03 Jul - 05 Jul, 2017 London - Dukes House Public Classroom
Guaranteed Event Late Availability 10 Jul - 12 Jul, 2017 RUEIL ATHENEE Public Classroom
August
06 Aug - 08 Aug, 2017 Riyadh Public Classroom
16 Aug - 18 Aug, 2017 København (Hvidovre) Public Classroom
16 Aug - 18 Aug, 2017 Wokingham Public Classroom
16 Aug - 18 Aug, 2017 Leeds Public Classroom
September
03 Sep - 05 Sep, 2017 Cairo-Sheraton Public Classroom
06 Sep - 08 Sep, 2017 Oslo, Global Knowledge Public Classroom
25 Sep - 27 Sep, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
October
01 Oct - 03 Oct, 2017 Dubai-Knowledge Village Public Classroom
09 Oct - 11 Oct, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
09 Oct - 11 Oct, 2017 Drachten (Amperelaan 1c) Public Classroom
09 Oct - 11 Oct, 2017 RUEIL ATHENEE Public Classroom
16 Oct - 20 Oct, 2017 Madrid Public Classroom
16 Oct - 18 Oct, 2017 Nieuwegein (Iepenhoeve 5) Public Classroom
16 Oct - 18 Oct, 2017 Eindhoven (Evoluon Noord Brabantlaan 1) Public Classroom
30 Oct - 01 Nov, 2017 Oslo, Global Knowledge Public Classroom
November
05 Nov - 07 Nov, 2017 Riyadh Public Classroom
08 Nov - 10 Nov, 2017 Mechelen (Zandvoortstraat 1) Public Classroom
08 Nov - 10 Nov, 2017 Nieuwegein (Iepenhoeve 5) Public Classroom
08 Nov - 10 Nov, 2017 Rotterdam (Barbizonlaan 25) Public Classroom
27 Nov - 29 Nov, 2017 London - Old Broad Street Public Classroom
December
03 Dec - 05 Dec, 2017 Cairo-Sheraton Public Classroom
04 Dec - 06 Dec, 2017 København (Hvidovre) Public Classroom
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 Nieuwegein (Iepenhoeve 5) Public Classroom

This item has been added to your basket