416 289 5000
1-800-268-4419 (in Ontario)

P.O. Box 631 Station A
Toronto, ON, M1K 5E9

SQL Server 2012 Administration

Course Code SSDP-002
Course Name SQL Server 2012 Administration
Category Information Technology & Computers
Description SQL Server 2012 Administration provids the necessary knowledge to administer a SQL Server instance.

The course uses a lecture-demo-group exercise approach to examine topics that include database maintenance, backup strategies and types of backups, security and regulatory compliance, disaster recovery, database restore strategies, design and performance improvement, cloud computing for the database administrator and more.

Assignments and a final exam comprise your grade.

You will find SQL Server 2012 Administration useful if you are considering a career as a database administrator or are currently an IT professional curious about what SQL Server is about and how to manage it. It will also be useful if you are a non-SQL server administrator using ORACLE, Sybase or DB2 and are interested in SQL Server.

This offering will prepare for you Microsoft exams 70-462 (Administering Microsoft SQL Server 2012 Databases) and 70-465 (Designing Database Solutions for Microsoft SQL Server 2012). It will also give you the knowledge and confidence to:

• Plan and install SQL;
• Configure and manage SQL Server instance and other server components;
• Manage access users' logins and roles;
• Import and export data;
• Design and implement a database security plan;
• Maintain indexes;
• Install and maintain databases;
• Resolve concurrency problems;
• Back up and restore databases.

Contact Telephone 416-289-5207
Contact E-mail
Associated Programs
New Search
Section Cost Semester Start Date End Date Meeting Times Campus
There are no sections for this course at this time.
Legend for Days
M - Monday T - Tuesday W - Wednesday R - Thursday F - Friday S - Saturday U - Sunday
TBA - To Be Announced