Updating Your Skills to SQL Server 2016
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