Updating Your Skills to SQL Server 2016

Beskrivelse

På dette kursus får du opdateret din viden og dine færdigheder inden for SQL Server 2014 til SQL Server 2016. Du lærer bl.a. om:

• De vigtige funktionaliteter og komponenter i SQL Server 2016

• De nye og forbedrede features i SQL Server-performance

• De nye og forbedrede features i SQL Server-sikkerhed

• Nyheder og forbedringer i SQL Server-tilgængelighed og -skalérbarhed

• De nye og forbedrede features i reporting og PowerBI i SQL Server 2016

• De nye og forbedrede features vedr. datatilgang (data access)

• De nye og forbedrede features i SQL Server OLAP

• SQL Servers nye cloud-funktionalitet Kurset er især rettet mod professionelle databasemedarbejdere, der har arbejdet med SQL Server 2014, og som skal have opdateret deres viden eller opgraderet deres MCSA-eksamen til SQL Server 2016 (det kræver, at du består en opgraderingseksamen).

Indhold

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 Module 2: What’s New in SQL Server Performance

• This module describes new and enhanced features in SQL Server performance.

• 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 Module 3: What’s New in SQL Server Security?

• This module describes new and enhanced features in SQL Server security.

• Lessons

• 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?

• This module introduces what’s new in SQL Server Availability and Scalability.

• Lessons

• Enhanced AlwaysOn Availability Groups

• What’s New in Database Caching?

• Using Windows Server 2016

• Lab : Availability and Scalability with SQL Server 2016 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.

• Lessons

• Reporting Services Enhancements

• PowerBI Enhancements

• 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.

• Lessons

• PolyBase

• Enhancements to Integration Services

• Lab : Using PolyBase Module 7: New and Enhanced Features in SQL Server OLAP

• This module describes enhancements in SQL Server OLAP.

• Lessons

• New and Enhanced Features in SQL Server OLAP

• What’s New in SQL Server Analysis Services

• Lab : OLAP with SQL Server Module 8: What’s New for SQL Server in the Cloud?

• This module describes new SQL Server cloud functionality.

• Lessons

• Stretch Database

• Enhanced Backups to Azure

• Introduction to SQL Server 2016 Hybrid Cloud

• What’s New in SQL Server Azure Database

• Lab : Using SQL Server in a Hybrid Cloud