Best Oracle DBA/RAC Training in Bangalore

1. Oracle 19c DBA (OCP)

For Oracle Database 19c OCP DBA needs to pass these two exams.
1-Prepare for Oracle Database Administration I | 1Z0-082

2-Prepare for Oracle Database Administration II | 1Z0-083

Oracle Database Administration I (1Z0-082)

1. Understanding Oracle Database Architecture – Oracle Database: Administration Workshop

• Understanding Oracle Database Instance Configurations

• Understanding Oracle Database Memory and Process Structures

• Understanding Logical and Physical Database Structures

• Understanding Oracle Database Server Architecture

2. Managing Users, Roles and Privileges – Oracle Database: Administration Workshop

• Assigning Quotas to Users

• Applying the Principal of Least Privilege

• Creating and Assigning Profiles

• Administering User Authentication Methods

• Managing Oracle Database Users, Privileges, and Roles

3. Moving Data – Oracle Database: Administration Workshop

• Using External Tables

• Using Oracle Data Pump

• Using SQL*Loader

4. Configuring Oracle Net Services – Oracle Database: Administration Workshop

• Using Oracle Net Services Administration Tools

• Configuring Communication Between Database Instances

• Configuring the Oracle Net Listener

• Connecting to an Oracle Database Instance

• Comparing Dedicated and Shared Server Configurations

• Administering Naming Methods

5. Managing Undo – Oracle Database: Administration Workshop

• Understanding Transactions and Undo Data

• Storing Undo Information

• Configuring Undo Retention

• Comparing Undo Data and Redo Data
• Understanding Temporary Undo

6. Using Conversion Functions and Conditional Expressions – Oracle Database: Introduction to SQL

• Applying the NVL, NULLIF, and COALESCE functions to data

• Understanding implicit and explicit data type conversion

• Using the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions

• Nesting multiple functions

7. Using SET Operators – Oracle Database: Introduction to SQL

• Matching the SELECT statements

• Using the ORDER BY clause in set operations

• Using The INTERSECT operator

• Using The MINUS operator

• Using The UNION and UNION ALL operators

8. Managing Views – Oracle Database: Introduction to SQL

• Managing Views

9. Retrieving Data using the SQL SELECT Statement – Oracle Database: Introduction to SQL

• Using Column aliases

• Using The DESCRIBE command

• Using The SQL SELECT statement

• Using concatenation operator, literal character strings, alternative quote operator, and the DISTINCT keyword

• Using Arithmetic expressions and NULL values in the SELECT statement

10. Reporting Aggregated Data Using Group Functions – Oracle Database: Introduction to SQL

• Restricting Group Results

• Creating Groups of Data

• Using Group Functions

11. Managing Tables using DML statements – Oracle Database: Introduction to SQL

• Managing Database Transactions

• Using Data Manipulation Language

• Controlling transactions

12. Managing Schema Objects – Oracle Database: Introduction to SQL

• Creating and using temporary tables

• Managing constraints

13. Managing Database Instances – Oracle Database: Administration Workshop

• Starting Up Oracle Database Instances
• Using Data Dictionary Views

• Shutting Down Oracle Database Instances

• Using Dynamic Performance Views

• Using the Automatic Diagnostic Repository (ADR)

• Using the Alert Log and Trace Files

• Managing Initialization Parameter Files

14. Managing Storage – Oracle Database: Administration Workshop

• Managing Resumable Space Allocation

• Shrinking Segments

• Deferring Segment Creation

• Using Space-Saving Features

• Deploying Oracle Database Space Management Features

• Managing Different Types of Segments

• Using Table and Row Compression

• Understanding Block Space Management

15. Accessing an Oracle Database with Oracle supplied Tools – Oracle Database: Administration Workshop

• Using the Database Configuration Assistant (DBCA)

• Using Oracle Enterprise Manager Cloud Control

• Using racle enterprise Manager Database Express

• Using SQL Developer • Using SQL Plus

16. Managing Tablespaces and Datafiles – Oracle Database: Administration Workshop

• Viewing Tablespace Information

• Creating, Altering and Dropping Tablespaces

• Managing Table Data Storage

• Implementing Oracle Managed Files

• Moving and Renaming Online Data Files

17. Restricting and Sorting Data – Oracle Database: Introduction to SQL

• Applying Rules of precedence for operators in an expression

• Limiting Rows Returned in a SQL Statement

• Using Substitution Variables

• Using the DEFINE and VERIFY commands

18. Displaying Data from Multiple Tables Using Joins – Oracle Database: Introduction to SQL

• Using Self-joins

• Using Various Types of Joins
• Using Non equijoins

• Using OUTER joins

19. Understanding Data Definition Language – Oracle Database: Introduction to SQL

• Using Data Definition Language

20. Managing Data in Different Time Zones – Oracle Database: Introduction to SQL

• Working with CURRENT_DATE, CURRENT_TIMESTAMP,and LOCALTIMESTAMP

• Working with INTERVAL data types

21. Using Single-Row Functions to Customize Output – Oracle Database: Introduction to SQL

• Manipulating strings with character functions in SQL SELECT and WHERE clauses

• Performing arithmetic with date data

• Manipulating numbers with the ROUND, TRUNC and MOD functions

• Manipulating dates with the date function

22. Using Subqueries to Solve Queries – Oracle Database: Introduction to SQL

• Using Single Row Subqueries

• Using Multiple Row Subqueries

23. Managing Sequences, Synonyms, Indexes – Oracle Database: Introduction to SQL

• Managing Indexes • Managing Synonyms • Managing Sequences

Oracle Database Administration II (1Z0-083)

1. Oracle Database: Managing Multitenant Architecture Ed 1
o Creating CDBs and Regular PDBs
o Manage CDBs and PDBs
o Upgrading and Transporting CDBs and Regular PDBs
o Manage Security in Multitenant databases
o Backup and Duplicate
o Manage Application PDBs
o Recovery and Flashback
2. Oracle Database: Backup and Recovery Workshop
o Backup Strategies and Terminology
o Configuring and Using RMAN
o Performing Recovery
o RMAN Troubleshooting and Tuning
o Using Flashback Technologies
o Restore and Recovery Concepts
o Duplicating a Database
o Diagnosing Failures
o Transporting Data
3. Oracle Database: Deploy, Patch and Upgrade Workshop
o Patching Grid Infrastructure and Oracle Database
o Creating an Oracle Database by using DBCA
o Upgrade the Oracle Database
o Upgrading to Oracle Grid Infrastructure
o Oracle Restart
o Install Grid Infrastructure for a Standalone server
4. Oracle Database 18c: New Features
5. Oracle Database 19c: New Features for Administrators
o Using Availability Enhancements
o Using General Overall Database Enhancements
6. Oracle Database: Administration Workshop
o Monitoring and Tuning Database Performance
o Tuning SQL Statements