Updating Your Skills to SQL Server 2016 Course Overview

The "Updating Your Skills to SQL Server 2016" course is designed for experienced SQL Server professionals looking to update their skills to the latest version. This course covers new and enhanced features in SQL Server 2016 across various areas.

In Module 1: Introduction to SQL Server 2016, learners will get an overview of the major enhancements and a foundation for the more detailed exploration in subsequent modules.

Module 2: What’s New in SQL Server Performance? focuses on performance improvements like the Query Store, JSON support, and Temporal Tables.

Module 3: What’s New in SQL Server Security? explores security features such as Always Encrypted, Row-Level Security, and Dynamic Data Masking.

Module 4: What’s New in SQL Server Availability and Scalability? discusses enhancements in AlwaysOn Availability Groups and other scalability features.

Module 5: What’s New in SQL Server Reporting and BI? covers improvements in Reporting services, Power BI integration, and Mobile report publishing.

Module 6: What’s New in SQL Server Data Access? delves into data access enhancements, including PolyBase integration with Hadoop.

Module 7: New and Enhanced Features in SQL Server OLAP provides insights into Online Analytical Processing improvements.

Module 8: What’s New for SQL Server in the Cloud? examines options for using SQL Server in the cloud with Azure.

Overall, this course serves as a comprehensive SQL Server administration course and one of the essential SQL Server classes for professionals seeking to leverage the full capabilities of SQL Server 2016.