Oracle DBA with LINUX

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 packaged course is ideal for those who want to get started with Oracle Database Administration on LINUX. This course covers introduction to LINUX and Oracle Database Administration on LINUX 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.
  • Introduction to Linux: Understand the fundamentals of Linux which includes common commands & tool, Linux filesystem, differ distributions of Linux and supported distribution for Oracle.
  • Basic Shell scripting
  • Making Linux "Oracle Ready": Understand the pre-requisites for installing Oracle which includes kernel parameters, RPMs, filesystem requirements, users/groups and environment variables.
  • Installation of Oracle Software which includes creating an Oracle database
  • Managing Oracle on Linux: Understand Linux boot sequence, Starting up & shutting down database and configuring autostart of Oracle instance.
  • Monitoring and Troubleshooting Oracle on Linux: Different Linux & Oracle components to be monitored and using tools like OSWatcher.
  • Automate routing DBA activities using cronjob
  • Useful resources & next steps
  • Managing Oracle Database Instance
  • 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


Please use the contact us form to inquire/ register for the next batch.

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 on LINUX

  • 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

Pre-requisites


  • Prior exposure to database system (in any role)
  • 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 48 hours divided in 12 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.