Signup as a Tutor

As a tutor you can connect with more than a million students and grow your network.

Oracle DBA 11g

No Reviews Yet

South Extn., Delhi

Course ID: 13469

South Extn., Delhi

Students Interested 0 (Seats Left 0)

No Reviews Yet

About the Course

Identify the oracle product
Describe the basic concept of a relational database
Installing oracle database 10g software.
System requirements.
Redhat Linux Installation
Install software with the Oracle Universal Installer on Linux Platform
Create an oracle database.
Oracle Database Architecture
Oracle instance architecture
Oracle Read Consistency and Concurrency
Controlling the database.
Start and stop the agent
Start and stop the enterprise manager database console
Start and stop the listener
Startup and shutdown the database
Database Creation.
Database Configuration Assistant(DBCA)
Storage Structures.
Defining the table spaces and data files
Create table spaces
Manage table spaces
Obtain table space information
File Management.
Control File Management
Redo Log File Management
Parameter File Management
Obtain table space information
Administering users .
Create and manage database user accounts
Create and manage roles
Grant and revoke privileges
Control resource usage by using Profiles
Oracle Net Services.
Understand Oracle Net concepts
Use Oracle Net Manager to create and configure listeners
Use the listener control utility to control the Oracle Net Listener
Use the Oracle Net Manager to configure client and middle-tier connection
Use TNSPING to test Oracle Net connectivity
Managing schema objects.
Create and modify tables
Define constraints
View the attributes of a table
View the contents of a table
Create indexes and views
Oracle Backup & Recovery (User Managed).
Design, Testing, Implementation Strategies
Offline(cold)/Online(hot) backups
Performing Complete Recovery
Performing Incomplete Recovery
Oracle Backup & Recovery (System Managed: RMAN).
RMAN Architecture
Setting up Catalog
Online/Offline Backup using RMAN
Backups Options
Incremental Backups,
Complete Recovery
Incomplete Recovery
Table Space Point in Time Recovery (TSPITR)
Disaster Recovery
Recovery of Corrupted DB-Blocks
Logical Backup & Restore.
Introduction Data pump (expdp, impdp) Utilities
Exporting/Importing Tables
Exporting/Importing Schemas
Exporting/Importing Table space
Exporting/Importing Database
Transportable Table space within & across the database and platforms
High Availability(HA)
Database Patch Management Introduction
Applying Interim and Patch set Patches
Patch History & Documentation
Log Miner.
Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose
Flashback Query/Table/Drop/Database
Flashback Version Query
Creating Restore Points
Automatic Storage Management.
Introduction Data pump (expdp, impdp) Utilities
Exporting/Importing Tables
Exporting/Importing Schemas
Exporting/Importing Table space
Exporting/Importing Database
Transportable Table space within & across the database and platforms
Data Guard.
Configuring Standby database
Performing Switch Over and Fail Over
Monitoring & Troubleshooting
Oracle Performance Tuning.
Proactive Vs Reactive Tuning
Tuning through effective DB Configurations
Health Management/Periodical Checkup
DB Defragmentation
Configuring and using Oracle Parallel Processing Feature
Tuning Memory, Disk I/O
Resource Intensive SQL
Managing the DB Statistics ( for CBO)
Managing the AWR Snapshots
Generating/ Interpreting the AWR Report
Oracle Grid Control.
Installation & Configuration

Topics Covered

Basic to Advance

Who should attend

Any One who is graduate and having interest in Admin as well as in databases.


Having Knowledge of basic SQL Statements.

What you need to bring

Only Note Book and pen. other things will provide by Indohora

Key Takeaways

Installation / database creation / maintenance / backup / recovery / performance tuning

Date and Time

Not decided yet.

About the Trainer

Avg Rating

0 Reviews

0 Students

2 Courses

Having Experience of 15 + Years in same field.


No reviews currently Be the First to Review


Students Interested 0 (Seats Left 0)

Post your requirement and let us connect you with best possible matches for Oracle Database Post your requirement now


Submit your enquiry for Oracle DBA 11g

Please enter valid question or comment

Please select a category

No matching category found.

Please enter your name.

Please enter valid Phone Number

Please enter the Pin Code.

Please check the fields again.

By submitting, you agree to our Terms of use and Privacy Policy

Connect With Indohora Galaxy

You have reached a limit!

We only allow 20 Tutor contacts under a category. Please send us an email at for contacting more Tutors.

You Already have an UrbanPro Account

Please Login to continue

Please Enter valid Email or Phone Number

Please Enter your Password

Please enter the OTP sent to your registered mobile number.

Please Enter valid Password or OTP

Forgot Password? Resend OTP OTP Sent

Sorry, we were not able to find a user with that username and password.

We have sent you an OTP to your register email address and registered number. Please enter OTP as Password to continue

Further Information Received

Thank you for providing more information about your requirement. You will hear back soon from the trainer is India's largest network of most trusted tutors and institutes. Over 25 lakh students rely on, to fulfill their learning requirements across 1,000+ categories. Using, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 6.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on Whether you are looking for a tutor to learn mathematics, a German language trainer to brush up your German language skills or an institute to upgrade your IT skills, we have got the best selection of Tutors and Training Institutes for you. Read more