Advanced search

DB-UPGRADE Updating Your Skills to the newest SQL Server Print

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

Accredited course for Continuing Education of Pedagogical Staff

Course length: 2 days (8:30 - 16:00)

Dates

Date PlaceLanguagePrice (without VAT)Availability
11/23/2020 - 11/24/2020 Prague cs 11 800 CZK Free date
PDF to download Expand allCollapse all
  • Students will be able to

    • Describe key capabilities and components of SQL Server
    • Describe new and enhanced features in SQL Server
    • Provide upgrade and migration
  • Course requirements

    • Experience of building and managing database, data warehouse, and business intelligence (BI) solutions
    • Familiarity with the Windows Server OS
  • This course is intended for

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

  • Literature

    All participants will get internal OKsystem 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

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

    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

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

    • Lesson 1: SQL Graph
    • Lesson 2: Database engine
    • Lesson 3: In-Memory Engine

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

    • Lesson 1: Power BI report Server
    • Lesson 2: Reporting Services

    Module 5: New Features in SQL Server Analysis Services

    • Lesson 1: Tabular model updates
    • Lesson 2: Multidimensional model updates

    Module 6: New and Enhanced data Analytics Features

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

    Module 7: Upgrade and migration

    • Lesson 1: Prerequisites, preparation
    • Lesson 2: Upgrade
    • Lesson 3: Migration
OKsystem a.s.
We use cookies to optimize site functionality and deliver best results based on your interests. More info