Oracle DBA Online Training

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
Contact us today at info@techflames.com or call us at +91-9100947004.