SQL Server 2016 Training - Microsoft Server Training
Course
In Cardiff
Description
-
Type
Course
-
Location
Cardiff (Wales)
-
Duration
3 Days
-
Start date
Different dates available
Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments
Facilities
Location
Start date
Start date
Reviews
This centre's achievements
All courses are up to date
The average rating is higher than 3.7
More than 50 reviews in the last 12 months
This centre has featured on Emagister for 10 years
Subjects
- Security
- Server
- IT
- Database
- SQL
- Database training
- Performance
- IT Security
Course programme
Introduction
This course will give delegates an understanding of the new features of SQL Server 2016 and how to move on from earlier releases.
Pre-requisites
To take part in this course delegates must have:
Previous experience in building and managing database, BI and data warehouse solutions with SQL Server 2014
A basic understanding of Windows Server 2012 R2 operating system and networking
A basic understanding of Microsoft Excel and SharePoint Serve r 2013
Aimed at
This course is aimed at database professionals with experience in using SQL Server 2014 who are looking at updating their skills to SQL Server 2016
Duration
This course has a duration of 3 days
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
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
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
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
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
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
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
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
Additional information
- Understand new features in SQL Server performance
- Learn to describe data access enhancements
- Identify new SQL Server cloud functionalities
- GUARANTEED LOWEST PRICE IN THE INDUSTRY
- Demonstrates industry-standard techniques and provides examples of best practice
- Courses delivered by world class training instructors in luxury venues
- Course includes material and manuals
- Book Online or Call 01344 203999 to speak to a training advisor today
SQL Server 2016 Training - Microsoft Server Training