Email - info@dbauniversity.com

Phone -  720 934 1260, Chicago, USA.
Google Rating
4.9
BUY - LIVE Online TrainingBUY 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 attended the Oracle DBA course presented by Mr. Srini Ramineni; it was well planned and presented course. Mr. Ramineni’s DBA background, experience and way of presenting with practical examples really helped to understand most of Oracle DBA concepts clearly. Initially I was hesitant about the effectiveness of the online course, access to lab servers and availability. I would like to emphasize few important aspects that I liked in this training course, Mr. Ramineni’s Oracle DBA knowledge, his patience and ability to manage audience with different level of knowledge and background, interactive white board teaching experience over traditional PowerPoint presentation, course material, lab server and instructors availability to learn and apply the concepts. I really appreciate Mr. Ramineni’s dedication for extending the course duration to cover the topics that he planned in the course.

    I strongly recommend this course for anyone who is interested start their career as Oracle DBA.

  2. 4

    It was really great to be a part of ORACLE SQL class. Teacher was very cooperative and helpful. I am planning to do more classes with them in future.

  3. 5

    My experience with DBA-U was a very positive one. The latest class I attended was the Big Data Offering. I am a hands-on learner, and I do not do well with just lectures. The working labs and AWS setup made this course worth every penny. Srini was/is an excellent guide through the Big Data Maze and introducing the class to the tools of the trade as well as solid fundamentals.

  4. 5

    I highly recommend DBA University Inc to anyone looking for hands on DBA training for career change or advancement in the field of database administration.

  5. 5

    The Java course was an excellent course! I loved it! It will help me greatly with future projects.

  6. 4

    DBA training was very good , dedicated and gave us the most important topics that we need as an oracle DBA .My advice to all is to be prepared for this course study day by day as you could and keep searching about more details to get the full benefit from this training .
    Thanks to Srini he was very helpful ,patient and friendly.

  7. 5

    DBA University is very good for the ORACLE DBA class that I took recently. The instructor Srini is highly knowledgeable and experienced, and gives realistic examples to make students understand the topic clearly. The course covered all of the topics required for Oracle DBA job. Also, the ebook provided by DBA university is very useful and helpful.
    I am fully satisfied with the class, and I would like to take RAC and ASM class also, in the near future, from DBA university only.

  8. 4

    I took ORACLE DBA 11GR2 class with DBA University during Jun-JUL 2014. Srini ia a awesome tutor. He is methodical and brings in lot of practical example to the board.

    I will not think twice to take any further course with DBAUniversity

  9. 4

    I really enjoyed my Oracle SQL PL/SQL course at the DBA University. The SQL course was very detailed and the instructor was very knowledgeable and he provided a lot of additional information about Oracle some of which are not covered in the course content but very useful in my everyday work as a SQL developer. I would definitely recommend this course for anyone who wish to learn SQL, however, I feel that the PL/SQL section of the course was rushed and I wish we had more time for that.

  10. 5

    I recently took the oracle Dba training at the DBA University taught by Srini Ramineni. I am well pleased with his teaching strategies.He made the course more understandable in the ways he uses graphical explanations to walk the class through real world scenario. The University also provides adequate training materials and Lab practice on steps by steps approach to resolving real world databases issues. In all I have enjoyed the training and I’m looking forward to taking a course in Rac and Asm soon.

  11. 1 2 3 4 5
50 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