This 8-month full-time program prepares individuals for a career as an Oracle DBA and provides students with comprehensive, hands-on coverage of all aspects of Oracle Database Administration.

Program Overview

  Network & Operating Systems Primer......... 8 weeks

Ø      Windows 2000 Networking & Interoperability

Ø      Intro to Networking Essentials

Ø      Intro to Unix on Solaris

Database Modelling & Relational Databases.. 2 weeks

Ø      Relational Principles & Database Design

Intro to Oracle SQL, SQL*Plus and PL/SQL 6 weeks

Ø      SQL Programming: Database Queries and Data Handling Techniques

Ø      SQL*Plus: Fundamentals, Data Definition and Manipulation

Ø      PL/SQL: Fundamentals, Exceptions & Scripts

Oracle8i Network Administration..... 3 weeks

Ø      Architecture and Basic Configuration

Ø      Advanced Configuration and Troubleshooting

Oracle8i Database Administration..... 6 weeks

Ø      Fundamentals and Creating an Oracle Database

Ø      Managing Data and Transactions

Ø      Database Structure & Storage

Ø      Managing Segments and Constraints

Ø      Managing Users, Privileges, Roles and Profiles

Ø      Auditing the Database and Advanced Architecture and NLS

Oracle8i Backup and Recovery .. 4 weeks

Ø      Backup Considerations

Ø      Methods, Theory and Advanced Techniques

Ø      Incomplete Recovery and Logical Backups

Ø      Troubleshooting & the Standby Database

Oracle8i Performance Tuning and Optimization....... 4 weeks

Ø      Monitoring Database Activity

Ø      Memory Allocation and The Sort Area

Ø      Improving I/O Performance

Program Details

Schedule:            33 weeks of full-time study - Monday to Friday from 8:30 am to 4:30 pm.

Total Fees:            $13, 995.00*

Instruction:    Instructor led and self directed study with focus on certification and hands-on skill development.

Start Dates:   Classes starting on a regular basis, please call 460-2910 for next available start dates, seat availability and prerequisite information.

 *Qualified candidates may be eligible for financial assistance.  Click here for information about the BC Student Assistance Program.Call 460-2910 for more information on program and candidate eligibility.