Oracle DBA Training @ SysAdminExperts - Pune - 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 Admin1
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 Admin2
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 11g 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

Contact Details:
SysAdminExperts - Pune
Email: info@sysadminexperts. com
Web: www.sysadminexperts.com