> > > FT-MCSA-SQL16-DBADM

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

Course Description Schedule Fast Track: MCSA SQL 2016 Database Administration - Download PDF Download PDF
 

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
Modality: C

Duration 5 days

Price (excl. tax)
  • Germany: 3,790.- €
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 Dates and Booking
 
Click on town name to book Schedule
Germany
21/01/2019 - 25/01/2019 Munich
25/02/2019 - 01/03/2019 Berlin
01/04/2019 - 05/04/2019 Frankfurt
06/05/2019 - 10/05/2019 Düsseldorf
03/06/2019 - 07/06/2019 Munich
22/07/2019 - 26/07/2019 Münster
19/08/2019 - 23/08/2019 Hamburg
23/09/2019 - 27/09/2019 Berlin
21/10/2019 - 25/10/2019 Frankfurt
02/12/2019 - 06/12/2019 Düsseldorf
Switzerland
21/01/2019 - 25/01/2019 Zurich
17/06/2019 - 21/06/2019 Zurich
 

Cookies help us deliver our services. By using our services, you agree to our use of cookies.   Got it!