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
- SUMMER 2021 FULL-TIME PROGRAM DELIVERY
  - New Students
  - 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
  - Accessibility Needs
  - Bring IT FAQs
- 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
  - 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 FAQ
  - 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
  - GNED Course Descriptions
  - RNED 500 and GNED 4x4 Courses
  - English 4x4 Courses
- 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 (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
  - 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
  - Admissions & Finance Questions
  - Learning at a Distance Questions
- 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
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
- TESTING SERVICES
- APPLIED RESEARCH, INNOVATION AND ENTREPRENEURSHIP SERVICES
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
COVID-19 STUDENT INFORMATION CENTRE
- COVID-19 STUDENT INFORMATION CENTRE
- CANADIAN STUDENTS
- INTERNATIONAL STUDENTS
- COVID-19 SECOND WAVE ACTION PLAN
- FAQS
- CENTENNIAL COVID-19 RELIEF BURSARY
- STUDENT SERVICES AND SUPPORT
- COVID-19 PANDEMIC RESPONSE TIMELINE
- 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 remain 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