Kluczowe zagadnienia szkolenia wg trenera CBSG Polska:
Nowości i zmiany w SQL Server 016 w porównaniu z wersjami 2008-2014:
- Temporary Tables
- Always Encrypted
- Row Level Security
- Magazyn planów zapytań (Query Data Store)
- raportowanie w Power BI
- nowości z pracy z Azure
Przemysław Rosłon, Microsoft Certified Trainer
Certyfikacje zawodowe
Dowiedz się więcej o certyfikacjach Microsoft
Poziom szkolenia wg standardów Microsoft
| podstawowy |
średniozaawansowany |
zaawansowany |
ekspercki |
| 100 |
200 |
300 |
400 |
Czas trwania
- 24 godzin lekcyjnych (3 dni)
Tematyka zajęć
- 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 : Exploring SQL Server 2016
- Module 2: What’s New in SQL Server Performance
Operational Analytics
In-memory OLTP Enhancements
Query Store
Live Query Statistics
Native JSON
Temporal Tables
Lab : Implementing SQL Server 2016 Performance Improvements
- 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
- Module 4: 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
Lab : Monitoring tempdb
- Module 5: What’s New in SQL Server Reporting and BI
Reporting Services Enhancements
PowerBI Enhancements
Mobile Report Publisher
Lab : Implementing PowerBI
- Module 6: What’s New in SQL Server Data Access?
PolyBase
What’s new in Integration Services
Working with SSIS and Azure
Lab : Exploring the new features of SQL Server Integrated services (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
- 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 Stretch Database