Speak to one of our course advisors:

Name:

Email:

Telephone:

 

 

We aim to call you back within one working day.

 

All other requests should be made using our enquiry form.

 

 

 


Oracle Database Specialist 9i and 10g

Fast track Oracle Database Certifications for database professionals

Course Contents:

Stage 1: Software Programming Fundamentals

Stage 2: Programming Best Practices

Stage 3: Software Development Principles

Stage 4: Systems and Database Design

Stage 5: Managing Information Systems

Stage 6: Exam 1Z0-007 Introduction to Oracle 9i SQL

Stage 7: Exam 1Z0-031 Oracle 9i Database Administrator Associate DBA OCA

Stage 8: Exam 1Z0-032 Oracle 9i Database Fundamentals II

Stage 9: Exam 1Z0-033 Oracle 9i Database Performance Tuning

Stage 10: Exam 1Z0-042 Oracle Database 10g Administration I

Stage 11: Exam 1Z0-043 Oracle Database 10g Administration II

Course Code:

ORA-1

Course Duration:

12 months

Typical Study Hours:

340 - 360 hours

Course Fees:

See our Fee Guide

Study Prerequisite:

Computer programming certifications or relevant industry experience.

Additional Information for Stage 1:

  • Software Programming Fundamentals:
    • Getting Started
    • Designing Programs

^top

Additional Information for Stage 2:

  • Programming Best Practices:
    • Programming Techniques and Strategies
    • General Coding Best Practices
    • Object-oriented Coding Best Practices
    • Maintaining Quality Code

^top

Additional Information for Stage 3:

Software Development Principles:

  • Developing a User-Centred Software Design Approach
    • Introducing User-Centered Design
    • Developing an Application Using User-Centered Design
    • The Iterative Process in User-Centered Design
    • Practical Examples of User-Centered Design

^top

Additional Information for Stage 4:

Systems and Database Design:

  • Database Design
    • An Overview of Database Design
    • The Database Design Methodology
  • Database Fundamentals
  • An Introduction to Database Systems
  • Relational Databases
  • Database Data Management
  • Systems Analysis Fundamentals
  • Data Flow Diagrams
  • Entity Relationship Diagrams
  • Data Dictionaries
  • Completing the Logical Model
  • Relational Principles
  • Database Fundamentals
  • Fundamentals of Database Design
  • Normalisation and Physical Database Design
  • Database Management
  • Web and Database Integration
  • Database Technologies
    • Object-Relational DBMSs
      • Characteristics
      • Mechanisms and Implementation
    • Data Warehousing
      • Fundamentals
      • Building, Using, and Managing
    • SQL Programming
      • Database Queries
      • Data Handling Techniques

^top

Additional Information for Stage 5:

Managing Information Systems:

  • The Software Development Process
    • Principles
    • Management Practices
  • Open Systems Standards I
  • Open Systems Standards II
  • Client/Server Fundamentals
  • Client/Server Technology
  • Client/Server Implementation
  • Internet, Intranet, and Extranet Technologies
  • Software Engineering
    • Personal Software Process I
    • Personal Software Process II
  • Client/Server Technologies
  • The Client/Server Model

^top

Additional Information for Stage 6:

  • Exam 1Z0-007 Introduction to Oracle9i: SQL
    • Introduction to Oracle and SQL in Oracle9i
    • SQL Functions in Oracle9i
    • Subqueries, Reporting and User-Access Control in Oracle9i
    • Defining and Manipulating Data in Oracle9i

^top

Additional Information for Stage 7:

  • Exam 1Z0-031 Oracle9i Database: Fundamentals I
    • Architecture and Administration Tools in Oracle9i
    • Database and Instance Management in Oracle9i
    • Database Structures in Oracle9i
    • Data Storage in Oracle9i
    • Tables and Indexes in Oracle9i
    • Data Integrity in Oracle9i
    • Users and Profiles in Oracle9i
    • Privileges and Roles in Oracle9i
    • Globalisation and Auditing in Oracle9i

^top

Additional Information for Stage 8:

  • Exam 1Z0-032 Oracle9i Database: Fundamentals II
    • Networking Overview for Oracle9i Administrators
    • Oracle Network Configuration in Oracle9i
    • Backup and Recovery Overview and Configuration in Oracle9i
    • User-Managed and RMAN Backup and Recovery in Oracle9i
    • Recovery Manager Maintenance in Oracle9i
    • Transporting and Loading Data in Oracle9i

^top

Additional Information for Stage 9:

  • Exam 1Z0-033 Oracle9i Database: Performance Tuning
    • Performance Tuning Methodology and Tools in Oracle9i
    • Tuning Memory Structures in Oracle9i
    • Tuning Database Structures in Oracle9i
    • Tuning Systems and Applications in Oracle9i

^top

Additional Information for Stage 10:

  • Exam 1Z0-042 Oracle Database 10g: Administration I
    • Installing Oracle Database 10g
    • Creating Databases
    • Database Interfaces
    • Database Control and Storage Structures
    • Users and Security
    • Managing Schema Objects and Data
    • The SQL* Loader and PL/SQL
    • Oracle Net Services and Shared Servers
    • Monitoring and Maintenance
    • Managing Undo Data and Lock Conflicts
    • Managing Backup and Recovery

^top

Additional Information for Stage 11:

  • Exam 1Z0-043 Oracle Database 10g: Administration II
    • Controlling the Oracle Listener and Enabling
    • Distributed Transactions in Oracle 10g
    • Using Globalisation Support in Oracle 10g
    • Using Flashback Technology in Oracle 10g
    • Performing and Managing Backups in Oracle 10g
    • Advanced Database Recovery and Repair in Oracle 10g
    • Optimising Database Performance in Oracle 10g
    • Managing Storage and System Resources in Oracle 10g
    • Using the Scheduler to Automate Tasks in Oracle 10g
    • Using Advanced Features in Oracle 10g

^top

<< back to previous page

 


Career Development training course includes:

Pass - or we'll buy your training back!

Enhanced Online Support to ensure you complete your training and get certified even faster!

24/7 Online Mentoring from certified instructors

Access to the Virtual University

Daily Training Emails

Access to 400+ titles in our Technical Library

Web links

Hands on Interactive Exercises

Hundreds of practice test questions