Oracle DBA Training in India & Best Oracle 10g / 11g DBA Training Institute in India

INTRODUCTION TO ORACLE DBA

• What is DBA ?
• Why a Company needs a DBA?
• Roles & Responsibilities of DBA
• Oracle Architecture
• Physical and Logical Phase of Database
• Types of files(Control file, Redolog file and Datafile)
• Different types of Datafiles
• Instance
• SGA(System Global Area) and Background Process

DATABASE CREATION

• Different Startup Modes
• Different Shutdown Modes
• Types of Database Creation
• Manual Method of Creation

TABLESPACE MANAGEMENT

• Introduction to Table space
• Types of Table space(BIG & SMALL)
• Temporary Table space
• Altering/Renaming a Table space
• Renaming a data file
• Temporary Groups
• Table space Encryption(11g)

STORAGE PARAMETERS

• What are segments?
• What are extents?
• What is Blocks?
• Oracle Blocks
• Estimation of Extents
• Dictionary Managed Table space
• Locally Managed Table space
• Storage Parameters(Initial, Next, Min Extents, Xtents, Pctincrease)

USER MANAGEMENT

• Who are Database Users?
• Why to create a User?
• Creation of Users
• Assigning Privileges
• Creating and granting Roles
• Allocating table space Quotas to Users
• Assigning default table space for the Users
• Setting Profiles for the Users
• Levels of Authentication
• Schema Management(11g)
• Security(11g)

UNDO MANAGEMENT

• What is Undo?
• Why Undo required?
• Pending offline status
• Brief idea about Rollback segments
• Flashback Features
• Flashback Table
• Flashback query
• Flashback Version query

What is spfile?

• Difference between spfile and pfile
• Advantages of spfile
• What is OMF?
• Advantages of OMF
• Files conventions of OMF

NETWORKING IN ORACLE

• Introduction to Oracle Networking
• Network default location
• Editing Network file

Tnsnames.ora

• Introduction to Database Links
• Types of Database Links
• Introduction to Materialized views
• Advantages of Materialized view
• Refresh Modes

REDO-LOG & CONTROLFILE MANAGEMENT

• Introduction to Redo log
• Status of Redo logs
• Multiplexing the Redo log files
• Re-creation of Control file
• Renaming the Database
• Multiplexing the Control file

LOGICAL BACKUP

• What is a logical backup
• Why it is required
• Export/import Utility
• Data Pump
• Difference between Data Pump and Traditional Export/import
• Impdp/expdp
• Transportable Table spaces

PHYSICAL BACKUP

• Introduction to Physical backup
• Types of Physical backup
• Cold & Hot backup
• Recovery scenarios
• RMAN backup
• RMAN Point in time recovery
• RMAN 11g new features

PEFORMANCE TUNING

• What is Performance Tuning?
• Why Tuning required?
• Types of Tuning
• Database Tuning
• Tuning
• SQL Tuning
• Memory Tuning
• Network Tuning
• Partitioning and Indexes
• Partitioning Enhancements
• AWR/ASH/ASMM/ADDM
• RAT(Real Application Testing)(11g)
• SQL Performance Analyses (11g)
• Row chaining and Row migration
• Resemble Table spaces

Oracle DBA training duration in India

Regular Classes( Morning, Day time & Evening)

• Duration : 40 days

Weekend Training Classes( Saturday, Sunday & Holidays)

• Duration : 9 Weeks

Fast Track Training Program( 5+ hours daily)

• Duration : within 15 days

Oracle DBA trainer Profile & Placement

Our Oracle DBA Trainers

• More than 11 Years of experience in Oracle DBA Technologies
• Has worked on 9 realtime Oracle DBA projects
• Working in a MNC company in India
• Trained 200+ Students so far.
• Strong Theoretical & Practical Knowledge
• Oracle certified DBA Professionals

Oracle DBA (oracle 10g 11g dba) placement training in india

• More than 227+ students Trained
• 82% percent Placement Record
• 67 Interviews Organized
• Placement Supported by InterviewDesk.com

Oracle DBA training Locations in India

Our Oracle 10g / 11g DBA Training centers in India

• Mumbai
• Delhi
• Bangalore
• Hyderabad
• Ahmedabad
• Chennai
• Kolkata
• Pune
• Coimbatore
• Noida
• Gurgaon
• Jaipur
• Lucknow
• Kanpur
• Nagpur
• Indore
• Thane
• Bhopal
• Visakhapatnam
• Patna
• Vadodara
• Ghaziabad
• Ludhiana
• Agra
• Nashik
• Faridabad
• Meerut
• Rajkot
• Kalyan-Dombivali
• Vasai-Virar
• Solapur
• Varanasi
• Srinagar
• Aurangabad
• Dhanbad
• Amritsar
• Navi Mumbai
• Allahabad
• Ranchi
• Howrah
• Jabalpur
• Gwalior
• Vijayawada
• Jodhpur
• Madurai
• Raipur
• Kota
• Guwahati
• Chandigarh
• Hubballi
• Bareilly
• Moradabad
• Mysore
• Gurgaon
• Aligarh
• Jalandhar
• Trichy
• Bhubaneswar
• Salem
• Mira-Bhayandar
• Trivandrum
• Bhiwandi
• Saharanpur
• Gorakhpur
• Guntur
• Bikaner
• Amravati
• Jamshedpur
• Bhilai
• Warangal
• Mangalore
• Cuttack
• Firozabad
• Kochi
• Bhavnagar
• Dehradun
• Durgapur
• Asansol
• Nanded
• Kolhapur
• Ajmer
• Gulbarga
• Jamnagar
• Ujjain
• Loni
• Siliguri
• Jhansi
• Ulhasnagar
• Nellore
• Jammu
• Belgaum
• Ambattur
• Tirunelveli
• Malegaon
• Gaya
• Jalgaon
• Udaipur
• Thrissur
• Alwar

Oracle DBA training batch size in India

Regular Batch ( Morning, Day time & Evening)

• Seats Available : 7 (maximum)

Weekend Training Batch( Saturday, Sunday & Holidays)

• Seats Available : 6 (maximum)

Fast Track batch

• Seats Available : 5 (maximum)