Updating your database administration skills to microsoft sql server 2016
A report is only useful if those who receive it understand what it means.
Module 1: Introduction to SQL Server 2016 Describe key capabilities and components of SQL Server 2016 Lessons 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: Whats New in SQL Server Performance This module describes new and enhanced features in SQL Server performance.: The primary audience for this course are existing database professionals with experience of SQL Server 2014 who want to update their skills to SQL Server 2016.Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification.Lessons 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: Whats New in SQL Server Security?
This module describes new and enhanced features in SQL Server security.: After completing this course, students will be able to: Describe key capabilities and components of SQL Server 2016 Describe new and enhanced features in SQL Server performance Describes new and enhanced features in SQL Server security Describe whats new in SQL Server Availability and Scalability Describe new and enhanced features in reporting and Power BI in SQL Server 2016 Describe new and enhanced data access features Describe new and enhanced features in SQL Server OLAP Describe new SQL Server cloud functionality : 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.