CONTENUTI

Module 1: Introduction to SQL Server 2017

• Overview of SQL Server 2017
• Functionality across versions

 

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

• 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

 

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

• SQL Graph

 

Lab: SQL Graph

• Create a Graph database
• Query a Graph database

 

Module 4: 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

 

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

• Tabular model updates

 

Lab: Ragged hierarchies

• View existing reports
• Hide blank members

 

Module 6: New and Enhanced data Analytics Features

• New and enhanced data analytics features

 

Lab: Data analytics with Python

• Enable external script execution
• Run Python scripts

 

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

• Azure SQL database features
• Managed Instances

 

Lab: Managed instances

 

Module 8: SQL Server on Linux

• 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