...

+91 78994 89468 | 78994 89384

Oracle DBA Training in BTM, Marathahalli, Bangalore & Best Oracle DBA Training Institutes in Bangalore

About Oracle DBA Training

Techie Zone is a leader in Providing Oracle DBA Training Courses located in BTM Layout, Bangalore based on real-time scenarios and placement oriented topics. Our Oracle DBA training course covers basic to advanced levels. Our team consists of highly qualified and certified trainers who are working professionals with hands on real time Oracle DBA projects knowledge. This  which will provide you an edge over other training institutes.

We provide certification training programs in Oracle DBA Training. We have successfully trained and provided placement for many of our students in major MNC Companies, after successful completion of the course. We provide placement support for our students. Our Oracle DBA training center is well equipped with lab facilities and excellent infrastructure for providing you real time training experience.

Techie Zone provides regular training classes(day time classes), weekend training classes, and fast track training classes for Oracle DBA Training in our Training Centers located in BTM Layout, Bangalore. Students can Enroll and start attending classes as well as practice sessions in the labs without effecting their regular college or office work. We also provide Online Training Classes for Oracle DBA Training Course.

Our team of experts at Techie Zone Training Institute, Bangalore have designed our Oracle DBA Training course content and syllabus based on students requirements to achieve everyone's career goal.  Our Oracle DBA Training course fee is economical and tailor-made based on training requirement.
 
Contact us today to schedule a free demo and complete course details on Oracle DBA Training Course.


Oracle DBA Training Course Content

Oracle DBA 10g /11g training course content and Syllabus in Bangalore

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



Reviews for Oracle DBA Training Course

No Reviews for this Course Yet.. Be the First to Review?

Interview Questions

No Interview Questions Found..

Quick Contact