UrbanPro
true

Oracle DBA 11g

LIVE
Ongoing

Course offered by Tanya Diwan

0 review
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

About the Trainer

Avg Rating

0 Reviews

0 Students

2 Courses

Having Experience of 15 + Years in same field.

Tutor has not setup batch timings yet. Book a Demo to talk to the Tutor.

Different batches available for this Course

No Reviews yet!

Reply to 's review

Enter your reply*

1500/1500

Please enter your reply

Your reply should contain a minimum of 10 characters

Your reply has been successfully submitted.

Certified

The Certified badge indicates that the Tutor has received good amount of positive feedback from Students.

Different batches available for this Course

tickYou have successfully registered

Oracle DBA 11g by Tanya Diwan

Ravindra Diwan picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Select One

Register Now

Do you want to Register for this Free class?

Yes, Register No, not right now

Tell us a little more about yourself

Oracle DBA 11g by Tanya Diwan

Ravindra Diwan picture
LIVE

Class
starts in

01

Hour

01

Min

01

Sec

Please enter Student name

Please enter your email address.

Please enter phone number.

Verify Your Mobile Number

Please verify your Mobile Number to book this free class.

Update

Please enter 10 digit phone number.

Please enter your phone number.

Please Enter a valid Mobile Number

This number is already in use.

Resend

Please enter OTP.

Or, give a missed call and get your number verified

080-66-0844-42

This website uses cookies

We use cookies to improve user experience. Choose what cookies you allow us to use. You can read more about our Cookie Policy in our Privacy Policy

Accept All
Decline All

UrbanPro.com is India's largest network of most trusted tutors and institutes. Over 55 lakh students rely on UrbanPro.com, to fulfill their learning requirements across 1,000+ categories. Using UrbanPro.com, parents, and students can compare multiple Tutors and Institutes and choose the one that best suits their requirements. More than 7.5 lakh verified Tutors and Institutes are helping millions of students every day and growing their tutoring business on UrbanPro.com. 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