Oracle DBA Essentials

Training by Kore Infotech Training Centre

On-Site / Training

#06-05,Citimac Building,605A Macpherson Road,Singapore-368240 #06-05,Citimac Building,605A Macpherson Road,Singapore-368240, Tai Seng, Singapore, Singapore 368240

SGD 2,400.00

Inquire Book Now

RESPONSE RATE

Details
Outline
About the Provider

Book Now

Inquire

Details

This course covers everyday job of a DBA for aspiring DBA's who wish to make a career as Database Administrator.

Database administration is one of the most sought after professions and one of the most rewarding. Databases are used by all applications worldwide big and small.

There is a huge demand for good database administrators worldwide. Unfortunately, very few people have the sufficient knowledge, skills and expertise to manage large databases, hence the demand for these professionals is growing every day.

The course requires pre-requisite knowledge of database, SQL and PLSQL basics.

Outline

Module 1: Introduction

Overview of Oracle Grid Architecture

Difference between a cluster and a grid

Responsibilities of Database Administrators

Module 2: Managing Tablespaces and Datafiles

Creating New Tablespaces

Decreasing the size of a tablespace

Coalescing Tablespaces & Taking

tablespaces Offline or Online

Making a Tablespace Read only

Renaming & Dropping Tablespaces

Temporary Tablespace

Diagnosing and Repairing Locally

Managed Tablespace Problems

Transporting Tablespaces

Viewing Information about Tablespaces and Datafiles

Relocating or Renaming Datafiles

Module 3: Managing REDO LOGFILES

Adding a New Redo Logfile Group

Adding & Dropping Members from an existing group

Dropping Logfile Group

Resizing Logfiles

Renaming or Relocating Logfiles

Clearing REDO LOGFILES

Viewing Information About Logfiles

Module 4: Managing Control Files

Multiplexing Control File

Changing the Name of a Database

Creating A New Control File

Cloning an Oracle Database

Module 5: Managing the UNDO TABLESPACE

Switching to Automatic Management of Undo Space

Calculating the Space Requirements For Undo Retention

Altering UNDO Tablespace

Dropping an Undo Tablespace

Switching Undo Tablespaces

Viewing Information about Undo Tablespace

Module 6: Import

Invoking Export and Import

Using Import Utility

Module 7: DATA PUMP Utility

Using Data Pump Export Utility

Exporting Individual Tables using

Data Pump Export

Excluding and Including Objects during Export

Module 8: Flash Back Features

Flashback Query

Enabling Flash Back Database

Module 9: BACKUP AND RECOVERY

Opening the Database in Archivelog Mode

Bringing the Database again in NoArchiveLog mode

Taking Offline (COLD) Backups

Taking Online (HOT) Backups

Recovering from the Loss of a Datafile

Reviews

Be the first to write a review about this course.

Write a Review

Kore InfoTech was born in 2004 to provide value added services to its clients in Development of Websites and Software and IT Training space. We focus on delivering customised, flexible and cost effective services accross all our business domains.

Today we are a strong enterprise delivering IT Services in the below key areas :

a) Corporate Training b) Training For Individuals

c) Online Marketing Solutions (SEM, SEO, Adwords Services)

d) Design and Development of Websites , Mobile Websites and Customized Software

View Complete Profile

Customer Relationship Management Computer Aided Design (CAD) / Drafting Office Application & Computer System