Oracle DBA

Instructor Profile


Get trained by a certified master. Our instructor is an Oracle Certified Master & Oracle Certified Professional in Oracle 10g, 9i, 8i & 8 & certified Project Management Professional having 12 years of exhaustive experience in IT and over 8 years of experience in Oracle Database Administration. Check out his profile on Oracle's site at http://www.oracle.com/technology/ocm/aagarwal.html.

Oracle Certified Master

Course Contents


This is an ideal course for those who want to get started with Oracle Database Administration. This course explains the fundamental concepts of Oracle Database and covers the following topics

  • Oracle Architecture – Understand the fundamental components of Oracle database which includes Oracle’s Memory Structures, back ground processes and different database files.
  • IInstallation of Oracle Software
  • Creating an Oracle Database
  • Managing Oracle Database Instance : Starting up & shutting down database and various stages of starting up and shutting down
  • Understand Oracle’s data dictionary and different dynamic performance views
  • Understand and manage the different components of Oracle Database which includes
    • Password File
    • Initalization Parameter File
    • Control File
    • Redo Log Files
    • Tablespaces & Datafiles (SYSTEM & SYSAUX, Temorary, Undo, Data, Archived redo log files)
  • Understand Relationship among the different storage structures which includes tablespace, datafiles, segments, extents & blocks
  • Understand and manage the database objects & security which includes
    • Users
    • Roles
    • Password Security, Resources & Privileges
    • Tables, Indexes, Views, Sequences, Synonyms
    • Functionis, Procedures, Packages, Trigger
  • Auditing
  • Using Oracle Enterprise Manager for managing Oracle Database
  • Configuring Network to access Oracle Database
  • Managing Oracle Software and applying patches
  • Basic Backup & Recovery concepts, backing up and restoring database using RMAN

Class Schedule


Live online classes have started from Saturday, 1st March 2008. Refer to the following table For next batch schedule. Please contact us to register for the next batch.

Next batch starting on Registration
Friday, 6th June 2008 Open
Monday, 16th June 2008 Open
Monday, 23rd June 2008 (Tentative date) Contact us

 

If you are in a group of 3 or more, the training can be arranged at your preferred time and pace. For customized training programs for individuals, groups & companies, please contact us directly.

Audience


This course will be useful for the following category of people who wants to learn Oracle Database Administration

  • Developers who want to acquire DBA knowledge
  • Non-Oracle DBAs (e.g. SQL Server DBA) who wants to learn Oracle
  • Fresh IT graduates who want to make a career in Oracle Database Administration
  • Management professionals who wants to understand about database

Pre-requisites


  • Prior exposure to database system (in any role)
  • Basic idea of Linux operating system
  • Basic knowledge of SQL

If you are not sure whether you should be doing this course, please contact us and we will schedule a one-to-one discussion with you to understand your requirements and advise you.

Training Methodology


This training will be through live online class with voice & presentation. Please refer to our section How-it-works to know more about the training methodology.

At the end of a chapter there are lab exercises that a participant need to complete. For these lab excercises, participants will be provided access to his/her own dedicated Linux server. You will need to install the secured shell client (SSH client) like Putty and VNC Viewer to access the Linux box. Both these software are free and download links and instruction will be provided. This dedicated Linux server will be available to you 24 hours a day for the entire duration of your course. The Oracle Database version will be 11g.

There will be a maximum of only 5 participants per batch.

Training Duration


The total training duration is 32 hours divided in 8 sessions with 3 hours of theory and 1 hour of guided practical per session.

At the end of the each theory session, you are expected to finish all the lab exercises before next session. (Please note that Instructor will be available online during your practical). You’ll have 24 hrs accesses to Linux Server to complete the practical.  

If required, at the end of the course, each participant can have dedicated one-on-one session of 2 hours with the instructor for clarifying any doubt or asking any question.

Register Now


Click on the "Pay Now" button to register for the Oracle DBA training. Clicking on the following button will re-direct you to our payment page where you can pay using credit card. Once the payment is received, we will get in touch with you with further details.