Advanced search

M10998 Updating Your Skills to SQL Server 2017 Print

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

Accredited course for Continuing Education of Pedagogical Staff

Course length: 2 days


List price: 14 300 CZK (without VAT)

This course has no dates set. If you are interested in setting a new one, please contact skoleni@oksystem.cz.

PDF to download Expand allCollapse all
  • 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 requirements

    • 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.
  • This course is intended for

    This course is intended for System Administrators, Database Administrators and Database Developers.

  • Literature

    All participants will get original Microsoft student materials.

  • Hardware

    Classrooms are equipped with high-performance computers with Internet access and the possibility of wireless connection.

  • Syllabus

    Module 1: Introduction to SQL Server 2017

    • Lesson 1: Overview of SQL Server 2017
    • Lesson 2: Functionality across versions

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

    • Lesson 1: Adaptive query processing
    • Lesson 2: Automatic tuning
    • Lesson 3: Availability Scalability
    • Lab: Performance and availability

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

    • Lesson 1: SQL Graph
    • Lesson 2: Database engine
    • Lab: SQL Graph

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

    • Lesson 1: Power BI report Server
    • Lesson 2: Reporting Services update
    • Lab: Reporting and BI

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

    • Lesson 1: Tabular model updates
    • Lab : Ragged hierarchies, DAX

    Module 6: New and Enhanced data Analytics Features

    • Lesson 1: New and enhanced data analytics features
    • Lab: Data analytics with Python

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

    • Lesson 1: Azure SQL database features
    • Lesson 1: Managed Instances
    • Lab: Managed instances

    Module 8: SQL Server on Linux

    • Lesson 1: SQL Server on Linux
    • Lesson 2: Deploying SQL Server on Linux
    • Lab: SQL Server in Docker containers
  • Dependencies

    SQL Server

    SQL Server
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests.