space
Search Courses  in 

Just fill this form to get COURSE FEE details from BEST Training Institutes Instantly !

 

My City

 

I need details for

 

My Name

My Mobile Number

My Email ID

Purpose

Tell us your expectation...

Oracle 10g DBA training course content

 

Oracle 10g DBA Course Content


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
» Managing the multiple database nodes using OEM grid control


Below you can find city wise Oracle 10g DBA Institutes


Oracle 10g DBA training institutes in India

Oracle 10g DBA training institutes in Chennai

Oracle 10g DBA training institutes in Bangalore

Oracle 10g DBA training institutes in Mumbai

Oracle 10g DBA training institutes in Pune

Oracle 10g DBA training institutes in Delhi-NCR

 

27-08-2013 by Training Support

Unix Academy Delhi Training

High Technologies Solutions - Delhi,Noida,Gurgaon

Embedded Technosolutions Mumbai

SHRISTI TECHNOLOGY LABS

GRRAS Institute Ahmedabad Jaipur Pune

Sun Infosystems Surat

Indian Institute of Technocrafts, Kolkata

HITS computer Education chennai

Systems Domain Bangalore

IICT Chrompet - SAP Training in ChennaiPMP Training in India

Dallas Technologies Bangalore

Peridot Systems Chennai

7 Eleven Arthashastra Chennai

RIA Institute of Technology Bangalore

Core Mind Technologies Chennai

vgit kilpauke learning, e-publishing, technical writting courses

HB Services Adyar Training InstituteITBMS chennai Best Training Institute

JITS Training

IIHT Bangalore

Best Oracle PHP Java Training chennaiCareer Innovation Technologies Velachery

IIHT Vadapalani Chennai

Mazenet SolutionAMEKS Infotech Ekkattuthangal, Chennai

Training course fee & Discounts

 

 

   DMCA.com Protection Status