Skip Navigation
Centennial College logo
  • Visit Us
  • Donate
  • Quick Links
  • Start Here
    Information For:
    • Future Students
    • New Students
    • Current Students
    • Part-time Students
    • International Students
    • Faculty and Staff
    • Parents and Supporters
    • Alumni
    • Transfer Student
    • Micro-Credentials Students
    • Partner with Centennial
  • Programs
  • Admissions
  • Financial Aid
  • International Education
  • Student Life
  • About
  • Apply Now
  • Donate
  • Apply Now

Microsoft SQL Server 2012

Course CodeCEDN-004
Lecture hours per week
Lab hours per week
Course AvailabilityOpen
Description

The Microsoft SQL Server 2012 course covers the design and implementation of databases using the enterprise edition of this software.

As part of the introductory undertaking, you will learn about the design aspects of databases and then extend your expertise through additional skill-building exercises to implement, secure and optimize various database configurations.

Hands-on aspects of the course will allow you to gain practical experience with essential database tasks and build real-world database solutions in Centennial College's equipped labs.

You will also enjoy demonstrations, lectures and discussions that further your knowledge of topics such as retrieving data from a single table, retrieving data from two or more tables, working with data types, using the Management Studio for database design, coding scripts, working with cursors, working with XML and more.

In addition to serving as preparation for MCAD or MCSD certification for Microsoft .NET, this Microsoft SQL Server 2012 course will give you the ability to use all of the components of SQL Server 2012 enterprise edition, including:

  • Developing a logical data model;
  • Implementing the physical database;
  • Retrieving and modifying data;
  • Programming business logic;
  • Tuning and optimizing data access;
  • Designing a database security plan.
Centennial College logo
Image about Canada's Top 502022 top employer Centennial College logo
  • Programs
  • Admissions
  • Student Life
  • Financial Aid
  • About Centennial
  • Careers
  • myCentennial
  • Centennial Luminate
  • Library and Learning
  • Parents and Supporters
  • Partner with Centennial
  • Faculty and Staff
  • Media Room
  • Accessibility
  • Legal
  • Site Map
  • Contact Us
  • 416-289-5000
© 2025 Centennial College. All Rights Reserved.