Oracle 10g DBA Online Training


Oracle 10g DBA Online Training Course Details

Oracle 10g DBA Online Training Course Content

1.Introduction.

  • Identify the oracle product
  • Describe the basic concept of a relational database

2.Installing oracle database 10g software.

  • System requirements.
  • Redhat Linux Installation
  • Install software with the Oracle Universal Installer on Linux Platform

3.Create an oracle database.

  • Oracle Database Architecture
  • Oracle instance architecture
  • Oracle Read Consistency and Concurrency

4.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

5.Database Creation.

  • Manual
  • Database Configuration Assistant(DBCA)

6.Storage Structures.

  • Defining the table spaces and data files
  • Create table spaces
  • Manage table spaces
  • Obtain table space information

7.File Management.

  • Control File Management
  • Redo Log File Management
  • Parameter File Management
  • Obtain table space information

8.Administering users.

  • Create and manage database user accounts
  • Create and manage roles
  • Grant and revoke privileges
  • Control resource usage by using Profiles

9.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

10.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

11.Oracle Backup & Recovery (User Managed).

  • Introduction
  • Design, Testing, Implementation Strategies
  • Offline(cold)/Online(hot) backups
  • Performing Complete Recovery
  • Performing Incomplete Recovery

12.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

13.Cloning.

  • RMAN
  • Manual

14.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

15.High Availability(HA).

  • Database Patch Management Introduction
  • Applying Interim and Patch set Patches
  • Patch History & Documentation

16.Log Miner.

  • Contents
  • Reading / Extracting the Content of Redo Logs (Online/archived) for recovery or auditing purpose

17.Flashback.

  • Introduction
  • Configuration
  • Flashback Query/Table/Drop/Database
  • Flashback Version Query
  • Creating Restore Points

18.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

19.Data Guard.

  • Introduction
  • Architecture
  • Configuring Standby database
  • Performing Switch Over and Fail Over
  • Monitoring & Troubleshooting

20.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

21.Oracle Grid Control.

  • Introduction
  • Architecture
  • Installation & Configuration
  • Managing the multiple database nodes using OEM grid control