Oracle Core DBA and Advanced DBA Courses
N-Axis is glad to announce the launching of two new courses – the “Core Oracle DBA” and the “Advanced Oracle DBA”.
The “Core Oracle DBA” course is specifically designed with the young graduates in mind. It caters to their career growth by empowering them with knowledge required to tackle the toughest and trickiest situations that may arise in the course of their work, thus placing them at an advantage over their contemporaries.
The “Advanced Oracle DBA” is for the already experienced and is designed to enhance the existing skills and knowledge. It enables them to tackle the practical troubles they may face in the execution of the project.
Both the courses can boast of an excellent and highly experienced faculty, who has been in the field for over a decade. Their vast theoretical and practical knowledge will ensure the right guidance to the students and will provide them with the intricate knowledge to precisely identify and solve any problem they may be faced with.
By the end of the course, we promise that the candidate will be more confidant and polished and equipped with knowledge to tackle any sort of a situation concerning their work.
Core DBA
The duration of this course is 8 weeks
This course is designed for candidates aspiring to be Oracle DBAs and also working DBAs with 0-2 years of experience.
The last date for receipt of applications is 30th Jun, 2010. Please hurry up as the seats are limited.
Oracle Architectural Overview
- Oracle Architectural Overview and components
- Define Instance and Database
- Key components of Database and Instances
- Instance and DB Background Process
- DB Parameter File and DB Password file creations
- Difference between 9i and 10g Database with new features
Managing Oracle Instance and Database Creation and Configurations
- Managing Oracle Instance
- Pre-requisites – Create Database
- Create Database using DBCA
- Manual Database create
- Configure Database in Archive-log mode
Manage Database and Physical files
- Understand and Manage Control Files
- Understand and Manage Data Files
- Understand and Manage Redolog Files
- Multiplexing DB control files
- Create / Drop / Alter Redo Log groups and Files
Tablespaces and Tablespace management
- Define Block, Extent and Segment
- Define Tablespace
- Role of Tablespace in Database
- Types of Tablespaces
- Locally Managed Tablespaes (LMTs)
- UNDO Tablespaces
- Alter / Drop Tablespaces
- Pros and Cons for Managing DB Tablespaces
Database User and Role Management
- User Creation
- Assign User role and Privileges
- User Profiles
- Alter / Drop User
- User and Assigned tablespeses
Backup and Recovery
- Backup and Recovery Overview
- Why Database Backup
- User managed Backups
- Backups in DB No archive-log mode
- Backups in DB Archive-log mode
|
Advanced DBA
The duration of this course is 8 weeks
This course is designed for working DBAs with 2-5 years of experience and looking forward to improve skills and get that competitive edge for career advancement.
The last date for receipt of applications is 30th Jun, 2010. Please hurry up as the seats are limited.
Advanced Backup and Recovery overview
- Database Recovery Manager (RMAN)
- Architecture and Architectural Components
- configurable parameters
- Recovery Catalog
- Complete Recovery
- Incomplete Recovery
Oracle Real Application Clusters
- Oracle Real Application Clusters
- Architecture and components
- Advantages of RAC
- RAC as High-available solution for Database
- Scalability
- Pre-requisites and Installation
- Cluster Ready Services (CRS)
- Database Storage Types for RAC
- Installation of Database Software for RAC
- Launching VIPCA with root.sh
- Database Creation using RAC
- Database Pre-creation Tasks
- Creating the cluster Database
- Database Post Installation Tasks
- Transparent Application Failover (TAF)
- Overview of TAF
- Validate and certify TAF
Performance Tuning
- DB Performance Tuning Overview
- Various Performance Tuning scenarios
- DBA scope for Performance Tuning
Oracle Application Server
- Oracle Application Server architecture
- Installations and Configuration of OAS
- OAS topologies
|