School of Distance Education

SQL Database Administration Certificate

Our SQL Database Administration Certificate teaches you to install, configure, maintain and upgrade an SQL database server in a small or large environment. Learn simple to advanced SQLstatements for retrieving data from a database, and develop the knowledge needed to secure, back up and restore data. This certificate is valuable preparation for those looking to obtain Microsoft Certified Solutions Associate (MCSASQL 2016 database certifications.

Print out the Certificate Fact Sheet

CAREER OPPORTUNITIES

Career options typically include database administrator or infrastructure specialist positions.

Completion Details

We recommend that you complete the compulsory courses in the order shown below. However, the order in which you complete the course requirements is only restricted by course prerequisites.

Courses

Our introductory Querying Data with Transact-SQL (761) course teaches you how to retrieve, insert and delete data from a relational database using Transact-SQL. Learn to query data from single and joined tables, use query filters to retrieve specific data, create insert statements for placing data from multiple tables into a single table and update table data. Develop the ability to maintain data integrity when removing or deleting records from a database. Explore the concepts of creating and using stored procedures. This course can be used as part of your study material for the Microsoft Certified Solutions Associate (MCSASQL 2016 database certifications. 

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.)

CONTACT INFORMATION

Phone: 416-415-5000, ext. 4861
Email: cetechnology@georgebrown.ca

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 (MCSASQL 2016 database certifications.

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 9691 Querying Data with Transact-SQL (761) course or an approved equivalent.

CONTACT INFORMATION

Phone: 416-415-5000, ext. 4861
Email: cetechnology@georgebrown.ca

Our Provisioning SQL Databases (765) course teaches you how to install and configure an SQL2016 database server as well as how to upgrade older SQL servers to the 2016 version. Learn to deploy an SQL server with Microsoft Azure and how to manage a server within a virtualized environment. Gain an understanding of how to manipulate and move SQL server files in order to move databases from one partition or server to another. Set up and configure SQL server maintenance and perform ongoing maintenance to secure and protect data. This course can be used as part of your study material for the Microsoft Certified Solutions Associate (MCSASQL2016 database certifications. 

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 9693 Administering SQL Databases (764) course or an approved equivalent.

CONTACT INFORMATION

Phone: 416-415-5000, ext. 4861
Email: cetechnology@georgebrown.ca