Canadian Career Education College (CCEC)
“Registered as a career college under the Ontario Career Colleges Act, 2005”
Database Development & Administration Diploma
A full-time diploma in building, managing, and securing relational databases with Oracle, Microsoft SQL Server, and MySQL. Canadian Career Education College (CCEC) delivers the program in English.
Program Overview
Database administrators evaluate database software, maintain the integrity and performance of company databases, keep data secure through access control, and train end users on database systems.
Subjects Taught
- Introduction to Oracle Database
- The Business of Database Administration
- Database Fundamentals, Design, Tools and Techniques
- Writing Oracle SQL Concepts and Queries
- Backup, Recovery, and Server Tuning for Oracle Databases
- SQL Queries for Oracle Databases Development
- Microsoft SQL Administration Server
- SQL Language and Programming
- Oracle PL/SQL Programming
- Lab Work
- Privacy Law and Conflict Assessment
- Career Development
Skills and Outcomes
Database Development Skills
- Relational databases in Oracle, SQL Server, and MySQL
- SQL SELECT statements based on ANSI/ISO standards
- PL/SQL programs, stored procedures, and functions
- Complex queries, cursor processing, and advanced SQL techniques
- Conceptual and logical data models built from business requirements
Database Administration Skills
- Backup, recovery, and flashback operations
- Server tuning and disaster recovery for Oracle databases
- Automated backup and recovery with RMAN and Oracle Enterprise Manager
- SQL Server installation, configuration, and index management
- Data integrity, security, and performance
Duration and Tuition
| Item | Details |
|---|---|
| Program length | 45 weeks, 900 hours |
| Study option | Full time, 100% course load |
| Tuition, in class or online | CAD $12,600 |
| Not included in tuition | International student fee (CAD $2,500) |
| Learning materials | All required learning materials are provided by the College. Textbooks are suggested but not required. |
Tuition may be paid in instalments. See Student Loans and Financial Aid. Online access to course notes is provided where available. Refunds follow the Refund Policy for Vocational Programs.
Admission Requirements
Academic Requirement
Ontario Secondary School Diploma (OSSD) or equivalent, or Mature Student Status. See Domestic Admission Requirements and International Admission Requirements.
Mature Student Status
An applicant who does not have an OSSD or equivalent may be admitted as a mature student if the applicant is 18 years of age or older and passes a qualifying test approved by the Superintendent of Career Colleges (Ontario Regulation 415/06, section 19). See Mature Student Status.
- Domestic applicants may apply up to 15 days before the start date.
- After you apply, review the Admission Offer and Acceptance process.
Delivery and Enrolment
Domestic Students
Canadian citizens and permanent residents may study in class at the Vaughan campus or online through distance education. No internship or placement is required.
International Students
Under current IRCC regulations, CCEC accepts international students in vocational diploma programs in the online distance education format only, unless the applicant holds a valid study permit when applying.
See the Enrolment Schedule for start dates. Online students must meet the College System Requirements.
Important Information
- This program has been “Approved as a vocational program under the Ontario Career Colleges Act, 2005.”
- CCEC does not guarantee employment, job placement, or salary. Meeting the minimum admission requirements does not guarantee admission.
- Read the College Policies before you enrol.
Ready to Apply?
For questions about eligibility, call an Admissions Advisor at 1-905-499-3631, ext. 102 or 103, or email Administration. The admission application takes 15 to 20 minutes; please use a computer or laptop.
Canadian Career Education College (CCEC)
Registered career college in Ontario.
DLI # O262228554872 · OSAP Approved
Phone: 1-905-499-3631, ext. 102 or 103
Email: Administration · All contacts
Support and Policies
© 2014-2026 Canadian Career Education College (CCEC). All Rights Reserved.
