TypeClassroom Training
Time5 Days
REGISTER

Contact Us

Fields marked with an * are required
Course 10986B - Microsoft SQL Server 2016

Microsoft SQL Server 2016  Training Course & Certification

Description

Audience & Prerequisites

Course Outline

Schedule & Fees

Certification

Microsoft SQL Server 2016 Course 10986B 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.

Objectives of Course 10986B Training

  • 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

Prerequisites for Course 10986B Certification

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

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

Intended Audience for 10986B Course

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. Additionally this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.

Course Outline

 

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query

For more info kindly contact us.

Section 1Introduction to SQL Server 2016Describe key capabilities and components of SQL Server 2016
Lecture 1Overview of SQL Server 2016
Lecture 2SQL Server 2016 Editions and Components
Lecture 3Installing SQL Server 2016
Lecture 4SQL Server Management Studio Enhancements
Section 2What’s New in SQL Server PerformanceThis module describes new and enhanced features in SQL Server performance
Lecture 5Operational Analytics
Lecture 6In-memory OLTP Enhancements
Lecture 7Query Store
Lecture 8Live Query Statistics
Lecture 9Native JSON
Lecture 10Temporal Tables
Section 3What’s New in SQL Server Security?This module describes new and enhanced features in SQL Server security.
Lecture 11Using Always Encrypted
Lecture 12Row-level Security
Lecture 13Dynamic Data Masking
Section 4What’s New in SQL Server Availability and Scalability?This module introduces what’s new in SQL Server Availability and Scalability.
Lecture 14• Enhanced AlwaysOn Availability Groups
Lecture 15What’s New with tempdb?
Lecture 16Use Windows Server 2016 with SQL Server 2016
Lecture 17PowerShell 5.0
Section 5What’s New in SQL Server Reporting and BIThis module introduces reporting and BI enhancements and new features in SQL Server 2016.
Lecture 18Reporting Services Enhancements
Lecture 19PowerBI Enhancements
Lecture 20Mobile Report Publisher
Section 6What’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.
Lecture 21PolyBase
Lecture 22What’s new in Integration Services
Lecture 23Working with SSIS and Azure
Section 7New and Enhanced Features in SQL Server OLAPThis module describes enhancements in SQL Server OLAP.
Lecture 24New and Enhanced Features in SQL Server OLAP
Lecture 25What’s New in SQL Server Analysis Services
Section 8What’s New for SQL Server in the Cloud?This module describes new SQL Server cloud functionality.
Lecture 26Stretch Database
Lecture 27Enhanced Backups to Azure
Lecture 28Introduction to SQL Server 2016 Hybrid Cloud
Lecture 29What’s New in SQL Server Azure Database