Train to become a Database Administrator, Support Engineer, or Technical Consultant and gain several Oracle Certifications all in one course!

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: Oracle Exam 1Z0-007 Introduction to Oracle 9i SQL

Stage 7: Oracle Exam 1Z0-047 Oracle Database SQL Expert

Stage 8: Oracle Exam 1Z0-051 Oracle Database 11g: SQL Fundamentals I

Stage 9: Oracle Exam 1Z0-052 Oracle Database 11g: Administration I

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

Stage 11: Oracle Exam 1Z0-054 Oracle Database 11g: Performance Tuning

Course Code:

ORAC-1

Course Duration:

12 months

Typical Study Hours:

260 – 280 hours

Course Fees and Demo:

Request Fee Guide, Demo and Free Reports

Includes:

Online IT Technical Book Library

Study Prerequisite:

Basic computer knowledge.

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:

• Oracle 1Z0-047 Oracle Database SQL Expert
  • Oracle Database 11g: Using SQL to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11g: Subqueries, Set Operators, and Data Manipulation
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
  • Oracle Database 11g: Controlling User Access and Managing Schema Objects
  • Oracle Database 11g: Data Dictionary Views and Large Data Sets
  • Oracle Database 11g: Managing Data in Different Time Zones
  • Oracle Database 11g: Using Subqueries and Regular Expressions

^top

Additional Information for Stage 8:

• Oracle 1Z0-051 Oracle Database 11g: SQL Fundamentals I
  • Oracle Database 11g: Using SQL to Query Your Database
  • Oracle Database 11g: Conversion Functions, Group Functions, and Joins
  • Oracle Database 11g: Using DDL, Views, Sequences, Indexes, and Synonyms
  • Oracle Database 11g: Using Subqueries and Regular Expressions

^top

Additional Information for Stage 9:

• Oracle 1Z0-052 Oracle Database 11g: Administration I
  • Oracle Database 11g: Database Architecture and Installation
  • Oracle Database 11g: Database Creation, Instance Management, and Connectivity
  • Oracle Database 11g: Storage Structures and User Security
  • Oracle Database 11g: Managing the Schema, Data, and Concurrency
  • Oracle Database 11g: Managing Undo Data, Database Security, and Maintenance
  • Oracle Database 11g: Performance Monitoring, Recovery Concepts and Backup
  • Oracle Database 11g: Recovering, Moving, and Enhancing the Oracle Database

^top

Additional Information for Stage 10:

• Oracle 1Z0-053 Oracle Database 11g: Administration II
  • Oracle Database 11g: Database Architecture and ASM
  • Oracle Database 11g: Configuring for Recovery
  • Oracle Database 11g: Configuring for Backups
  • Oracle Database 11g: Using RMAN for Recovery
  • Oracle Database 11g: Supporting RMAN and Using Flashback Technology
  • Oracle Database 11g: Diagnosing the Database and Managing Memory
  • Oracle Database 11g: Database Performance and Space Management
  • Oracle Database 11g: Managing Resources and Task Automation
  • Oracle Database 11g: Globalization

^top

Additional Information for Stage 11:

• Oracle Exam 1Z0-054 Oracle Database 11g: Performance Tuning
  • Oracle Database 11g: Performance Tuning Methodology and Tools
  • Oracle Database 11g: Using AWR and Defining Problems
  • Oracle Database 11g: Metrics, Alerts, Baselines, AWR Tools, and Services
  • Oracle Database 11g: Problem SQL Statements and Oracle Optimizer
  • Oracle Database 11g: SQL Performance Management and Database Replay
  • Oracle Database 11g: Shared Pool and Buffer Cache Tuning
  • Oracle Database 11g: Tuning PGA, Temporary Space, and AMM
  • Oracle Database 11g: Segment Space, I/O, and Performance Tuning

^top