In addition to their professional experience, students who attend this training should already have the following technical knowledge:
- Experience of building and managing database, data warehouse, and business intelligence (BI) solutions with SQL Server 2016.
- Familiarity with the Windows Server 2016 operating system and networking.
- Familiarity with Microsoft Office 2016.
Detailed Class Syllabus
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
Module 3: What’s New in SQL Server data Access
Module 4: What’s new in SQL Server Reporting and BI
Power BI report Server
Reporting Services update
Module 5: New and Enhanced Features in SQL Server Analysis Services
Tabular model updates
Module 6: New and Enhanced data Analytics Features
New and enhanced data analytics features
Module 7: What’s new in SQL Server in the Cloud
Azure SQL database features
Module 8: SQL Server on Linux
SQL Server on Linux
Deploying SQL Server on Linux