Oracle DBA

Home / Oracle DBA

Real-time Practical Oriented Training in Bangalore with Guaranteed Placements provider,No.1 Training center in Bangalore . AWS training in bangalore,Devops, Python for freshers with 100% JOB Support,Java Android, IOS training provided by Industrial Experts from Bangalore. Book your Free Demo Now And get Placed in 60 Days

Best Oracle DBA Training in Bangalore

TecMax is one of the leading Oracle DBA Training Institute in Bangalore. Certified experts at TecMax are real-time consultants at multinational companies and have more than 5+ years of experience in Oracle DBA Training. Our Trainers have conducted more than 200 classes and have extensive experience in teaching Oracle DBA in most simple manner for the benefit of sudents.

We have advanced lab facilities for students to practice Oracle DBA course and get hands-on experience in every topics that are covered under Oracle DBA Training. In the presence of Oracle DBA Trainer, students can execute all the techniques that has been explained by the instructor. Course Material for Oracle DBA is specifically designed to cover all the advanced topics and each of the module will have both theory and practical classes. Oracle DBA Batch Timings at TecMax are flexible and students can choose to join the batch as per their requirements. We have a batch starting every week for Oracle DBA for regular students. Weekend batches and fast track batches for Oracle DBA training can be arranged based on the requirement.

All our students will get placement assistance in Oracle DBA after successfully completing the Oracle DBA training from our institute. We are committed to provide high-quality training and provide assistance to get you the right job.

Course Content

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 Tablespace
Types of Tablespace(BIG & SMALL)
Temporary Tablespace
Altering/Renaming a Tablespace
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 Tablespace
Locally Managed Tablespace
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 tablespace 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 Tablespaces

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

PERFORMANCE 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 Tablespaces

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
Compiling the Prog

 

 

Have any Query ?






 

Oracle DBA Reviews

Great place to learn

★★★★★
5 5 1
Great place to learn. Tecmax have many courses.

About us

Tecmax is a No.1 Software Training Institute in Bangalore providing Quality and Affordable Training Services with 100% placement Records, Located Strategically at BTM Layout 1st Stage. 

Contact us

# 12, Outer Ring Rd, Jay Bheema Nagar, 1st Stage, BTM Layout 1, Bengaluru, Karnataka - 560068 | Customer Care - 087224 84848

Phone : +91 8722 414141 | 8722 484848

TECMAX © 2017 - 18 | All Rights Reserved