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
- FALL 2021 FULL-TIME PROGRAM DELIVERY
  - Returning 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
- BRING IT
- FULL-TIME ONLINE PROGRAMS
- BUSINESS ANALYTICS AND INSIGHTS
- MICRO-CREDENTIALS
  - OSAP Approved Micro-Credential Programs 2021
  - Micro-Credential Programs
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
  - International Development Week
- 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 to Credit
  - Pathways Options
  - Pathways and Academic Partnerships
- 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
  - Tax Information Page
- PROGRAM ADMISSION SESSIONS
- YOU BELONG
  - Publications
  - Guidance Counsellors
  - Enter To Win Form
  - Booking Request Form
  - Events
- REGISTRATION INFORMATION
  - International Student Information and FAQs
  - Student Success Advisors
  - Academic School Contacts
  - Skills Assessment
  - Student Success Resources
  - Student Success Videos
  - myCard
  - Student Orientation
  - myCentennial Access
  - eCentennial and Learner Supports
  - How to Access - Microsoft Teams
  - Web Registration Video Guides
  - Web Registration Step-by-Step Guides
- WEBINARS
- HEADSTART PRE-ARRIVAL PROGRAM
- 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
- 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
  - Marketplace
  - Past Convocation Ceremonies
- DEVELOPMENT AND ALUMNI ENGAGEMENT
- ENROLMENT SERVICES
- LIBRARIES
  - Library Hours
  - Booking A Tutor
- RESIDENCE
- STUDENT SUCCESS
- EXPERIENCE CENTENNIAL ORIENTATION
- STUDENT TOWN HALL
- OUR CAMPUS IS WHERE YOU ARE! (OCIWYA)
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
- TREATIES WEEK AND INDIGENOUS EDUCATION MONTH
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
- ASSESSMENT CENTRE
- APPLIED RESEARCH, INNOVATION AND ENTREPRENEURSHIP SERVICES
- ARIES
INDUSTRY
EVENTS
VISIT US
CONNECT
OPEN HOUSE ON DEMAND
- OPEN HOUSE ON DEMAND
- JULY 25 WEBINARS
- PRE-RECORDED WEBINARS
- ASHTONBEE CAMPUS
- DOWNSVIEW CAMPUS
- MORNINGSIDE CAMPUS
- PROGRESS CAMPUS
- STORY ARTS CENTRE
- SCHOOL OF ADVANCEMENT
- CENTRE FOR PART-TIME AND ONLINE LEARNING
- SCHOOL OF HOSPITALITY, TOURISM AND CULINARY ARTS
- SCHOOL OF ENGINEERING TECHNOLOGY AND APPLIED SCIENCE
- SCHOOL OF COMMUNITY AND HEALTH STUDIES
- SCHOOL OF COMMUNICATIONS, MEDIA ARTS AND DESIGN
- THE BUSINESS SCHOOL
- SCHOOL OF TRANSPORTATION
- CAMPUS TOURS ON DEMAND
GIVING
TOGETHER AGAIN
- TOGETHER AGAIN
- CURRENT STUDENTS
- INTERNATIONAL STUDENTS
- FAQS
- CENTENNIAL RESOURCES
- STUDENT SERVICES AND SUPPORT
  - Academic School Contact List
  - Travelling to Campus
- HEALTH AND COMMUNITY
  - Resources
  - Interactive Resource Map
- LEARNING RESOURCES
- CONTACT US
- GUIDE TO ACCESSING CENTENNIAL CAMPUSES
CAREERS
- CAREERS
- JOB OPPORTUNITIES
- DID YOU KNOW
- EMPLOYEE BENEFITS
- DIVERSITY AND INCLUSION
MYAPPLICATION
2021 ACADEMIC EMPLOYEE CONTRACT NEGOTIATIONS
- 2021 ACADEMIC EMPLOYEE CONTRACT NEGOTIATIONS
- ANSWERS TO FREQUENTLY ASKED QUESTIONS
WIN
Student Hub
Library
Parents and Supporters
416-289-5000 Contact Us

For the latest COVID-19 information and news from Centennial College, please visit Together Again Fall 2021.

Learn More

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