Course Overview
This updated course fulfills the Instructor-Lead-Training requirement for Oracle 9i certification. It is designed for students who already understand relational database, data modeling and have a working knowledge of SQL. It provides a foundation of the Oracle9i database architecture and shows how the Oracle database instance and file structures interact. Students create a database and learn how to manage associated files. Topics include: preparing the initialization file, querying the data dictionary, maintaining the control files and redo log files, creating and altering tablespaces and database segments, creating and managing Oracle9i database objects including tables, indexes and users. BCIT is a member of the Oracle Workforce Development Program and uses Oracle University course materials (a $300.00 value) included with tuition. Please enroll early, course materials are ordered on an as needed basis and takes 7-10 days to arrive.
- Retired
- This course has been retired and is no longer offered. Find other Flexible Learning courses that may interest you.
Learning Outcomes
- Understand the Oracle architectural components.
- Manage the database instance.
- Create a database.
- Use the data dictionary views to retrieve database information.
- Maintain the control files.
- Maintain the redo log files.
- Manage tablespaces and data files.
- Understand the database storage structure and relationships.
- Manage undo data.
- Manage tables.
- Manage indexes.
- Maintain data integrity.
- Create and manage tables.
- Create and manage indexes.
- Create and maintain constraints.
- Manage password security and resources.
- Manage users, privileges and roles.
Effective as of Winter 2005
Programs and courses are subject to change without notice. Find out more about BCIT course cancellations.