Join the Microsoft Training and Certification Community. Field workers often create Excel spreadsheets to track data and run their processes. Here's how Carlsberg Danmark centralized business process management, created an orderly system with consistent data, and saved hundreds of hours in backoffice time.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: What’s New in SQL Server Security This module describes new and enhanced features in SQL Server security.
This five-day instructor-led course teaches students how to use the enhancements and new features that have been added to SQL Server and the Microsoft data platform since the release of SQL Server 2008.
The course focuses on teaching individuals how to use SQL Server 2014 product features and other Microsoft data platform components.
There’s no need for any setup or installation, because we provide a virtual environment and step-by-step instructions.
Explore all SQL Server virtual labs Start the SQL Server for Linux Administrators virtual lab Start the SQL Server on Linux for SQL Server Administrators lab Check out training videos, demos, and presentations to help you better understand the key improvements in SQL Server 2016, or build your first app after choosing from a selection of programming languages and operating systems.
Additional this course is for existing SQL Server 2014 MCSAs who want to prepare for the Upgrade exam for SQL Server 2016 certification If you need training for 3 or more people, ask us about training at your site.
You enjoy the convenience and reduced travel cost & time. Additionally, we can customize the course for your business needs.This three-day instructor-led course provides students moving from earlier releases of SQL Server with an introduction to the new features in SQL Server 2016.Target Audience: 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.Familiarity with Microsoft Excel and Microsoft Share Point Server 2013.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 : Installing SQL Server 2016 Module 2: What’s New in SQL Server Performance Columnstore Indexes for Operational In-memory OLTP Enhancements The Query Data Store 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?In particular, the module focuses on Microsoft Azure HDInsight and the Microsoft Azure Marketplace as core elements of the Microsoft solution for big data.