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
Module 2: What’s New in SQL Server Performance
- Operational Analytics
- In-memory OLTP Enhancements
- Query Store
- Live Query Statistics
- Native JSON
- Temporal Tables
Mobile 3: What’s New in SQL Server Security?
- Using Always Encrypted
- Row-level Security
- Dynamic Data Masking
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
Mobile 5: What’s New in SQL Server Reporting and BI
- Reporting Services Enhancements
- PowerBI Enhancements
- Mobile Report Publisher
Module 6: What’s New in SQL Server Data Access?
- PolyBase
- What’s new in Integration Services
- Working with SSIS and Azure
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
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
Benefiti:
- Video snimak predavanja u periodu od 365 dana posle kraja obuke
- Pristup laboratorijama putem Interneta 180 dana od kraja obuke
- Materijal u elektronskom obliku
- Zvaničan Microsoft sertifikat o pohađanju kursa
- Mogućnost korišćenja Microsoft SA vaučera za plaćanje ove obuke
Poželjno predznanje:
In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2014.
- Familiarity with the Windows Server 2012 R2 operating system and networking.
- Familiarity with Microsoft Excel and Microsoft SharePoint Server 2013.
Dalje usavršavanje:
Administering a SQL Database Infrastructure (MS20764)
Querying Data with Transact-SQL (MS20761)