Microsoft Updating Your Skills to SQL Server 2016 10986-B

Each participant will leave with a recognised certificate

After completing this course, students will gain the skills 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 what's new in SQL Server Availability and Scalability
• describe new and enhanced features in reporting and PowerBI 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.

Module 1: Introduction to SQL Server 2017

• Module Goal: Describe key capabilities and components of SQL Server 2017

• Overview of SQL Server 2017

• Functionality across versions

• After completing this module, students will be able to:

• Describe the edition scale limits

• Explain the consistent functionality across versions

Module 2: What's new in SQL Server Performance, Scalability, and Availability.

• This module introduces the performance enhancements provided by Adaptive Query Processing and Automatic Tuning, as well as the scalability and availability enhancements provided by new Availability Group architectures, including Read-Scale Availability Groups and Availability Groups with SQL Server on Linux.

• Adaptive query processing

• Automatic tuning

• Availability Scalability

• Lab : Performance and availability – adaptive query processing

• Interleaved execution

• Batch mode memory grant feedback

• Batch mode adaptive joins

• Describe adaptive query processing

• Describe automatic plan correction

• Describe availability group architectures

• Describe always on availability groups for Linux

• Describe load balancing of readable secondary replicas

• Describe petabyte-scale data warehousing

Module 3: What's New in SQL Server data Access

• SQL Server 2017 introduces SQL Graph which enables you to define the relationships between your data items in a table rather than calculating them during a query, reducing the query cost and simplifying your data structure.

• SQL Graph

• Lab : SQL Graph

• Create a Graph database

• Query a Graph database

• Describe SQL Graph

Module 4: What's new in SQL Server Reporting and BI

• This module describes what's new in SQL Server reporting and BI.

• Power BI report Server

• Reporting Services update

• Lab : Reporting and BI

• Deploy Power BI report server

• Add commenting to a report

• Explain what Power BI report server is

• Use Power BI report server

• Create a Power BI report foe Power BI report server

Module 5: New and Enhanced Features in SQL Server Analysis Services

• This module introduces new and enhanced features in SQL Server Analysis Services, with particular emphasis on the tabular data model.

• Tabular model updates

• Lab : Ragged hierarchies

• View existing reports

• Hide blank members

• Describe the new features of tabular data models

Module 6: New and Enhanced data Analytics Features

• This module introduces new and enhanced data analytics features.

• New and enhanced data analytics features

• Lab : Data analytics with Python

• Enable external script execution

• Run Python scripts

• Describe the new and enhanced data analytics features.

Module 7: What's new in SQL Server in the Cloud

• Organizations want the best value from a mixture of cloud services and their existing investment in on-premises hardware and software. This module covers a comparison between the features of Microsoft Azure SQL Database and Microsoft SQL Server 2017, as well as new features that make it easier for you to migrate databases from on-premises SQL Server instances to Azure SQL Database.

• Azure SQL database features

• Managed Instances

• Lab : Managed instances

• Explain the different features available in Azure SQL database and SQL Server 2017

• Describe Azure managed instances

Module 8: SQL Server on Linux

• This module covers the features of SQL Server on Linux, as well as the process for deploying SQL Server on Linux and using Docker.

• SQL Server on Linux

• Deploying SQL Server on Linux

• Lab : SQL Server in Docker containers

• Deploy a SQL Server Docker image

• Run a SQL Server instance inside a Docker container

• Connect to a SQL Server Instance running in a Docker container

• Describe the f

Describe the edition scale limits Explain the consistent functionality across versions

Explain the different features available in Azure SQL database and SQL Server 2017 Describe Azure managed instances