Prerequisiti

Per accedere al corso è richiesta ai partecipanti:

  • Esperienza nella gestione database, data warehouse, e soluzioni business intelligence (BI) con SQL Server 2014;
  • Familiarità con il sistema operative Windows Server 2012 R2;
  • Familiarità con Microsoft Excel e Microsoft SharePoint Server 2013.

Obiettivi

Al termine del corso i partecipanti saranno in grado di:

  • Descrivere le funzioni chiave di SQL Server 2016;
  • Descrivere le nuove componenti di SQL Server Availability e Scalability;
  • Descrivere le nuove componenti in reporting e PowerBI in SQL Server 2016
  • Descrivere le nuove componenti di data access;
  • Descrivere le nuove componenti di SQL Server OLAP;
  • Descrivere le nuove funzionalità di SQL Server cloud.

Contenuto

Introduction to SQL Server 2016

  • Overview of SQL Server 2016
  • SQL Server 2016 Editions and Components
  • Installing SQL Server 2016
  • SQL Server Management Studio Enhancements

What’s New in SQL Server Performance

  • Operational Analytics
  • In-memory OLTP Enhancements
  • Query Store
  • Live Query Statistics
  • Native JSON
  • Temporal Tables

What’s New in SQL Server Security?

  • Using Always Encrypted
  • Row-level Security
  • Dynamic Data Masking

What’s New in SQL Server Availability and Scalability?

  • Enhanced AlwaysOn Availability Groups
  • What’s New with tempdb?
  • Use Windows Server 2016 with SQL Server 2016
  • PowerShell 5.0

What’s New in SQL Server Reporting and BI

  • Reporting Services Enhancements
  • PowerBI Enhancements
  • Mobile Report Publisher

What’s New in SQL Server Data Access?

  • PolyBase
  • What’s new in Integration Services
  • Working with SSIS and Azure

New and Enhanced Features in SQL Server OLAP

  • New and Enhanced Features in SQL Server OLAP
  • What’s New in SQL Server Analysis Services

What’s New for SQL Server in the Cloud?

  • Stretch Database
  • Enhanced Backups to Azure
  • Introduction to SQL Server 2016 Hybrid Cloud
  • What’s New in SQL Server Azure Database

Partecipanti

Professionisti IT

Durata
3 giorni
Livello
Intermedio
Codice
MOC10986B