MCSA SQL Server Database Administration

Description

This 10 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. Additional it will be of use to individuals who develop applications that deliver content from SQL Server databases.

The second course provides students with the knowledge and skills to provision a Microsoft SQL Server 2016 database. The course covers SQL Server 2016 provision both on-premise and in Azure, and covers installing from new and migrating from an existing install.

Voor wie:
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.

Inhoud:
M20764 Administering a SQL Database Infrastructure
– 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
M20765 Provisioning SQL Databases
– 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

Deze certificering bestaat uit de volgende trainingen:
– M20764 Administering a SQL Database Infrastructure
– M20765 Provisioning SQL Databases

Exclusief examens:
– 070-764 Administering a SQL Database Infrastructure – Retired
– 070-765  Provisioning SQL Databases – Retired

DutchTrain is een officieel geaccrediteerd Test Center voor Pearson Vue Test, Prometric, Kryterion, Castle Worldwide, Certiport & PSI. U bent bij ons van harte welkom voor examens welke via deze Test Centers beschikbaar zijn. Examens kunnen elke dag, binnen kantooruren, worden afgenomen.

Datum:
Neem hiervoor contact op met een van onze opleidingsadviseurs.

Duur:
 10 dagen

Dit traject is ook beschikbaar als:
– Education On Demand (E-Learning)
– Maatwerktraining, neem hiervoor contact op met een van onze opleidingsadviseurs.

Voor veelgestelde vragen tijdens het bestelproces, bekijk onze F.A.Q. pagina.