In addition to their professional experience, students who attend this training should already have the following technical knowledge:
After completing this course, students will be able to:
Module 1: Introduction to SQL Server 2016
Describe key capabilities and components of SQL Server 2016
Lab : Installing SQL Server 2016
Module 2: What’s New in SQL Server Performance This module describes new and enhanced features in SQL Server performance.
Lab : Implementing SQL Server 2016 Performance Improvements
Module 3: What's New in SQL Server Security? This module describes new and enhanced features in SQL Server security.
Lab : Implementing SQL Server 2016 Security Improvements
Module 4: What’s New in SQL Server Availability and Scalability? This module introduces what’s new in SQL Server Availability and Scalability.
Lab : Monitoring tempdb
Module 5: What’s New in SQL Server Reporting and BI This module introduces reporting and BI enhancements and new features in SQL Server 2016.
Lab : Implementing PowerBI
Module 6: What’s New in SQL Server Data Access? At the end of this module you will be able to describe data access enhancements in SQL Server 2016.
Lab : Exploring the new features of SQL Server Integrated services (SSIS)
Module 7: New and Enhanced Features in SQL Server OLAP This module describes enhancements in SQL Server OLAP.
Lab : OLAP with SQL Server
Module 8: What's New for SQL Server in the Cloud? This module describes new SQL Server cloud functionality.
Lab : Using SQL Server in a Hybrid Cloud
|Course Duration||3 Days|