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