Oracle DBA Training At SysAdminExperts - Pune

*** UNIX
Fundamentals
Architecture
Commands
File System
The vi Editor
The SHELL & Shell Scripting

***SQL
Creating and altering tables and views
Writing and running PL / SQL programs from SQL*Plus or SQL Developer
Using SQL statements within PL/SQL
Conditional execution and loop constructs
Triggers, Cursors
Trapping and handling errors and exceptions in code
Implementing nested and labeled loops and blocks
Exceptions
Handling PL/SQL records and tables

***DBA Part1
Installing and Configuring Oracle
Creating and Managing Database Storage Structures
Managing Users, Profiles, Privileges and Roles
Maintaining Database Security
Monitoring the Performance of the Database
Backing Up and Recovering the Database

***DBA Part2
Planning a backup strategy and a disaster recovery strategy
Altering a database to ARCHIVELOG and NOARCHIVELOG modes
Performing online and offline backups
Recovering a database from non-critical losses
Performing logical backups with the export and import utilities
Reviewing database logs for diagnostic purposes
Automating management tasks with the scheduler

***RAC
Installing and configuring an Oracle 10g RAC Database
Administering and Monitoring a RAC database using Enterprise Manager and command line tools
Using configuration and management tools for RAC databases
Administering ASM using command line and GUI clients
Setting up services for workload management and application high availability
Backing up, restoring and recovering a RAC database
Creating duplicate and standby databases in a RAC Environment
Monitoring and tuning the performance of a RAC database