Learn the roles and responsibilities of Oracle DBA who administers the oracle database server Browse through the contents of the program.
Oracle DBA Course Contents |
Over View of RDBMS Concepts. |
Over View of Oracle Architecture and its components |
Explain the difference between Oracle Instance and Oracle Database. |
Brief discussion on the user connectivity to oracle database and data access. |
Brief discussion about the different administrative and end user tools available with Oracle. |
Obtaining Oracle software from Oracle Technology Network( Study Purpose Only). |
Understanding the pre-requisite for installing oracle software on Windows and Linux Enviornment |
Discussion about Oracle Flexible Architecture(OFA) |
Installing Oracle Software Windows and Linux platform |
Identify and configure commonly used environment variables |
Creating Database using DBCA |
Use DBCA to Delete a database. |
Use DBCA to manage templates . |
Understanding Oracle Enterprise Manager. |
Difference Between Database Control and Grid Control. |
Use SQL*Plus and iSQL*Plus to access the Oracle Database |
Modify database initialization parameters |
Describe the stages of Database Startup and Shutdown |
Understanding the Database alert log file. |
Use of Data Dictionary and dynamic performance views |
Describe how table row data is stored in blocks |
Define the purpose of tablespaces and data files |
Explain space management in tablespaces |
Create tablespaces |
Manage tablespaces: alter, drop, take offline, put online, add data files, make read-only or read-write, generate DDL |
Obtain tablespace information |
Explain key features and benefits of ASM |
Create and manage database user accounts |
Create and manage roles |
Grant and revoke privileges |
Create and manage profiles |
Understaning Database Audit Features |
Understanding Fine Grained Audit Policy and enabling FGA |
Create and modify tables |
Define constraints and states of constraints |
Dropping and truncating tables |
Create and use B-Tree and Bitmap indexes |
Create Views |
Create sequences |
Use data dictionary |
Manipulate data through the use of SQL |
Identify and administer PL/SQL objects |
Describe triggers and triggering events |
Define levels of locking |
List possible causes of lock conflict |
Monitor and resolve lock conflicts |
Monitor and administer undo |
Configure undo retention |
Describe the relationship between undo and transactions |
Size the undo tablespace |
Use Database Control to Create additional listeners |
Use Database Control to Create Oracle Net service aliases |
Control Oracle Net Listeners |
Identify when to use shared servers versus dedicated servers |
Setting up of shared servers |
Discussion on optimizer modes and importance of database statistics |
Gather optimizer statistics . |
Manage the Automatic Workload Repository |
Use the Automatic Database Diagnostic Monitor (ADDM) |
Set warning and critical alert thresholds |
React to performance issues |
Use enterprise manager to view performance |
Tune SQL by using SQL tuning advisor |
Tune SQL by using SQL access advisor |
Use automatic shared memory management |
Use the memory advisor to size memory buffer |
Describe the types of failure that may occur in an Oracle Database |
Identify the importance of checkpoints, redo log files, and archived log files |
Difference between Instance recovery and Media Recovery |
Tuning instance recovery |
Configure a database for recoverability |
Configure ARCHIVELOG mode |
Performing Database Backup |
Discussion on various backup methods available in Oracle |
Create consistent database backups ( Offline Backups) |
Back up your database without shutting it down ( Online Backups) |
Create incremental backups |
Automate database backups |
Backup a control file to trace |
Enable Flash recovery area |
Monitor flash recovery area |
Diffence between complete and incomplete recovery |
Perform a compelete recovery |
Recover from loss of a Control file |
Recover from loss of a Redo log file |
Recover from loss of a system-critical data file |
Recover from loss of a non system-critical data file |
Describe flashback database |
Resotore the table contents to a specific point in time |
Recover from a dropped table |
Use Flashback Query to view the contents of the database as of any single point of time |
View transaction history or row with flashback transaction query |
Describe the general architecture of Data Pump |
Use Data Pump export and import to move data between Oracle databases |
Load data with SQL Loader |
Use external tables to move data |
Discussion on export and import utilities |