We are happy to advise you!
+49 40 253346-10     Contact

Online training in the virtual classroom
E-Learning offers and more

Find out more

Fast Track: MCSA SQL 2016 Database Administration (FT-MCSA-SQL16-DBADM)

 

Course Overview

  • Einmaliger Kursbesuch 5 Tage
  • Original MOC Unterlagen (MOC20764 / MOC20765)
  • 2 Prüfungsvoucher für die Examen 70-764 und 70-765

Who should attend

Datenbank Administratoren, Datenbank Entwickler und Business Intelligence Professionals.

Prerequisites

  • Grundlegende Kenntnisse über das Microsoft Windows Betriebssystem sowie Kern Funktionalität.
  • Kenntnisse über relationale Datenbanken.
  • Grundlegende Kenntnisse zu Transact SQL

Course Objectives

Dieser 5-tägige Power Workshop kombiniert die Inhalte aus den beiden Microsoft SQL 2016 Kursen Administering a SQL Database Infrastructure (MOC 20764) sowie Provisioning SQL Databases (MOC 20765) und bereitet die Teilnehmer optimal auf die Prüfung zum MCSA: SQL 2016 Database Administration vor.

Course Content

Administering a SQL Database Infrastructure (MOC 20764)

  • Module 1: Authenticating and Authorizing Users
  • Module 2: Assigning Server and Database Roles
  • Module 3: Authorizing Users to Access Resources
  • Module 4: Protecting Data with Encryption and Auditing
  • Module 5: SQL Server Recovery Models
  • Module 6: Backup of SQL Server Databases
  • Module 7: Restoring SQL Server Databases
  • Module 8: Automating SQL Server Management
  • Module 9: Configuring Security for SQL Server Agent
  • Module 10: Monitoring SQL Server with Alerts and Notifications
  • Module 11: Introduction to Managing SQL Server by using PowerShell
  • Module 12: Tracing Access to SQL Server
  • Module 13: Monitoring SQL Server
  • Module 14: Troubleshooting SQL Server
  • Module 15: Importing and Exporting Data

Provisioning SQL Databases (MOC 20765)

  • Module 1: SQL Server 2016 Components
  • Module 2: Installing SQL Server 2016
  • Module 3: Upgrading SQL Server to SQL Server 2016
  • Module 4: Deploying SQL Server on Microsoft Azure
  • Module 5: Working with Databases
  • Module 6: Database Storage Options
  • Module 7: Performing Database Maintenance
Online Training

Duration 5 days

Price (excl. tax)
  • 3,790.- €
  • SA Voucher: 10
Digital courseware

Courseware language: English

Classroom Training

Duration 5 days

Price (excl. tax)
  • Germany: 3,790.- €
  • Switzerland: CHF 3,840.-
  • SA Voucher: 10
incl. catering
Catering includes:

  • Coffee, Tea, Juice, Water, Soft drinks
  • Pastry and Sweets
  • Fresh fruits
  • Lunch in a nearby restaurant

* Catering information only valid for courses delivered by Fast Lane.


Digital courseware

Courseware language: English

Schedule

FLEX™ Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.
German
Time zone CEST
09/11/2020 ― 13/11/2020 Online Training Time zone: CET Course language: German
09/11/2020 ― 13/11/2020 Online Training This is an German language FLEX course.
Time zone: CET
FLEX™ Classroom Training (hybrid course):   Course participation either on-site in the classroom or online from the workplace or from home.
Germany
09/11/2020 ― 13/11/2020 Munich
18/01/2021 ― 22/01/2021 Stuttgart
Switzerland
09/11/2020 ― 13/11/2020 Basel
09/11/2020 ― 13/11/2020 Bern
09/11/2020 ― 13/11/2020 Zurich This is an German language FLEX course.
Time zone: CET