Administering SQL Databases: 764 COMP 9692

Our Administering SQL Databases: 764 course teaches you how to secure an SQL database through the use of security models, users and user roles. Learn how partially contained databases are used to ensure data is not compromised in the event of a breach, as well as how encryption is used to protect data within a database server. Explore how to backup and restore databases in the event of a catastrophic server event and how to audit a server to determine any server-related issues or operating system errors. This database administration course can be used as part of your study material for the Microsoft Certified Solutions Associate (MCSA) SQL 2016 database certifications.

Also check out our online course: COMP 9693 Administering SQL Databases: 764 (Distance Learning)

Prerequisites

You must have completed our COMP 9690 Querying Data with Transact-SQL: 761 course or our COMP 9691 Querying Data with Transact-SQL: 761 (Distance Learning) course. (An approved equivalent is also acceptable.)

Hours and Fees

Hours

42

Fee

$409
(includes a non-refundable materials fee of $100 [online access])

Contact Information

Course Sections

There are no classes currently scheduled for this course; however, check back often to see if we have developed additional schedules for fall and winter (through to April). If you would like to receive an email notification when the spring/summer term (May to August) is released, complete our sign-up form.

Some courses require you to purchase a textbook. The cost of the textbook is not included in the course fee unless otherwise indicated. If there is a textbook assigned for this course, it will be listed on the bookstore website.