We are happy to advise you!
+49 40 253346-10     Contact
> > > FT-MCSA-SQL16-DBADM

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
Classroom Training

Duration 5 days

Price (excl. tax)
  • Germany: 3,790.- €
  • 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

Dates and Booking
 
Click on town name to book Schedule
Germany
17/02/2020 - 21/02/2020 Frankfurt
11/05/2020 - 15/05/2020 Hamburg
03/08/2020 - 07/08/2020 Berlin
09/11/2020 - 13/11/2020 Munich
Switzerland
09/11/2020 - 13/11/2020 Zurich
 

Cookies improves our services. We need your permission for the individual use of data. By clicking on this website, on a link or on "OK" you give your permission. You can opt out here.
OK