The Knowledge Academy

SQL Server 2016 Training - Microsoft Server Training

The Knowledge Academy
A Cardiff (Wales)

1.688 
+IVA
*Prezzo Orientativo
Importo originale in GBP:
£ 1.495

Informazioni importanti

Tipologia Corso
Luogo Cardiff (Wales)
Durata 3
Inizio Scegli data
  • Corso
  • Cardiff (Wales)
  • Durata:
    3
  • Inizio:
    Scegli data
Descrizione

Delegate pack consisting of course notes and exercises Manual Experienced Instructor Refreshments

Strutture (1)
Dove e quando
Inizio Luogo
Scegli data
Cardiff
Castle Street, CF10 1SZ, Cardiff, Wales
Visualizza mappa
Inizio Scegli data
Luogo
Cardiff
Castle Street, CF10 1SZ, Cardiff, Wales
Visualizza mappa

Cosa impari in questo corso?

Security
Server
IT
Database
SQL
Database training
Performance
IT Security
Performance
Server
Performance
Server

Programma

The Knowledge Academy Updating Your Skills to SQL Server 2016 (M10986) 3 day course covers the following topics:

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

Ulteriori informazioni

  • 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