Oracle DBA Course Content

  • Introduction to Oracle : SQL (Exam – IZ0– 007) (Duration: 56 Hrs.)
    • Prerequisite
      • Computer Fundamentals, Windows Operating System
    • Take Aways
      • Create database tables.
      • Manage database objects.
      • Access and manipulate data in the database using SQL statements.
      • Control user access to data.
      • Oracle 10g : SQL Certification exam readiness
    • Course Contents
      • Introduction
      • Writing Basic SQL SELECT Statements
      • Restricting and Sorting Data
      • Single- Row Functions
      • Displaying Data from Multiple Tables
      • Aggregating Data Using Group Functions
      • Subqueries
      • Producing Readable Output with iSQL *Plus
      • Manipulating Data
      • Creating and Managing Tables
      • Including Constraints
      • Creating Views
      • Other Database Objects
      • Controlling User Access
      • SQL Workshop
      • Using SET Operators
      • Oracle 10g Datetime Functions
      • Enhancements to the GROUP BY Clause
      • Advanced Subqueries
      • Hierarchical Retrival
      • Oracle10g Extensions to DML and DDL Statements

  • Oracle Database 10g : Administration Workshop I (1Z0-042) Duration: 48 Hrs.
    • Prerequisite
      • Oracle Database 10g : SQL
    • Take Aways
      • Create Oracle database
      • Manage database objects, administer user security
      • Manage schema objects
      • Perform database backup & recovery
      • Oracle Database10g :AdminstrationWorskshop I Certification exam readines
    • Course Contents
      • Oracle Database
      • Oracle Instance
      • Database Storage Structures
      • Administering User Security
      • Schema Objects
      • Data and Concurrency
      • Managing Undo Data
      • Oracle Database Security
      • Oracle Network Environment
      • Proactive Maintenance
      • Performance Management
      • Backup and Recovery Concepts
      • Database Backup
      • Database Recovery
      • Flashback
      • Moving Data

  • Oracle Database 10g : Administration Workshop II (1Z0-043) Duration : 48 Hrs.
    • Prerequisite
      • Oracle Database 10g : Administration Workshop I
    • Take Aways
      • Use recovery manager
      • Deal with database corruption
      • Monitor & manage memory
      • Manage schema objects
      • Oracle Database10g :AdminstrationWorskshop II Certification exam readiness
    • Course Contents
      • Recovery Manager
      • Flashback
      • Database Corruption
      • Memory
      • Storage
      • Performance Management
      • Schema objects
      • Managing storage
      • Storage management
      • Resources
      • Scheduler

In order to view this object you need Flash Player 9+ support!

Get Adobe Flash player

Powered by RS Web Solutions