Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.8
BUY TRAINING

Overview

Database Administrators (DBAs) are responsible for the design, implementation, support and maintenance of computerized databases in today’s organizations. The role also includes architecting, building and scaling databases for future data growth and capacity. They are also responsible for security, performance and availability of data to users and customers. .

All the above tasks are performed with the help of a Database Management System (DBMS) and the leading and most widely used DBMS across the world today are the Oracle Database, Microsoft SQL Server, MySQL database etc. Out of the three DBMS technologies, Oracle Database is the most popular and widely used database in the world today. Oracle ASM, RAC and Data Guard are some advanced options in the Oracle database software that help provide high availability and protection of data.

Database Administrator Job Growth

DBAs play an important and responsible role in every company’s Information Technology (IT) department. DBAs are also very well paid and the average annual salary is more than $100,000 in the USA.

Among all the IT/computer best jobs in a recent CNN.com Best Jobs in America report, Database Administrator job has the highest job growth forecast (30% increase) for the next 10 years until 2023.. www.cnn.com also published an article recently that Database Administrators stand # 14 out of 100 BEST AMERICA JOBS

Oracle RAC, ASM and Data Guard

We are currently offering a world class training program for interested students and professionals in Oracle RAC (Real Application Clusters), ASM (Automatic Storage Management) and Data Guard. The skills learnt from this course have huge demand in the job market. Registration for this training course is open for anyone in the world because it is an online course.

 Course Details

1. Taught by Srini Ramineni (Founder, DBA University).
2. The training course consists of 21 sessions (21 videos) with each such video about 1 hour to 1.5 hours in duration.
3. Students get access to all the 21 videos for 12 months on a 24*7 basis.

4. Remote LAB access: We will give our Remote Desktop Connection for Oracle ASM lab practical exercises of the training. For remaining topics of the training, students have to setup the lab on their PC (Windows or Mac). We will provide guidance on setting up the cluster on your PC through a special virtual machine (VM).

Our training material’s detailed screenshots and notes will make it very easy to build the 2 node Oracle RAC cluster on your PC.

We will provide 1:1 support by conducting an online meeting to resolve any issues you may face while building the 2 node Oracle RAC cluster on your PC.

We require students to have at least 8 GB of memory on their desktop (or) laptop. We will provide access to download this virtual machine using Dropbox email download.

5. Click HERE to download the training brochure (course topics and more details).
6. This course is based on Oracle 12c R1 version.
7. The training contains Oracle high availability topics such as Oracle ASM, Oracle RAC and Data Guard which have a huge demand in the job marketplace.
8. The tuition fee for the course is $499 (all-inclusive price).
9. Every student gets access to download our 400 page PDF training material using Dropbox.com email download.

Course Topics

Oracle 12c Automatic Storage Management (ASM) Install and setup
Introduction and benefits of Oracle ASM.
Oracle ASM 12c software installation and configuration (Grid Infrastructure).
Partitioning Disks in LINUX.
Oracle ASMLib Utility for managing ASM Disk Storage.
Oracle 12c ASMCA (ASM Configuration Assistant).
ASM Parameter file, ASM Instance and working with DISKGROUPS.
Querying ASM Information.
Creating Database Files using ASM.

Oracle Automatic Storage Management (ASM) Mirroring Disks
Understanding ASM Disk Redundancy (Mirroring).
Learn about the three levels of ASM redundancy.
How Oracle manages ASM Disk failures.
How to replace a failed ASM disk with a new disk.
ASM Disk Rebalancing operations.

Oracle 12c Real Application Clusters (RAC)
Components of an Oracle RAC environment.
Understand the various storage, network and hardware requirements in Oracle RAC
Setup two Linux servers in a network before creating a 2-Node Oracle RAC database.
Pre-requisites for Oracle RAC installations.
Installation and configuration of Oracle Grid Infrastructure in cluster mode.
Understand the functionality of Oracle Clusterware storage (Voting Disk, OCR Disk).
How to backup and restore Oracle Clusterware storage (Voting Disk, OCR Disk).

RAC Database connections
Creation of an Oracle 12c Multi-tenant RAC database and instances using ASM storage.
Differences between a RAC database and the non-RAC database (single instance).
How to change initialization parameters for an Oracle RAC database.
Advantages of Oracle Single client access name (SCAN) in RAC database connections.
Understand and perform connection failovers of SCAN Listeners and Local Listeners.
Understand database services for Oracle RAC in a multi-tenant architecture.
Oracle Net Services configuration for a cluster database.

Oracle 12c RAC database backup and recovery
How to backup Oracle RAC databases using RMAN Utility.
Backup of Oracle RAC databases in a CDB (Multi-tenant) vs non-CDB environment.
How to setup RMAN backup retention policies in an Oracle RAC database

How to perform common administration operations in RAC databases
How to use the cluster verify utility for performing health checks in Oracle RAC.
How to utilize Global performance views (GV$ views) in monitoring RAC instances.
How to terminate database sessions in Oracle RAC.
How to clear database transactional row level locks in Oracle RAC.
How to perform Oracle database export and import operations in cluster mode.
Understand the new Oracle OPatchauto tool introduced in Oracle 12c.

Oracle 12c Data Guard
Introduction to Oracle 12c Data Guard and its various protection modes.
How to enable an Oracle database to belong to a Data Guard configuration.
Understand the initialization parameter requirements of Primary and Standby databases.
Create a physical standby database using Primary database full RMAN backup.
How to configure a Primary database to become a future standby database.

Managing a Data Guard Environment
Understand Oracle data dictionary views for monitoring Log Shipping and Log Apply.
Introduction to Oracle Data Guard broker (DGMGRL) utility.
Advantages of DGMGRL over the traditional sqlplus utility.
How to create a Data Guard Broker configuration.
How to perform a switchover operation using Data Guard Broker.


Course Reviews

4.8

4.8
48 ratings
  • 5 stars39
  • 4 stars9
  • 3 stars0
  • 2 stars0
  • 1 stars0
  1. 4

    i enjoyed my PL/SQL training class the best please to take the program i look forward to take more classes with DBA

  2. 5

    Oracle PL/SQL is a good course from DBA university, instructor is very knowledgeable. The course materials is very helpful for learning

  3. 5

    I recently took the Oracle DBA course taught by Srini Ramineni. I was impressed with the course and the way the material was presented. I have taken much more expensive training where the instructor simply puts the book material in a Powerpoint presentation and reads it line by line. This course is not like that. It is very interactive. All of the material is written on a white board and explained in a way that is easy to understand. This is a fantastic course and will provide you with a good, solid core set of DBA skills. I would definitely consider taking another course from DBA University.

    Dennis

  4. 5

    I have really enjoyed the Oracle DBA training sessions. I highly appreciate the level of patience and professionalism from Srini Ramineni. He is an excellent trainer with unique approach. I have never come across such intense, well-structured, and hand-on online training before. This is one of a kind. Thanks to DbaUniversity!!

  5. 5

    I have taken the Oracle Rac and Dataguard course with Michael Melchar. It was a great class. The lab was well designed that I can really get hand on experience for setting up the RAC environment. Without the help from Michael, I don’t think I can do it myself. I have been an DBA for 20 years but I tried to learn RAC. It was very difficult until I took this class. The price is extremely pleasant compare to Oracle. I also like the schedule that we meet 2 hours a day for 4 days a week. At such, you have a chance to digest the class material.

  6. 5

    I took the Oracle DBA course and was very impressed with the teaching method and course material. Srini is a top notch instructor. He is very detailed in explaining different scenarios, and answers questions very well. I have learnt a lot from Srini’s vast knowledge and real life working experience. I just had a job interview with a senior dba, and most of the questions asked were scenarios explained in class by Srini. I would absolutely recommend DBA University to anyone wishing to get into the oracle dba field.

  7. 5

    I recently took Oracle RAC and data guard class with Michelle Malcher, It was simply a great class. Michelle is highly knowledgeable, her course material and classes were very informative. We had sufficient time to complete the lab and learnt a lot and the course was pretty hands-on. I have tried creating RAC myself in the past but was never successful, but after taking the course it helped me and makes me feel very confident. We created the RAC and data guard environments on our personal laptop which is much better, even for future reference. I would highly recommend anybody looking for a career as DBA.

  8. umugwaneza Marie Providence01/23/2015 at 7:55 am

    5

    As a DBA Junior, I took the PL/SQL Course in march 2014 and ORACLE DBA in august 2014 from DBA university. The DBA university has an excellent way of teaching and transmetting knowledge through its expert teacher in database administration and programming. I have improve myself and I met my career goal. The lecture and training materials are well organized , the lab practice was very helpful. The Instructor is very smart, patient and answered questions. I would recommend for anyone who is interested to learn this course, He won’t regret. I am preparing for next course with DBA Center of ORACLE RAC, DATA GUARD

  9. 4

    Interactive session with lab sessions and very useful tips during the sessions. No disappointment at all for anyone.
    Thanks to Srini.

  10. 5

    I have taken the DBA I, Srini is an excellent teacher. What I like about him is that, he is passionate about this teaching thing. He makes sure that you understand the materials. The most notable part of this class was, Srini would bring a up a situation from real world and discuss it in the class then solve the problem. I felt very comfortable with his teaching technique, I am thinking of taking the PS/SQL course with him.

  11. 1 2 3 4 5
BUY TRAINING
  • $499.00
  • 365 Days
62 STUDENTS ENROLLED

See what others are buying

Contact Details

DBA University
605 W Madison St Suite 1108
Chicago IL 60661
United States of America

Ph 720 934 1260
Email info@dbauniversity.com

Setup Menus in Admin Panel

X