This course provides students with the knowledge and skills to capitalize on their skills and experience as a DBA to manage a Oracle Server system.
This Oracle DBA training course is an intensive hands-on course is designed to provide Oracle professionals with an in-depth understanding of the DBA features of Oracle, specific Oracle concepts and knowledge required for the OCP exam, and tips and techniques for passing the Oracle OCP exam on your first attempt.
Broad in scope, this course covers all of the Oracle Database Administration topics including SGA instance management, file & tablespace management, user administration & security and table & index management.
Hands-on exercises are used to demonstrate each feature and the student will gain first-hand experience in the key Oracle DBA concepts required to pass the Oracle OCP exam. In addition, this course provides sample OCP exam questions and an opportunity to access your overall knowledge of Oracle DBA concepts.
This course is intended for those who want to work as a Database Administrator. This course covers Oracle Database Administration 10g.
Knowledge of Computer Basics like A+, Network Basics and Microsoft office.
Students are normally required to have Bachelors Degree along with a working knowledge of IT and computers. However, if a candidate is found exceptionally qualified in IT related field (e.g. SW programming, Networking, Hardware etc.), degree requirement for him/her is exempted, but they must have 2 years of college attendance (completed certain credits).
SQL & PL/SQL 2 Days (12 hours)
Space Management Strategies
Wrap up and Closure
Oracle Integration Services
Building simple packages
Planning for and recovering from disasters
Implementing database mirroring
The Oracle Agent
Managing transactional replication
1-1: Overview of Oracle DBA tasks
1-2: Instance Architecture
1-3: Oracle Instance Internals
1-4: Using SQL *Plus for DBA Management
1-5: Control File, UNDO and REDO Management
1-6: User and Privilege Management
2-1: Overview of Instance Management
2-2: Initialization file Management
2-3: Oracle Instance Internals
2-4: Data buffer configuration & sizing
2-5: Shared pool and PGA Configuration & sizing
2-6: Troubleshooting network connectivity
3-1: ORACLE tables, views and materialized views
3-2: Oracle indexes
3-3: Oracle Constraints
3-4: Schema, File & Tablespace Management
3-5: Database Maintenance
3-6: Oracle DBA Utilities
This section explores the methods used for monitoring all active components of the Oracle database.
4-1: Dictionary and v$ views
4-2: Table & index monitoring
4-3: Workload & trend monitoring
4-4: Instance monitoring
4-5: Oracle environment monitoring
4-6: STATSPACK and AWR performance management
This section explores the methods used for performance management in Oracle and shows tips and scripts for monitoring all components of any Oracle database. You will also learn the proper action to take when any area of Oracle becomes a bottleneck.
5-1: Bottleneck Performance analysis
5-2: Instance Tuning
5-3: SQL and CBO behavior
5-4: Tracing SQL Execution
5-5: SQL Execution Internals
5-6: SQL Testing
6-2: Backup & Recovery