Pre-Requisite for Oracle DBA is a comprehensive knowledge of object-oriented programming.

The Oracle Course is made up of 6 main modules, each of which are listed below:

Module 1: Oracle Fundamentals

This module covers the fundamentals of database design. Students will review the concepts, principles, and purposes of databases. They will learn the processes often employed when developing a relational database. The student will also be introduced to Object Oriented Analysis approach to database design, and will determine how those methodologies fit in to Oracle Database development.

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Introduce Database Concepts - Describe The Data Modeling Components - Step Through The Normalization Process - Describe The Oracle Architecture - Discuss The Oracle 8i Features - Explain The Structured Query Language - Understand The General Programming Logic - Develop PL/SQL Procedures - Identify The Concept Of Object Oriented Technology

 

Module 2: Oracle: SQL, PL/SQL and SQL*PLUS

This course introduces students to data server technology, and explores the concepts of relational databases and the powerful SQL and PL/SQL programming languages. Students will learn and practice how to create and maintain database objects. The students will also learn to store, retrieve, and manipulate data. Finally, the students will learn how to create PL/SQL Blocks of application code that can be used in Oracle forms, reports, and other Oracle applications. This course will help the student to prepare for Oracle's exam, Introduction to Oracle SQL & PL/SQL (IZO-001).

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Identify the SQL-DCL, SQL-DDL, and SQL-DML commands
- Introduce SQL*PLUS
- Create Tables and Constraints
- Create and manage more Database Objects
- Implement built-in SQL functions
- Restrict the data Selected
- Retrieve data from multiple tables
- Build a PL/SQL block
- Create a PL/SQL block to manipulate data
- Work with PL/SQL Control Structures
- Work with Collections of Data
- Process Cursors within PL/SQL
- Handle runtime exceptions
- Develop Procedures and Functions
- Generate Oracle Packages
- Create and manage Oracle triggers
 

 

Module 3: Oracle: Architecture and Administration

Oracle: Architecture and Administration is an introduction to the architecture of an Oracle Database Management System, and the techniques used to manage and administer the database effectively. Upon completion of this course, the students will have the skills necessary to administeer and manage an Oracle database, and should be adequately prepared to take and pass the Oracle Certified Professional (OCP) examination Oracle: Architecture and Administration.

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Identify and describe the architecture of an Oracle8i database
- Create and delete Oracle8i databases
- Manage an Oracle8i instance*
- Describe the main features of an Oracle8i server
- Manage users and security through the use of roles and privileges
- Describe and utilize the Oracle8i data dictionary and standard PL/SQL packages
- Administer tablespaces and datafiles
- Create and manage tables
- Create and manage indexes
- Maintain the control files, views, and sequences
- Manage the elements of data storage
- Manage the rollback segments
- Maintain data integrity through the use of constraints
- Reorganize data within Oracle

Module 4: Oracle: Backup and Recovery Strategies

This course introduces students to the essential task of planning and implementing database backup and recovery strategies. Students will be taught the importance of creating a backup and recovery plan as well as a disaster recovery plan. Students will review fundamental Oracle internal structures that effect backup and recovery, and students will be taught to backup and recover an Oracle database using the various backup and recovery options that Oracle provides. Students will be introduced to various Oracle utilities that can be used to troubleshoot database problems, and they will be introduced to RMAN, Oracle's provided backup and recovery solution. Finally, students will be introduced to the Oracle standby database, and how it is used.

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Prepare backup, recovery and disaster plans.
- Describe the internal workings of the Oracle database as they pertain to backup and recovery.
- Describe the backup procedures for both hot and cold backups and then perform those backups.
- Perform database recoveries with the database open and closed, including full, tablespace and datafile recoveries.
- Perform complete database recoveries and incomplete database recoveries.
- Discuss the benefits and use of the Oracle Export/Import utility. Use these utilities to perform various exports and imports using an Oracle database.
- Learn to use the various Oracle troubleshooting utilities including DBC and DBMS_REPAIR. Learn to use Oracle LogMiner to mine archived and online redo logs.
- Perform initial setup procedures in preparation for using RMAN.
- Learn about the basic RMAN architecture
- Performed various backups using RMAN including full, incremental, tablespace and datafile backups.
- Perform various recoveries with RMAN including full, tablespace and datafile recoveries.
- Create stored scripts and generate reports and lists in RMAN.
- Setup and Oracle standby database, and enable the standby database in both read only mode, managed recovery mode and activated mode.
 

Oracle: Tuning and Troubleshooting

This course is an introduction to the techniques used when tuning an Oracle Database Management System. Upon completion of this course, the students will have the skills necessary to maintain and tune an Oracle database, and will be prepared to take and pass the Oracle Certified Professional (OCP) examination Oracle: Tuning and Troubleshooting (1Z1-024).

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Understand the tuning process for an Oracle8i Database Management System, and establish appropriate tuning goals.
- Tune the configuration of an Oracle8i database to optimize efficiency.
- Tune Standard Query Language (SQL) statements to optimize efficiency and improve throughput.
- Utilize the various tuning utilities available, and understand and use the Dynamic Performance Views of the data dictionary to collect performance data used in the tuning process.
- Tune the Shared Pool area in memory to improve performance of the database.
- Tune the Buffer Cache area in memory to improve the efficiency of transaction processing.
- Monitor and tune the Redo Log Buffers to minimize contention and improve reliability.
- Ensure proper data block usage to maximize data storage efficiency.
- Tune sorting operations to save resources and increase response time when data sorting is involved.
- Tune rollback segments to increase efficiency when processing transactions.
- Monitor all locks and latches in the system to avoid contention.
- Manage the database workload in different types of environments, including Online Transaction Processing (OLTP) and Decision Support Systems (DSS).
- Configure and tune a Multi-Threaded Server configuration.
 

Oracle: Network and Distributed Administration

This course covers the tools and techniques used when configuring an Oracle Database Management System in a network environment. Upon completion of this course, the students will have the skills necessary to configure and troubleshoot network connections to the Oracle database, and should be adequately prepared to take and pass the Oracle Certified Professional (OCP) examination Oracle: Network and Distributed Administration (Exam# 1Z1-026).

During this module, including computer lab time, students will be provided with the information necessary to complete the following objectives:

- Identify the components that make up Net8 architecture.
- Configure the server-side network connection.
- Configure the client-side network connection.
- Identify and apply centralized naming concepts.
- Configure and tune Multi-Threaded Server.
- Use the Connection Manager utility.
- Troubleshoot the network.
- Establish and maintain network security.