Administering SQL Databases: 764 COMP 9693

Online Course Above Description

This is an Online course "Above Description Content" test text field.

Online placeholder logo
This is an Online course "Description" test text field.

Online Course Below Description

This is an Online course "Below Description Content" test text field.

Online Course Additional Information Note

This is an Online course "Additional Information Note Content" test text field.

Online Course Disclaimer

This is an Online course "Disclaimer Content" test text field.

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.

Prerequisites

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

Hours and Fees

Hours

42

Fee

$406.58

Course Essentials:

You must have Microsoft SQL Server 2016 Express Edition (which can be downloaded for free from Microsoft). This software requires a computer with a 2 GHz (or greater) processor, 8 GB (or greater) RAM, and a Microsoft Windows 8 (or higher) 64-bit operating system. (You can complete this course using a 32-bit operating system but, if you wish to move on from this course, you will need a 64-bit operating system.)

Contact Department:
Construction, Technology & Trades Department
Phone:
416-415-5000, ext. 4861
Office Location(s):
Casa Loma Campus, 160 Kendal Ave., Building C (CLC), Room C426

Read about our textbooks policy, and remember that the Continuing Education attendance policy and closure dates differ from those for full-time college programs.