Oracle DBA Training

Oracle DBA Training in Bangalore

DSMINFOTECH is a software training institute located in Bangalore that offers training in Oracle Database Administration (DBA). The training covers the basics of Oracle DBA, as well as advanced topics, to help students become proficient in managing and maintaining Oracle databases.

Some of the topics covered in the Oracle DBA course at DSMINFOTECH include:

  1. Introduction to Oracle databases
  2. Overview of Oracle architecture
  3. Oracle database components and modules
  4. Oracle database installation and configuration
  5. Oracle database maintenance and management
  6. Oracle database performance tuning and optimization
  7. Oracle database troubleshooting and error handling
  8. Oracle database backup and recovery
  9. Oracle database security and user management
  10. Oracle database best practices and real-world case studies

DSMINFOTECH has experienced trainers who use a combination of lectures, hands-on labs, and real-world case studies to help students understand the concepts and apply them in practical scenarios. The course duration, fees, and other details may vary, so it is best to check with DSMINFOTECH directly for the latest information.

 
 Our Ab Initio training center is well equipped with lab facilities and excellent infrastructure for providing you real time training experience. We also provide certification training programs in Ab Initio 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 team of experts at Dsm Infotech Training Institute, Bangalore have designed our Ab Initio Training course content and syllabus based on students requirements to achieve everyone’s career goal.  Our Ab Initio Training course fee is economical and tailor-made based on training requirement.
 
 We Provide regular training classes(day time classes), weekend training classes, and fast track training classes for Ab Initio Training in our centers located across Bangalore. We also provide Online Training Classes for Ab Initio Training Course.

Get In Touch

Oracle DBA Course Syllabus

 
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
Perl/Tk
  • Creating a Perl/Tk Application
  • GUI Programming Overview
  • Adding Widgets
  • Scrolled Widgets
  • Configuring Widgets
  • Menus
  • More Fun with Menus
  • Using FileSelect
Perl/Tk Programming
  • Tk::Error and Tk::ErrorDialog
  • Configuring Widgets
  • Geometry Management
  • Geometry Management with grid()
  • The Frame Widget
  • Defining Widget Callbacks
  • Bindings
  • Nonblocking I/O with fileevent()
  • Tags
  • Other Widgets
  • Other Tk Commands
  • Getting Tk
  • Extending Perl with C/C++
Extending the Perl Interpreter
  • Overview of Perl5 XSUBs
  • Get Started with h2xs
  • Set up the Perl Wrapper Class
  • Write the XS Code
  • The XS File
  • Write Some Test Code
  • What Do You Want?
  • Returning Values on the Stack
  • A Walk Through an XSUB
  • Arguments to XSUBs
  • Other h2xs Options
  • Embedding the Perl Interpreter
  • Why Embed Perl?
  • Embedding Perl in a C Program