North American College

 North American College

 of Information Technology

Diploma in Oracle Database Administration   

Program Length: 32 weeks


This program is offered at our Toronto and Scarborough Campus


Database administrators develop and implement data administration policy, standards and models. They are employed in information technology consulting firms and in information technology units throughout the private and public sectors. They may perform some or all of the following duties:

  • Develop and implement data administration policy, standards and models
  • Research and document data requirements, data collection and administration policy, data access rules and security
  • Develop policies and procedures for network and/or Internet database access and usage and for the backup and recovery of data
  • Conduct research and provide advice to other information systems professionals regarding the collection, availability, security and suitability of data
  • Write scripts related to stored procedures and triggers
  • May lead and coordinate teams of data administrators in the development and implementation of data policies, standards and models

Database Administrators primarily work in offices or laboratories, spending the majority of their time in front of a computer. Most work full-time although overtime or weekend work may be required to meet deadlines or solve specific problems.

Telecommuting is possible in this occupation, depending on the employer's flexibility. Work expectations from employers are high as organizations are heavily dependent on effective databases and there can be significant pressure to ensure that they operate smoothly.


Course Outline

  1. Oracle Database: Fundamentals of SQL
  2. Oracle Database: Administration I
  3. Oracle Database: Administration II
  4. Oracle DBA Project
  5. Microsoft Access and Excel
  6. Linux for Oracle Database Administrators
  7. Microsoft SQL Server: Implementation and Maintenance
  8. Career Development

Job Search / Placement

At North American College of Information Technology, Career Services are designed to assist graduates in the pursuit of employment in their field of study. NAC management contacts prospective employers to provide employment opportunities for graduates. Services for students and graduates include conducting workshops and providing individualized one-to-one service on job related topics such as resume building, interviewing and job search techniques as well as bringing employers at campus for recruiting purposes.

Career Opportunities

Graduates may find employment as an:

  • Oracle database administrator
  • Data custodian
  • Data dictionary administrator
  • Database analyst,
  • database architect,
  • Data warehouse analyst
  • Database developer

Admission Requirements

  • Grade 12 (OSSD) or equivalent
  • If you are 19 years or older and do not have an OSSD or equivalent, a minimum passing score of 16 on the Wonderlic SLE entrance test Secondary School Diploma (or equivalent); or Mature Student (19 years of age or older and out of school for 1 year or more)

Students can apply and be granted advanced standing and exemptions based on their previous postsecondary studies. The following are required: (a) A request by the students indicating clearly what course(s) they are requesting advanced standing for and the reason for the request; (b) Official transcripts, and/or assessments, certificates based on which the advanced standing is requested.

Advanced standing or exemption will be granted in cases wither the skills and knowledge outcomes of the previous academic work done by the applicant are essentially identical to those of the subject/module as offered by North American College, as determined by the academic and administrative staff of the College, and, if required, by an interview with a member of the academic staff who teaches the subject/module in question. An advanced academic standing/exemption is considered approved only when it is approved in writing by North American College’s admission office. It is the responsibility of individuals who intend to apply for advanced standing to do so before finalizing their registration on the College.

Note: Advanced Standing will be granted to individuals who hold Microsoft SQL Server Certification. These students will not be required to take: Microsoft SQL Server: Implementation and Maintenance and Microsoft Access and Excel.

`