loading......

coming soon

Coming Soon

We are in process of building the inventory of good professionals in this category

Got it!

Where do you need ?

location

Please select a Location.

Enquire

Submit your enquiry for Oracle DBA 11g

Please enter valid question or comment

Please enter your name.

Please enter valid email

Please enter valid Phone Number

Please enter the Pin Code.

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 support@urbanpro.com 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 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

Share

course photo

Oracle DBA 11g

South Extn., Delhi

No Reviews Yet
0 Interested

About the Course


Introduction
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.
Manual
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).
Introduction
Design, Testing, Implementation Strategies
Offline(cold)/Online(hot) backups
Performing Complete Recovery
Performing Incomplete Recovery
Oracle Backup & Recovery (System Managed: RMAN).
Introduction
RMAN Architecture
Configuration
Setting up Catalog
Online/Offline Backup using RMAN
Backups Options
Incremental Backups,
Scripts,
Complete Recovery
Incomplete Recovery
Table Space Point in Time Recovery (TSPITR)
Disaster Recovery
Recovery of Corrupted DB-Blocks
Cloning.
RMAN
Manual
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.
Contents
Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose
Flashback.
Introduction
Configuration
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.
Introduction
Architecture
Configuring Standby database
Performing Switch Over and Fail Over
Monitoring & Troubleshooting
Oracle Performance Tuning.
Introduction
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.
Introduction
Architecture
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.

Pre-requisites

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
Reviews
There are no Reviews yet. Be the First to Review
Questions and Comments

Thousands of experts Tutors, Trainers & other Professionals are available to answer your questions

Comment ?

Questions Guidelines

  • Start your question with simple statements like "what", "when", "where", or "how".
  • Ensure your question or answer is not offensive or insensitive - it may be voted down or banned.
  • Please provide as much detail as possible as this will allow our members to better understand and respond to your question.
  • Take some time to categorize your question. This will greatly help other users find the question.


You can add upto 6 Images

Ask


There are no Reviews yet. Be the First to Review

Date and Time

Not decided yet.

About the Trainer


Having Experience of 15 + Years in same field.
Seats Left-

Students Interested 0

Course Id: 13469