• Overview of Oracle DBA tasks
  
• Oracle as a flexible, complex & robust RDBMS
  
• He evolution of hardware and the relation to Oracle
  
• Different DBA job roles(VP of DBA, developer DBA, production DBA, database babysitter)
  
• The changing job role of the Oracle DBA
  
• Environment management (network, CPU, disk and RAM)
  
• Instance management (managing SGA regions)
  
• Oracle table and index management.

• Instance vs database
  
• Components of an instance
  
• Creating the OFA file structure (DBA, bdump, udump, pfile).  
  

• SGA vs PGA
  
• Background processes
  
• Interfaces with server and disk I/O subsystem. 
  

• Connecting and executing SQL
  
• Using the 'as sysdba' syntax
  
• Overview of SQL Plus DBA commands (startup, etc.) 
  

Creating New Database Users

• Using pre-spawned Oracle connections
  
• Auditing User activity
  
• Identifying System and Object Privileges
  
• Granting and Revoking Privileges
  
• Creating and Modifying Roles
  
• Displaying user security Information from the Data Dictionary 
  

• Describing the relationship between data files, tablespaces and table
  
• Understanding Oracle segments
  
• Creating Tablespaces – using the autoextend option
  
• Changing the Size of Tablespaces – alter database data file command
  
• Defining a TEMP tablespace
  
• Changing the default storage Settings for a tablespace
  
• Review of the storage parameters in DBA views (ASM, ASSM, pctfree, pctused and freelists).
  
• Monitoring Chained rows (fetch continued rows)
  
• Monitoring Insert and Update performance (pctused, APPEND) 
  

• Reason for reorgs – chained rows, imbalanced freelists
  
• Reorganizing Tables using Export and Import
  
• Using CTAS to reorganize data
  
• Index rebuilding
  
• Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 
  

• Reason for reorgs – chained rows, imbalanced freelists
  
• Reorganizing Tables using Export and Import
  
• Using CTAS to reorganize data
  
• Index rebuilding
  
• Backup & Recovery overview (hot & cold Backups, RMAN, block change tracking) 
  

•  OS-level backups
  
•  Hardware-level backup & recovery
  
•  Block-level change tracking
  
•  Disk mirroring
  
• Backup & recovery and RAID level
  
• Oracle-level backups (exp, expdp & RMAN)
  
• Hot vs. Cold backups 
  

• Gain an overview of Oracle E-Business Suite
• Install Oracle E-Business Suite
• Describe Oracle E-Business Suite architecture
• Navigate the Oracle E-Business Suite file system
• Identify key features of the Oracle E-Business Suite database
• Identify key files and their purposes at Oracle apps DBA 11g r12.2.x online training.

• Application Developers.
• Database Administrators.
• System Administrator.
• Java Developers.
• Technical Consultant.
• Functional Implementer.
• Systems Architects.
• Application Server Administrators.

• Oracle Database Administration (DBA) & Linux
• Must have awareness in Concepts of Oracle PL/SQL and D2K.
• Basic knowledge on Java Programming is required.
• Basic knowledge of databases.
• Working knowledge of SQL & RDBMS concepts.
• Working Knowledge on oracle 10g.

Yes, we offer self paced training

We offer three different modes of training. Instructor Led Live Training, Self Paced Training and Corporate Training

Yes we offer discounts for group of 3 plus people.

Yes we are the only company where we work with students and offer flexible timings which fits your schedule

All our instructors are from MNC companies who have real time experience of more than 10 years.

Yes we offer a free demo session with the instructors. The trainer will answer all your queries and share the course agenda.