MS SQL Server 2016 Training Course

Duration

14 hours (usually 2 days including breaks)

Overview

As a core of the Microsoft data platform, SQL Server is a leading operational database management system.

Course Outline

Performanace and Management

  • Enhanced Database Caching
  • Query data store
  • In-Memory OLTP in SQL Server 2016

Development

  • Temporal Database
  • Temporary Table and Variable Table in-memory
  • Native JSON

High Availability and Security

  • Enhanced AlwaysOn
  • Always Enrypted
  • Row-level Security
  • Dynamic Data Masking

Data Insight and Business Intelligence

  • Operational Analytics
  • New functionality Columnstore Index
  • Direct Query in SSAS Tabular
  • R Integration (language R in SQL Server)
  • Enhanced SSIS
  • Enhanced MDS

Reporting Services

  • New Report Server
  • Mobil Reports
  • SQL Server Mobile Report Publisher

Cloud and Hybrid

  • Stretch Database
  • Enhanced backup to Azure
  • Migration SQL Server to Azure
  • SSIS and Data Factory

Leave a Reply

Your email address will not be published. Required fields are marked *