Oracle DBA Training In Bangalore

Oracle DBA Training In Marathahalli & Best Oracle DBA Training In Bangalore

Learn Oracle DBA from RIA Institute of Technology

RIA Training Bangalore offers the Best  Oracle DBA Training from beginner level to advanced techniques, taught by experienced working professionals in  Oracle DBA for more than 5 years. Our  Oracle DBA Training in Bangalore you’ll learn real-time concepts in expert level in a practical manner.

We at RIA Training Bangalore focus on delivering the  Oracle DBA Training that best suits you, whether it is regular classes or weekend batch. We understand your need for learning  Oracle DBA and we work together to deliver the best Training in  Oracle DBA that help you in building your future. 

Training Bangalore provides end-to-end support and helps you in identifying and learning the best course from our Training Institute.

Who can benefit from  Oracle DBA Training in Bangalore?

Students and professionals with experience ranging from 0 -15 years can take advantage of  Oracle DBA Training in RIA Training Bangalore and grow faster in a career. 

To support students we provide week day classes with theory and practical exposure. RIA Training Bangalore Institute is equipped with advanced lab where students can practice  Oracle DBA course on real-time scenarios.

To know more about  Oracle DBA Training in Bangalore talk to our experts.

We Cover the following Topics in Oracle DBA Training

Course Content Oracle DBA

Oracle Features:
  • Why Oracle?
  • Necessity to Upgrade to new versions
  • Overview of Grid Architecture
  • System Requirements
  • Installing Oracle 11g on Linux 
  • Installing Software with Universal Installer
Oracle Architecture
  • Overview of Database
  • Database logical Structures
  • Database Physical Structures
Oracle Memory Structures and Instances
  • System Global Area (SGA)
  • Overview of SGA
  • Discussions on all SGA Components
  • Discussion on Program Global Area (PGA)
  • Discussion on Oracle Background Process
  • Configuring Parameter file and discussion on various init.ora parameters
Database Creation
  • Database creation Planning
  • Prerequisites for Database Creation
  • Creating Database Manually
  • Advantages of using DBCA
  • How to drop a Database
Instance and Database Startups and Shutdowns
  • How to Start/Stop an Instance
  • How to Start/Stop the Database
  • Mounting a Database
  • Opening a Database
  • Closing a Database
  • Shutting down an instance
Tablespace Management
  • Overview of Tablespaces
  • Different Types of Tablespaces
  • Adding Datafiles to existing Tablespace
  • Renaming and Resizing Datafiles
  • Creating and Managing Temporary Tablespace and Temporary Tablespace groups
  • Sizing the Tablespaces and creating different Tablespaces
Storage Parameters
  • What are Segments?
  • What are Extents?
  • What is Block?
  • Oracle Blocks
  • Dictionary Managed Tablespace
  • Locally Managed Tablespace
  • Storage Parameters (Initial, Next, Min Extents, Max Extents, PCT Increase)
Undo Management
  • Creating UNDO tablespace
  • Monitor and Administer UNDO
  • Configuring UNDO retention
  • Configuring UNDO retention with guarantee
  • Dropping UNDO tablespace
  • How to change the default UNDO tablespace
  • Discussion on Snapshot too old error
User Management
  • Creation of Users
  • Assigning Privileges
  • Creating and Granting Roles
  • Allocating Tablespace Quotas to Users
  • Assigning default Tablespace for Users
  • Setting Profiles to Users
  • Levels of Authentication
  • Schema Management
Configuring Database in Archivelog and Noarchivelog mode

Redolog and Controlfile Management

Server Parameter (SP) File and Oracle Managed Files

Oracle Networking with Oracle 11g

Configuring Oracle Listener and TNSNAMES.ora Files

Database Backups
  • Logical Backup (Exp and Imp)
  • Datapump(Expdp and Impdp)
  • Cold Backup (Consistent/Offline Backup)
  • Hot Backup (Inconsistent/Online Backup)
Database Restore and Recovery
  • Complete Recovery
  • Incomplete Recovery
  • Recover from loss of a Control File
  • Recover from loss of a Redolog file
  • Recover from loss of a Datafile
Recovery Manager (RMAN)
  • Configuring RMAN
  • Performing Database backups (Full, Incremental, Cumulative) using RMAN
  • Database Recovery using RMAN
  • Backup and Recovery Database using Catalog and No Catalog
Oracle Flashback Database
  • What is Flashback Technology?
  • Configuring Database in Flashback mode
  • Monitoring Flashback Database
  • Best Practice for Databases and Flashback Recovery Area
  • Flashback databases examples
Database Cloning and Upgradation

Oracle 11g Dataguard Configuration
  • Configuring Oracle Dataguard
  • Configuring Physical, Logical, Snapshot Standby Databases
  • Data protection modes
  • Switchover and Failover Cases
  • Understanding snapshot Standby & Active Dataguard
Automatic Storage Management:
ASM Concepts:
  • Understanding Oracle grid Infrastructure and installing Oracle grid Infrastructure
  • ASM general Architecture
  • Creating ASM based Databases
  • Creating Tablespace that use ASM storage
  • Creating and administrating ASM Diskgroups
  • Enhancements of ASMCMD
  • Managing grid with srvctl and crsctl
Performance Tuning
  • Database Tuning
  • AWR/ADDM/ASH Report generation and Analysis
  • Managing Optimizer Statistics
  • Gathering Optimizer Statistics
  • Explain plan/TKprof
  • Sql Tuning
Brief Introduction on Oracle RAC
  • RAC Architecture
  • Linux Pre-Installation Steps
  • Installation of Oracle Clusterware for RAC
  • Installation of 2 Node RAC with ASM
  • Adding Nodes to RAC
  • Server and Database Control Utility