Oracle DBA’S: oracle DBA’s role - DBA job classification - types of databases. Oracle database 10g architecture: database structures – processes. Schema management: types of SQL Statements- creating and managing table spaces- indexes-managing database integrity constraints .

Oracle transaction management: oracle transactions - transaction properties - transaction concurrency control - isolation levels - implementing oracle’s concurrency control - using undo data to provide read consistency - transaction query - discrete transactions -autonomous transactions – re asumable space allocation.

Using Data Pump Export and Import : Creating Directory , Data pump export options, starting a data pump export job, Data pump import options, starting a data pump import job. Using SQL * Plus: Starting and Exiting SQL * Plus,SQL * Plus and SQL Commands, Key SQL * plus working commands, Commands for formatting SQL* Plus output and creating reports, Creating command in SQL* Plus, Editing within SQL * Plus, Key SQL * Plus Database Administration Commands, using SQL to generate SQL.

Backing up databases: backing up oracle databases - the recovery manager - backing up control file - oracle back up tool – user managed backups - database corruption detection. Database recovery: types of database failures - oracle recovery processes - performing recovery with RMAN.Flashback Tables and Databases - Basic Oracle Security: Users, Roles and Privileges, what Users can Grant.

Improving database performance: SQL query optimization - approach to oracle performance tuning - optimizing oracle query processing - oracle optimization and oracle cost based optimizer - writing efficient SQL - DBA’s role to improve SQL processing - Data Dictionary : Oracle Data Dictionary ,Using Static Data Dictionary Views -Using Dynamic Performance Views.