APPLY NOW! SEE PROGRAMS VISIT US EVENTS

Search Programs

Search Full-Time Search Part-Time

search full-time & part-time programs
Search
HOME
PROGRAMS & COURSES
- PROGRAMS & COURSES
- WINTER 2021 FULL-TIME PROGRAM DELIVERY
  - Returning and Fast-Track Students
- FULL-TIME
- PART-TIME
- SCHOOLS
- APPRENTICESHIP PROGRAMS
- CANADA-ONTARIO JOB GRANT
  - Part-time Programs
  - Full-time Programs
- COLLEGE & UNIVERSITY PREPARATION
- CO-OP EDUCATION
- DEGREE PROGRAMS
- DUAL CREDIT
- FAST TRACK
- GRADUATE CERTIFICATE PROGRAMS
- JOINT PROGRAMS
- SECOND CAREER
- WINTER 2021 PROGRAMS - WORTH A SECOND LOOK
- BRING IT
- FULL-TIME ONLINE PROGRAMS
- BUSINESS ANALYTICS AND INSIGHTS
ONLINE LEARNING
ADMISSIONS
- ADMISSIONS
- HOW TO APPLY
  - Admission Requirements
  - Offers of Admission
- INTERNATIONAL EDUCATION
  - How to Apply
  - Tuition and Fees
  - Payment Options for International Students
  - About the International Centre
  - Contact Centennial International
  - Where is Centennial in the World?
  - Frequently Asked Questions
  - Programs
  - Scholarships
  - Why Choose Centennial College
  - Suzhou Centennial College
- TUITION AND FEES
  - Ancillary Fees
  - Ancillary Fees FAQs
  - Pay Your Tuition
  - Tuition Information
  - English Language Learning Program Fees
- SKILLS ASSESSMENT
- EDUCATION PATHWAYS AND PARTNERSHIPS
  - Pathways by School
  - Pathways to Credit
  - Pathways Options
  - Pathways and Academic Partnerships
  - Partner Pathway Events
- LANGUAGE PROFICIENCY INFORMATION
  - English as a Second Language Partnerships
- PREPARING FOR YOUR FIRST CLASS
- FREQUENTLY ASKED QUESTIONS
- ACCOMMODATIONS FOR APPLICANTS WITH DISABILITIES
- CONFIRM YOUR OFFER
- FORMS
- PUBLICATIONS FOR FUTURE STUDENTS
- STUDENT RECORDS
  - Get your Sin in to Win! Contest
  - How can I enter my SIN in the college's system
  - Tax Information Page
- PROGRAM ADMISSION SESSIONS
- YOU BELONG
  - Publications
  - Guidance Counsellors
  - Enter To Win Form
  - Booking Request Form
  - Events
- REGISTRATION INFORMATION
  - Timetable Codes Guide
  - Support and Services Videos
  - Student Success Advisors
  - Academic Schools Contact List
  - Student Success Resources
  - Registration Forms
  - Skills Assessment
  - How to Access Microsoft Teams
  - International Orientation Sessions
  - Orientation for All Students
  - First-Year Student Checklist
  - How to Access the Virtual Registration Services Request Form
  - GNED Course Descriptions
  - Fall 2020 BScN/Liberal Studies Electives
  - OntarioLearn Fall 2020 GNED Course Offerings
  - Web Registration
- WEBINARS
- HEADSTART PRE-ARRIVAL PROGRAM
- FALL AND WINTER SEMESTER DATES AND DEADLINES
FINANCIAL AID
- FINANCIAL AID
- OSAP INFORMATION
- START PLANNING NOW
  - Secure the Bag: Money Management & Business Start-Up Virtual Workshops
- DOORWAY TO DOLLARS QUESTIONNAIRE
  - Submit Questionnaire
- CENTENNIAL COLLEGE BURSARIES
- MINISTRY PARTNERED BURSARIES
- ACADEMIC SCHOLARSHIPS AND AWARDS
- APPLICATION SCHOLARSHIPS AND AWARDS
- FULL SCHOLARSHIP LISTING (2020 - 2021)
- CENTENNIAL COLLEGE WORK STUDY PROGRAM
- SCHOLARSHIP AND BURSARY FREQUENTLY ASKED QUESTIONS
- AN AFFORDABLE ONTARIO COLLEGE EDUCATION
  - Centennial Electronic Funds Transfer (EFT) Submissions
- TUITION PAYMENT FLEXIBILITY
STUDENT LIFE
- STUDENT LIFE
- STUDENT SERVICES
- CAMPUS SERVICES
- MYCARD
- CAREER SERVICES AND CO-OPERATIVE EDUCATION
- STUDENT HEALTH AND WELLNESS
- ATHLETICS AND RECREATION
- STUDENT ASSOCIATION
- CONVOCATION
- DEVELOPMENT AND ALUMNI ENGAGEMENT
- ENROLMENT SERVICES
- LIBRARIES
  - Library Hours
  - Booking A Tutor
- RESIDENCE
- STUDENT SUCCESS
ABOUT CENTENNIAL
- ABOUT CENTENNIAL
- 50TH ANNIVERSARY
- ABOUT US
- CAMPUSES
- CAREERS AT CENTENNIAL
- COLLEGE IMPROVEMENTS
- COLLEGE OVERVIEW
- COMMUNITY COMMITMENT
- CONTACT US
- CORPORATE INFORMATION
- SAFETY AND SECURITY
- PRESIDENTIAL SEARCH
- TEDX
  - Resilience
- GLOBAL INFLUENCERS RESIDENCY PROGRAM
- SUSTAINABILITY AT CENTENNIAL
INDIGENOUS EDUCATION
- INDIGENOUS EDUCATION
- OUR STORIES: FIRST PEOPLES IN CANADA
- ABOUT US
- INDIGENOUS ACKNOWLEDGEMENT
- ABORIGINAL EDUCATION COUNCIL
- INDIGENOUS STUDIES CERTIFICATE
- ABORIGINAL MENTAL HEALTH RESOURCES
- INDIGENOUS STUDENT SELF-IDENTIFICATION - FAQS
- INDIGENOUS STRATEGIC FRAMEWORK PILLARS
- COVID-19 UPDATES AND COMMUNICATIONS FOR STUDENTS
CENTRES AND INSTITUTES
- CENTRES AND INSTITUTES
- CENTRE FOR GLOBAL CITIZENSHIP EDUCATION AND INCLUSION
- EMERGENCY MANAGEMENT AND PUBLIC SAFETY INSTITUTE
- CENTENNIAL ENERGY INSTITUTE
- TEACHING EXCELLENCE AND ACADEMIC QUALITY
- IELTS TEST CENTRE
- CENTRE FOR ACADEMIC ENGLISH
  - Policies and Guidelines
  - Contact Us
- TESTING SERVICES
- APPLIED RESEARCH, INNOVATION AND ENTREPRENEURSHIP SERVICES
INDUSTRY
EVENTS
VISIT US
CONNECT
VIRTUAL OPEN HOUSE
- VIRTUAL OPEN HOUSE
- JULY 25 WEBINARS
- PRE-RECORDED WEBINARS
- PROGRESS CAMPUS
- ASHTONBEE CAMPUS
- DOWNSVIEW CAMPUS
- STORY ARTS CENTRE
- MORNINGSIDE CAMPUS
GIVING
COVID-19 STUDENT INFORMATION CENTRE
- COVID-19 STUDENT INFORMATION CENTRE
- CANADIAN STUDENTS
  - Fall 2020 Semester
- INTERNATIONAL STUDENTS
- COVID-19 SECOND WAVE ACTION PLAN
- FAQS
- CENTENNIAL COVID-19 RELIEF BURSARY
- STUDENT SERVICES AND SUPPORT
- LEARNING RESOURCES
- CONTACT US
CAREERS
- CAREERS
- JOB OPPORTUNITIES
- DID YOU KNOW
- EMPLOYEE BENEFITS
- DIVERSITY AND INCLUSION
MYAPPLICATION
Student Hub
Library
Parents and Supporters
416-289-5000 Contact Us

While our campuses remained closed to most students/staff, many services and supports are offered online via our COVID-19 Information Centre.

COVID-19 INFO

close announcement

Have Questions?

Microsoft SQL Server Implementation 2

Course Code	CEMS-961
Lecture hours per week
Lab hours per week
Course Availability:	Open
Description:	In this course, a continuation of CEMS-955, you will continue your focus on designing and implementing an efficient database architecture with Microsoft SQL Server. You will learn how to "lock" options and transactions to ensure data concurrency and recoverability, how to design and create views of data, how to design and create "triggers", and how to work with distributed data.

TOP OF PAGE