• Administering SQL Databases (764) COMP 9693

    New
    Continuous Intake Online

    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 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 in-class Administering SQL Databases (764) course.

    Note(s)

    This is an online course, and registration is offered through continuous intake (meaning registration is open 24 hours a day, 7 days a week throughout the year). Register in the section (CRN) with the Date(s) range that includes the date on which you plan to start the course (keeping in mind that you will receive your course details approximately a week after you register). You have 120 calendar days from the day you receive the course details to complete the course. You will be required to obtain Microsoft SQL Server 2016 Express Edition for this course (which can be downloaded free from Microsoft). This software requires a computer with 2 GHz processor or greater, 8 GB RAM or greater and a Microsoft Windows 8 (64-bit) operating system or higher. (You can complete this course using SQL 2012 at 32 bit. However, if you wish to move on from this course, you will need a 64-bit operating system.)

    Prerequisite(s)

    You must have completed our COMP 9690 Querying Data with Transact-SQL (761)/COMP 9691 Querying Data with Transact-SQL (761) course or an approved equivalent.

    Contact Information

    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.