10998: Updating Your Skills to SQL Server 2017

10998: Updating Your Skills to SQL Server 2017

Audience

The primary audience for this course is existing database professionals with experience of SQL Server 2016 who want to update their skills to SQL Server 2017.

The secondary audience is existing SQL Server 2016 MCSAs who want to prepare for the Upgrade exam for SQL Server 2017 certification.

Prerequisites

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.

Duration

2 days.

Course Objectives

This two-day instructor-led course is aimed at database professionals looking to update their skills to cover SQL Server 2017.

After completing this course, students will be able to:

  • Describe key capabilities and components of SQL Server 2017
  • Describe new and enhanced features in SQL Server Performance, Availability, and Scalability
  • Describe new and enhanced features in SQL Server data access
  • Describe new and enhanced features in SQL Server reporting and BI
  • Describe new and enhanced features in SQL Server OLAP
  • Describe new and enhanced data analytics features
  • Describe new and enhanced features in SQL Server Cloud deployments
  • Describe SQL Server on Linux functionality

Course Content

Module 1: Introduction to 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
Adaptive query processing
Automatic tuning
Availability Scalability
Lab : Performance and availability – adaptive query processing
After completing this module, students will be able to:
• 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 Graph
Lab : SQL Graph
After completing this module, students will be able to:
• Describe SQL Graph

Module 4: What’s new in SQL Server Reporting and BI
Power BI report Server
Reporting Services update
Lab : Reporting and BI
After completing this module, students will be able to:
• Explain what Power BI report server is
• Use Power BI report server
• Create a Power BI report for Power BI report server

Module 5: New and Enhanced Features in SQL Server Analysis Services
Tabular model updates
Lab : Ragged hierarchies
After completing this module, students will be able to:
• Describe the new features of tabular data models

Module 6: New and Enhanced data Analytics Features
New and enhanced data analytics features
Lab : Data analytics with Python
After completing this module, students will be able to:
• Describe the new and enhanced data analytics features

Module 7: What’s new in SQL Server in the Cloud
Azure SQL database features
Managed Instances
Lab : Managed instances
After completing this module, students will be able to:
• Explain the different features available in Azure SQL database and SQL Server 2017
• Describe Azure managed instances

Module 8: SQL Server on Linux
SQL Server on Linux
Deploying SQL Server on Linux
Lab : SQL Server in Docker containers
After completing this module, students will be able to:
• Describe the features of SQL Server on Linux
• Describe SQL Server on Linux deployment
• Deploy SQL server in a Docker container

Virtual Courses

ALL of our courses can be delivered virtually. And our Bath public schedule of courses are now available as live virtual sessions, using the popular Zoom Virtual Classroom and remote labs. Delegates can test their access at: www.zoom.us/test

On-Site Courses

Can't attend one of our public classes? Booking for multiple people?

All our courses are available on your site! Delivered for your staff, at your premises.

Contact us to find out more...