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