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