MS SQL Server 2016 Training Course

Course Code

mssql2016

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

Testimonials

★★★★★
★★★★★

Course Discounts Newsletter

We respect the privacy of your email address. We will not pass on or sell your address to others.
You can always change your preferences or unsubscribe completely.

Some of our clients

is growing fast!

We are looking to expand our presence in Jordan!

As a Business Development Manager you will:

  • expand business in Jordan
  • recruit local talent (sales, agents, trainers, consultants)
  • recruit local trainers and consultants

We offer:

  • Artificial Intelligence and Big Data systems to support your local operation
  • high-tech automation
  • continuously upgraded course catalogue and content
  • good fun in international team

If you are interested in running a high-tech, high-quality training and consulting business.

Apply now!