Oracle Database Administration

College-Approved Certificate (4 courses) Part-time On Campus
Program Code: 6059C02PWO Academic Year: 2016/2017


This program is listed under the following fields of study:

Our Program

Oracle certification is one of the most sought-after professional designations in the software field. As a member of the Oracle Workforce Development Program (WPD), Algonquin College is authorized to deliver official Oracle university training using curriculum that matches the certification requirements leading to the Oracle Database 11g Administrator Certified Professional (OCP) designation.

Students gain knowledge in relational database design and acquire the ability to effectively write SQL statements to query and upgrade an Oracle database, manage database files and users, and plan and implement a database backup and recovery strategy. All classes are comprised of lectures and hands-on practice in Oracle labs.

To qualify for this certificate, you must complete the program within two years.

Success Factors

This program is well-suited for students who:

  • Enjoy solving problems.
  • Enjoy working with computers and technology.
  • Like working with others as a member of a team.
  • Can work independently.
  • Are detail-oriented, organized and committed to achieving excellence in their work.

Fees & Expenses

Fees for part-time programs are charged on a course-by-course basis and are published on each individual course page. For questions related to fees, please call the Registrar's Office at 613-727-0002.

Graduation Fee

Once you have completed all the courses in the program, it is the responsibility of the student to contact the Registrar's Office to obtain a certificate/diploma application. A graduation fee of $40 will be charged when the application is submitted. When your certificate/diploma application has been approved, you will be invited to Spring or Fall Convocation.

Admission Requirements

College Eligibility
  • Ontario Secondary School Diploma (OSSD) or equivalent, OR
  • Mature Student status (19 years of age or older and without an OSSD).
Program Eligibility

Applicants must have postsecondary education or equivalent work experience and fundamental skills to navigate comfortably through a computing environment.

College Eligibility
  • Ontario Secondary School Diploma (OSSD) or equivalent, OR
  • Mature Student status (19 years of age or older and without an OSSD).
Program Eligibility

Applicants must have postsecondary education or equivalent work experience and fundamental skills to navigate comfortably through a computing environment.

Notes

This program provides an Oracle university curriculum and Oracle student e-books, hands-on experience using Oracle 11g software as well as Oracle certificates of completion and special discount vouchers for each of the OCP exams.

To help schedule your studies, please check our proposed plan for the upcoming year.

For more information on the OCP-description go to education.oracle.com.

CCOL Academic Planner

The Academic Planner provides registered part-time students in the Centre for Continuing and Online Learning (CCOL) the ability to declare into a program of study. The Academic Planner outlines successfully completed courses to date, as well as courses that need to be completed in order to meet graduation requirements. It is therefore, essential that all part-time students in CCOL declare to their program of study, allowing administrators to plan course offerings. The tool is available on ACSIS, located under 'Continuing Education' on the left-hand toolbar.

Additional Information

For more information, please contact Angela Peterson, Program Coordinator, at 613-727-4723 ext. 6329 or petersa2@algonquincollege.com.

Courses

On campus: On Campus
Course
Number
HoursCourse NameWinter
CST537232.0Data Modelling and Relational Database Design

CST5372 Data Modelling and Relational Database Design

The use of Entity Relationship Modelling is examined in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The design process and considerations for creating a normalized, stable, maintainable and well-defined relational database, such as Oracle 11g, are also covered.

There are no classes currently scheduled for this course.

CST537640.0Oracle Database 11g:Introduction to SQL

CST5376 Oracle Database 11g:Introduction to SQL

Students study the concepts of relational databases and the essential Structured Query Language (SQL) skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects. They also learn to control privileges at the object and system level. Topics covered include creating indexes and constraints and altering existing schema objects, how to create and query external tables, how to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also experience some of the date-time functions available in 11g Oracle Database and how to use the regular expression support in SQL.

Pre-requisites: CST5372

There are no classes currently scheduled for this course.

CST537740.0Oracle Database 11g: Administration Workshop I

CST5377 Oracle Database 11g: Administration Workshop I

Students develop a firm foundation in basic administration of Oracle Database 11g. They learn how to install and maintain Oracle Database 11g and gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practice.

Pre-requisites: CST5376

There are no classes currently scheduled for this course.

CST537840.0Oracle Database 11g: Administration Workshop IIOn Campus

COURSE DESCRIPTIONS

CST5372 Data Modelling and Relational Database Design

The use of Entity Relationship Modelling is examined in detail, through many real life examples, practical business problems and solutions. After several iterations, the ER model captures the data requirements and business rules and forms a sound basis for the initial design of a relational database. The design process and considerations for creating a normalized, stable, maintainable and well-defined relational database, such as Oracle 11g, are also covered.

CST5376 Oracle Database 11g:Introduction to SQL

Students study the concepts of relational databases and the essential Structured Query Language (SQL) skills that allow developers to write queries against single and multiple tables, manipulate data in tables and create database objects. They also learn to control privileges at the object and system level. Topics covered include creating indexes and constraints and altering existing schema objects, how to create and query external tables, how to use the advanced features of SQL in order to query and manipulate data within the database, use the dictionary views to retrieve metadata and create reports about their schema objects. Students also experience some of the date-time functions available in 11g Oracle Database and how to use the regular expression support in SQL.

Pre-requisites: CST5372

CST5377 Oracle Database 11g: Administration Workshop I

Students develop a firm foundation in basic administration of Oracle Database 11g. They learn how to install and maintain Oracle Database 11g and gain a conceptual understanding of the Oracle database architecture and how its components work and interact with one another. Students also learn how to create an operational database and properly manage the various structures in an effective and efficient manner including performance monitoring, database security, user management and backup/recovery techniques. The lesson topics are reinforced with structured hands-on practice.

Pre-requisites: CST5376

CST5378 Oracle Database 11g: Administration Workshop II

Students focus on a critically important aspect of the database administrator's role: backup and recovery. Students learn the concepts and architecture that support backup and recovery and practise the steps to carry it out in a variety of ways for different situations. This includes defining and testing backup and recovery scenarios. Students also learn how to manage memory effectively and how to carry out some performance evaluation and tuning tasks, including the use of advisors. Flashback technologies, scheduling jobs inside and outside of the database and controlling system resource usage are also covered.

Pre-requisites: CST5377