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
- Lab : Performance and availability – adaptive query processing
- 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.
Module 4: What's new in SQL Server Reporting and BI
- This module describes what's new in SQL Server reporting and BI.
- Reporting Services update
- 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.
- 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
- 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
- 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.
- 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 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