StarCom Group Software/Networking Training Center

Oracle 8 DBA Certification (100 hours)
Course Description:

This 100-hour course is designed for those who are interested in learning the complete skills necessary to become a quality Oracle 8 DBA and be best prepared to obtain the industry recognition through Oracle 8 DBA Certification Program. Learning the true knowledge and practical skills remains the first priority of our training program. Our goal is to produce a team of top gun Oracle DBAs, who are not only best prepared to pass Oracle's certification tests, but most importantly, are equipped with the top notch technical skills capable of successful performance in their future DBA tasks.

In this course, students will get a jump start in 5 major Oracle areas : SQL and PL/SQL, Oracle Installation and Database Administration, Backup and Recovery, Performance Tuning and Net8. Upon completion of this course, participants will be able to do Oracle Development and Database Administration on the SUN Solaris UNIX and Windows NT 4.0, and Redhat 5.2 Linux environment.


$2000 (100 hrs)

Schedule and Agenda

1. Introduction of Oracle

Understanding Data Model

  • Entity Diagram Structure
  • Common M:1 Relationships
  • Less Common M:1 Relationships
  • Unusal M:1 Relationships
  • M:M Relationships
  • Normalization
  • Creating a Entity Relationship Diagram (ERD)
  • Generate DDL

2. SQL

  • Data Types
  • Basic Syntax

Develop Complex Queries

  • Subqueries
  • Single-row Subqueries
  • Multiple-value Subqueries
  • Multiple-Column Subqueries
  • Correlated Subqueries
  • SQL Character Function
  • Generate SQL from SQL

3.Overview of PL/SQL

Creating Procedures

  • Syntax for Creating Procedures
  • Creating a Stored Procedures using SQL*Plus
  • Procedural Parameter Modes (IN, OUT Arguments)
  • Methods of Passing Parameters
  • Removing Procedures

Creating Functions

  • Syntax for Creating Functions
  • Creating a Function using SQL*Plus
  • Advantages of User-Defined Functions in SQL Expressions
  • Restrictions of Calling Functions from a SQL Expressions
  • Invoking Functions from a SQL Statement
  • Removing Function
  • Comparing Procedures and Functions

4. Creating Packages

  • Overview of Packages
  • Advantages of Packages
  • Developing a Package
  • Creating the Package Specification
  • Creating the Package Body
  • Public and Private Constructs
  • Referencing a Global Variable Within the Package
  • Persistent State of Package Variable, Package Cursor
  • Removing Packages
  • Managing Packages
  • Guidelines of Developing Packages

Creating Triggers

  • Overview of Triggers
  • Database Triggers and Cascading Triggers
  • Trigger Components
  • Firing Sequence of Database Triggers on a Single Row
  • Firing Sequence of Database Triggers on Multiple Rows
  • Syntax for Creating Statement Triggers
  • Before Statement Trigger
  • After Statement Trigger
  • Using Conditional Predicates
  • Using Old and New QualifiersRules Governing Triggers
  • Auditing Using a Trigger
  • Protect Referential Integrity with a Trigger
  • Replicate a Table with a Trigger

5. Manipulating Large Objects

  • Overview of the Large Object Types
  • Creating a Table with LOBs
  • Managing LOBs and BFILEs
  • Populating LOBs
  • Removing LOBs
  • Working with DBMS_LOB Package

6. Oracle Database Administration

  • Understand Oracle8 Server Architecture and its components.
  • Installation Oracle 8 (unix platform)
  • Define variables
  • Create directories
  • Install Oracle Executable

7. Creating Oracle Database

  • Create Database following OFA
  • Create Data Dictionary Manage Oracle Database
  • Create and Manage Tablespaces
  • Create and Manage Datafiles
  • Create and Manage Rollback Segments
  • Create and Manage Temporary Tablespaces
  • Create and Manage Redo logs

8. Manage Database Objects

  • Manage Space
  • Managing Disk space in Data Block
  • Setting Storage Parameters
  • Manage Tables
  • Managing Tables
  • Managing Partitioned Tables
  • Manage Indexes
  • Managing Indexes
  • Managing Partitioned Indexes
  • Manage Views, Sequences and Synonyms

9. Manage Users, resources and Security

  • Create users
  • Manage resources with profile
  • Manage passwords with profile
  • Manage user privileges with role

Ensure Data Integrity

  • Data Integrity and Constraints
  • Define Constraints
  • Constraint Types
  • - Primary Key Constraints
    - Foreign Key Constraints
    - Check Constraints
    - Unique Constraints
    - Not Null Constraints

Audit the Oracle Database

  • Overview
  • Enable Auditing
  • Audit Statements
  • Audit Privileges
  • Audit Objects
  • Monitor and Manage the Audit Trail
  • Display Auditing Information

10. Backup

  • Overview
  • Archive log
  • Archive Processing
  • Enable Archive
  • Backup
  • Export
  • Cold Backup
  • Hot Backup
  • Offline Backup
  • Online Backup
  • Backup Control File

11. Recovery

  • Reovery with Archive logs
  • Perform Media Recovery Proc
  • Import
  • edures
  • Perform Partial or Point-in-Time Database Recovery
  • Recover an Online Redo Log File
  • Recover a Control File
  • Standby Database
  • Create a Standby Database
  • Create a Standby Control File
  • Apply Archive log to Standby Database
  • Activate a Standby Database

12. Performance Tuning

  • Optimizer
  • Rule Base Optimizer
  • Cost Base Optimizer
  • SQL Tuning
  • - Explain Plan
    - SQL Trace and TKPROF
    - Use Hints

  • Tune Memory Allocation
  • Tune I/O
  • Tune Contention
  • Top Tuning Tips

13. Net8

  • Start up and shutdown the listener
  • Configure Listener on the Server side
  • Configure Listener on the Client Side
  • Connecting database using Sql*net

Database Links

  • Creating a database link
  • Connecting to a remote database using database link

Loading Data using SQL* Loader

  • Overview
  • Loading Data Using Conventional Path
  • Loading Data Using Direct Path
  • Continue Aborted Loads
  • Specify Load Paramete