Descrivere le funzionalità chiave e i componenti di SQL Server 2016
Descrivere le funzionalità nuove e le migliorate, in termini di prestazioni, di SQL Server
Descrivere le funzioni nuove e migliorate nella protezione di SQL Server
Descrivere le novità in SQL Server Disponibilità e scalabilità
Descrivere le funzionalità nuove e migliorate nel reporting e PowerBI in SQL Server 2016
Descrivere le nuove e migliorate funzionalità di accesso ai dati
Descrivere le funzionalità nuove e migliorate in SQL Server OLAP
Descrivere le nuove funzionalità di cloud SQL Server
Esperienza nell'implementazione di soluzioni di business intelligence (BI), costruzione e gestione di database e data warehouse con SQL Server 2014.
Familiarità con il sistema operativo R2 di Windows Server 2012 e il networking.
Module 1: 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
Lab : Installing SQL Server 2016
After completing this module, you will be able to:
Describe the key elements of SQL Server 2016
Describe the components and editions of SQL Server 2016
Install SQL Server 2016
Describe the enhancement to SQL Server Management Studio
Module 2: What’s New in SQL Server Performance
Columnstore Indexes for Operational Analytics
In-memory OLTP Enhancements
The Query Data Store
Native JSON
Temporal Tables
Lab : Implementing SQL Server 2016 Performance Improvements
After completing this module, you will be able to:
Describe the use of Columnstore indexes for operational analytics
Describe the enhancements to in-memory OLTP
Use the query data store
Use Native JSON
Describe and use temporal tables
Module 3: What’s New in SQL Server Security?
Using Always Encrypted
Row-level Security
Dynamic Data Masking
Lab : Implementing SQL Server 2016 Security Improvements
After completing this module, you will be able to:
Implement a logical design for a data warehouse
Implement a physical design for a data warehouse
Module 4: What’s New in SQL Server Availability and Scalability?
Enhanced AlwaysOn Availability Groups
What’s New in Database Caching?
Using Windows Server 2016
Lab : Availability and Scalability with SQL Server 2016
After completing this module, you will be able to:
Describe the enhancements to AlwaysOn availability groups
Describe what’s new in database caching
Use Windows Server 2016 with SQL Server 2016
Module 5: What’s New in SQL Server Reporting and BI
Reporting Services Enhancements
PowerBI Enhancements
Lab : Implementing PowerBI
After completing this module, you will be able to:
Describe the enhancements to reporting services
Describe the enhancements to PowerBI
Module 6: What’s New in SQL Server Data Access?
PolyBase
Enhancements to Integration Services
Lab : Using PolyBase
After completing this module, you will be able to:
Describe and install PolyBase
Describe enhancements to SSIS
Module 7: New and Enhanced Features in SQL Server OLAP
New and Enhanced Features in SQL Server OLAP
What’s New in SQL Server Analysis Services
Lab : OLAP with SQL Server
After completing this module, you will be able to:
Describe new and enhanced features in SQL Server OLAP
Describe new and enhanced features in SQL Server analysis services
Module 8: 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
Lab : Using SQL Server in a Hybrid Cloud
After completing this module, you will be able to:
Describe stretch databases and why you would use them
Understand the enhanced backup options
Be aware of SQL Server hybrid cloud
Describe what’s new in SQL Server Azure database
SCARICA MODULO ISCRIZIONE
