Administering a SQL Database Infrastructure (20764)

Category ID Duration Level Price
SQL Server M20764 5 Day(s) Intermediate $3,095.00

Administering a SQL Database Infrastructure (20764)

Austin, TX Class Schedule

Delivery Format Date Time Register
Classroom Virtual 12/07/2020 - 12/11/2020 10:00 AM - 5:00 PM EST Register

Austin Training Center


700 Lavaca

Suite 1400

Austin, TX 78701

Call Us

US Toll Free 844-238-8607

Email Us

Course Overview

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

Course Objectives

Lesson objectives help students become comfortable with the course, and also provide a means to evaluate learning. Upon successful completion of this course, students will be able to: · Authenticate and authorize users · Assign server and database roles · Authorize users to access resources · Protect data with encryption and auditing · Describe recovery models and backup strategies · Backup SQL Server databases · Restore SQL Server databases · Automate database management · Configure security for the SQL Server agent · Manage alerts and notifications · Managing SQL Server using PowerShell · Trace access to SQL Server · Monitor a SQL Server infrastructure · Troubleshoot a SQL Server infrastructure · Import and export data

MCSA: SQL 2016 Database Administration

To ensure successful completion of this course, we recommend the following: · 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.

Productivity Point Learning Solutions evolved out of a desire to increase our outreach both nationally and internationally.

Productivity Point Headquarters
1580 Sawgrass Corporate Parkway
Suite 205
Sunrise, Florida 33323
United States

T 1-844-238-8607
P 1-954-425-6141
F 1-954-928-9057

© Copyright 2020 Productivity Point Learning Solutions. All Rights Reserved.