| Drucken |

MOC20764 Administering a SQL Database Infrastructure

Beginn:
24. Aug 2020
Ende:
28. Aug 2020
Kurs-Nr.:
M20764
Preis:
2145,00 EUR pro Platz (zzgl. MwSt.)

Beschreibung

This five-day instructor-led course provides students who administer and maintain SQL Server databases with the knowledge and skills to administer a SQL server database infrastructure. Additionally, it will be of use to individuals who develop applications that deliver content from SQL Server databases. 

The primary audience for this course is individuals who administer and maintain SQL Server databases. These individuals perform database administration and maintenance as their primary area of responsibility, or work in environments where databases play a key role in their primary job.

The secondary audiences for this course are individuals who develop applications that deliver content from SQL Server databases.

Inhalte

  • SQL Server Security
  • Assigning Server and Database Roles
  • Authorizing Users to Access Resources
  • Protecting Data with Encryption and Auditing
  • Recovery Models and Backup Strategies
  • Backing Up SQL Server Databases
  • Restoring SQL Server 2016 Databases
  • Automating SQL Server Management
  • Configuring Security for SQL Server Agent
  • Monitoring SQL Server with Alerts and Notifications
  • Introduction to Managing SQL Server by using PowerShell
  • Tracing Access to SQL Server with Extended events
  • Monitoring SQL Server 
  • Troubleshooting SQL Server
  • Importing and Exporting Data

Voraussetzungen

In addition to their professional experience, students who attend this training should already have the following technical knowledge:

  • Basic knowledge of the Microsoft Windows operating system and its core functionality.
  • Working knowledge of Transact-SQL.
  • Working knowledge of relational databases.
  • Some experience with database design.

Seminarzeiten

Dieses Seminar findet täglich von 9:00 – ca. 17:00 Uhr statt.

Seminarsprache und - unterlagen

Die Seminarsprache ist Deutsch, die Seminarunterlagen werden in englischer Sprache zur Verfügung gestellt.

Enthaltene Leistungen

Im Seminarpreis sind die Seminarunterlagen, die Pausenverpflegung (Kaffee, Tee, kalte Getränke, Kekse, Süßigkeiten) sowie die Mittagsverpflegung enthalten.

Zertifizierungen

MCSA: SQL 2016 Database Development

Weiterführende Seminare

MOC10986 Updating Your Skills to SQL Server 2016

MOC20761 Querying Data with Transact-SQL

MOC20762 Developing SQL Databases

MOC20767 Implementing a SQL Data Warehouse

MOC20768 Developing SQL Data Models

Referenzen

SQL Server

SQLServer

MySql

PowerShell


Diesen Kurs buchen: MOC20764 Administering a SQL Database Infrastructure

Wenn Sie bereits registriert sind, bitte hier direkt einloggen

Einzelpreis


Teilnehmerdaten

Rechnungsadresse

Ich akzeptiere die Allgemeinen Geschäftsbedingungen. *

* notwendige Angaben

Kategorie

Nach oben