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

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 Apr - 05 Apr, 2018
Virtual Training
18 Jun - 20 Jun, 2018
Virtual Training
17 Sep - 19 Sep, 2018
Virtual Training

Key to symbols -

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
January
07 Jan - 09 Jan, 2018 Cairo-Sheraton Public Classroom
February
04 Feb - 06 Feb, 2018 Dubai-Knowledge Village Public Classroom
05 Feb - 07 Feb, 2018 RUEIL ATHENEE Public Classroom
19 Feb - 21 Feb, 2018 København (Hvidovre) Public Classroom
26 Feb - 28 Feb, 2018 Amsterdam (Kingsfordweg 43) Public Classroom
26 Feb - 28 Feb, 2018
Virtual Training
Virtual Learning
26 Feb - 28 Feb, 2018 Oslo, Global Knowledge Public Classroom
March
05 Mar - 07 Mar, 2018 London - Old Broad Street Public Classroom
25 Mar - 27 Mar, 2018 Riyadh Public Classroom
April
03 Apr - 05 Apr, 2018 Oslo, Global Knowledge Public Classroom
03 Apr - 05 Apr, 2018 Wokingham Public Classroom
03 Apr - 05 Apr, 2018 Manchester Public Classroom
04 Apr - 06 Apr, 2018 Zoetermeer (Centrum West 21) Public Classroom
04 Apr - 06 Apr, 2018
Virtual Training
Virtual Learning
08 Apr - 10 Apr, 2018 Cairo-Sheraton Public Classroom
May
02 May - 04 May, 2018 RUEIL ATHENEE Public Classroom
23 May - 25 May, 2018 Nieuwegein (Iepenhoeve 5) Public Classroom
23 May - 25 May, 2018
Virtual Training
Virtual Learning
28 May - 30 May, 2018 København (Hvidovre) Public Classroom
June
18 Jun - 20 Jun, 2018 Oslo, Global Knowledge Public Classroom
18 Jun - 20 Jun, 2018 London - Old Broad Street Public Classroom
July
16 Jul - 18 Jul, 2018 RUEIL ATHENEE Public Classroom
August
27 Aug - 29 Aug, 2018 København (Hvidovre) Public Classroom
September
17 Sep - 19 Sep, 2018 London - Old Broad Street Public Classroom
17 Sep - 19 Sep, 2018 Leeds Public Classroom
October
15 Oct - 17 Oct, 2018 Wokingham Public Classroom
15 Oct - 17 Oct, 2018
Virtual Training
Virtual Learning
15 Oct - 17 Oct, 2018 Birmingham Public Classroom
15 Oct - 17 Oct, 2018
Virtual Training
Virtual Learning
29 Oct - 31 Oct, 2018 RUEIL ATHENEE Public Classroom
November
19 Nov - 21 Nov, 2018 København (Hvidovre) Public Classroom
December
17 Dec - 19 Dec, 2018 London - Old Broad Street Public Classroom
17 Dec - 19 Dec, 2018
Virtual Training
Virtual Learning

This item has been added to your basket