Oracle DBA

SQL (Structured Query Language)
  • Introduction SQL
  • Retrieving Data Using the SQL SELECT Statement
  • Restricting and Sorting Data
  • Using Single Row Functions to Customize Output
  • Manipulating Data
  • Reporting Aggregated Data Using the Group Functions
  • Displaying Data from Multiple Tables
  • Using the Set Operators
  • Using Sub queries to Solve Queries
  • Using DDL Statements to Create and Manage Tables
  • Creating Other Schema Objects
  • Managing Objects with Data Dictionary Views
  • Controlling User Access
  • Managing Schema Objects
  • Manipulating Large Data Sets
  • Generating Reports by Grouping Related Data
  • Managing Data in Different Time Zones
  • Retrieving Data Using Sub queries
  • Hierarchical Retrieval
  • Regular Expression Support
Administrator Workshop – I
  • Introduction
  • Installing the Oracle Database Software
  • Creating an Oracle Database
  • Managing the Oracle Instance
  • Managing Database Storage Structures
  • Administering User Security
  • Managing Schema Objects
  • Managing Data and Concurrency
  • Managing Undo Data
  • Automatic UNDO Management
  • Implementing Oracle Database Security
  • Configuring the Oracle Network Environment
  • Proactive Maintenance
  • Performance Monitoring
  • Backup and Recovery Concepts
  • Performing Database Backups
  • Performing Database Recovery
  • Performing Flashback
  • Flashback data archive
  • Log Minor Features
  • Moving Data
Administrator Workshop – II
  • Introduction
  • Configuring Recovery Manager
  • Using Recovery Manager
  • Data Recovery Advisor
  • Recovering from Noncritical Losses
  • Database Recovery
  • Flashback
  • Dealing with Database Corruption
  • Monitoring and Managing Memory
  • Automatic Performance Management
  • Managing Schema Objects
  • Partitioning in Oracle
  • Managing Storage
  • Automatic Storage Management
  • Managing Resources
  • Automating Tasks with the Scheduler
  • Database Security
  • Using Globalization Support
  • Using Materialized Views
  • Java in Oracle
  • An Introduction to Java
  • JDBC Programming
  • Java Stored Procedures
Duration: 2.5 Month