Home » Trainings Shop » 10998 Updating Your Skills to SQL Server 2017
Course ID: #n. v.

10998 Updating Your Skills to SQL Server 2017

Dauer: 2 Tage Daten:

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

1 – INTRODUCTION TO SQL SERVER 2017

  • Overview of SQL Server 2017
  • Functionality across versions

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

3 – WHAT’S NEW IN SQL SERVER DATA ACCESS

  • SQL Graph
  • Lab : SQL Graph

4 – WHAT’S NEW IN SQL SERVER REPORTING AND BI

  • Power BI report Server
  • Reporting Services update
  • Lab : Reporting and BI

5 – NEW AND ENHANCED FEATURES IN SQL SERVER ANALYSIS SERVICES

  • Tabular model updates
  • Lab : Ragged hierarchies

6 – NEW AND ENHANCED DATA ANALYTICS FEATURES

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

7 – WHAT’S NEW IN SQL SERVER IN THE CLOUD

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

8 – SQL SERVER ON LINUX

  • SQL Server on Linux
  • Deploying SQL Server on Linux
  • Lab : SQL Server in Docker containers
Lernlösung

Blended Learning, Firmenseminar, Individualcoaching, Klassenraumtraining, Online Live Webinar
Sprache

Deutsch, Englisch, Französisch, Italienisch
Daten

auf Anfrage

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.

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

Ähnliche Produkte

  • Course ID: #AZ900

    AZ-900T01 Microsoft Azure Fundamentals

    This course will provide foundational level knowledge of cloud services and how those services are provided with Microsoft Azure. The course can be taken as an optional first step in learning about cloud services and Microsoft Azure, before taking further Microsoft Azure or Microsoft cloud services courses.

    Dauer: 1 Tag
    Price:
    CHF750 – CHF2'700 zzgl. MwSt
    AZ-900T01 Microsoft Azure Fundamentals
  • Course ID: #10993

    10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure

    Themen dieses Seminars sind die Integration einer On-premises-AD-DS-Umgebung mit Azure AD und die Nutzung von Azure AD als Verzeichnisdienst. Ausserdem erfahren die Teilnehmer, wie man Azure RMS verwendet, um sensible Dokumente zu schützen. Schliesslich lernen sie, die Authentifizierung mit Mehr-Faktor-Authentifizierung zu erweitern und die Funktionsfähigkeit der Verzeichnisdienstsynchronisation zu überwachen.

    Dauer: 2 Tage
    Price:
    CHF1'650 – CHF5'400 zzgl. MwSt
    10993 Integrating On-Premises Identity Infrastructure with Microsoft Azure
  • Course ID: #

    AZ-300T02 Implementing Workloads and Security

    This course teaches IT professionals how to discover, assess, plan and implement a migration of on-premises resources and infrastructure to Azure. Students will learn how to use Azure Migrate to perform the discovery and assessment phase that is critical to a successful migration. The course focuses primarily on using ASR on a Hyper-V infrastructure to prepare and complete the migration process.

    Dauer: 1 Tag
    Price:
    CHF770 zzgl. MwSt
    AZ-300T02 Implementing Workloads and Security
  • Course ID: #

    DP-201T01 – Designing an Azure Data Solution

    In this course, students will design various data platform technologies into solutions that are in line with business and technical requirements. This can include on-premises, cloud, and hybrid data scenarios which incorporate relational, No-SQL or Data Warehouse data. Students will also learn how to design process architectures using a range of technologies for both streaming and batch data.

    Dauer: 2 Tage
    Price:
    CHF2'320 zzgl. MwSt
    DP-201T01 – Designing an Azure Data Solution

CHF1'550 zzgl. MwSt

Leeren

ANMELDEN

Newsletter

Erhalten Sie aktuelle Informationen zu neuen Schulungen, Angeboten und Aktionen per E-Mail.

Email Subscription
Microsoft Office
Alle anzeigen
Microsoft Tech
Alle anzeigen
Business & Soft Skills
Prozess- und Qualitätsmanagement
Projektmanagement
Adobe
CompTIA
Security
Linux
Oracle
Amazon
Google
Leadership and Professional Development
E-Learning und LMS