-
Government of Canada Approved Supplier • CAITTS Standing Offer: E60ZH-140001/048/ZH • Book a Consultation
CONTACT US

55316 Administering a SQL Database

This course will provide training in how to administer and maintain SQL Server, Azure SQL Database and other cloud-based SQL Server databases. IT professionals who work in environments where databases play a key role in their job will find this material useful. By using demonstrations and hands-on lab exercises, students will learn to carry out these important tasks. This course covers content that was in retired Microsoft Course 20764: Administering a SQL Database Infrastructure.
Days 5
Carol Miller
$2,295.00
Excl.HST
All Locations
All Categories
(GMT-05:00) Eastern Time (US & Canada)

Course Description

After completing this course, you will be able to: Authenticate and authorize users Assign server and database roles Authorize users to access resources Use encryption and auditing features to protect data Describe recovery models and backup strategies Backup and 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

Prerequisites

Experience using applications on Windows Servers Experience working with SQL Server or another RDMS

View/ Download course details

Download
Interested?

None of these dates work for you? 
Suggest another date and location!

Inquire

Related
Courses

Establish your skillset using vendor approved courses, and earn the certifications you need.
GET IN TOUCH

We would love to 
hear from you!

We’re here to make learning easy and enjoyable. Our dedicated training consultant is ready to guide you through a comprehensive solution tailored to your needs.

SEARCH

Sign Up for Our Newsletter!