Oracle DBA training

Training Provided by Learningdom Introduction to Oracle database, Architecture, Installing an Oracle DB, Building an Oracle DB, Oracle Processes, Managing the Oracle Instance, Manage database storage structures, Manage Redo and undo, Administer User security, Manage Schema objects, Configure Oracle Network environment, Managing Data and concurrency, Oracle database security, Proactive maintenance, Performance management using Advisors, Backup and Recovery concepts, Backup database, Recover database, Perform flashback, Move data, Automatic Storage Management (ASM) TOPICS NOT COVERED IN CERTIFICATION BUT USEFUL TO KNOW FOR A DBA Partitioned table and Indexes, Managing Views, Sequence & Synonym, Managing control files, Managing Archived redo logs, Manage Space for schema objects, Overview of Real Application Clusters (RAC)

Oracle DBA training Topics:
Class I: Introduction

Lesson 1: Introduction to Oracle database

What is a Oracle database

Oracle Instance and Database

Common DBA tasks

Identifying the Oracle Database Software Release

Tools for Administering the database

Class II : Installing Oracle

Lesson1: Installation of Oracle Software on Unix/ Linux

Overview

Pre Installation Requirements

Installing Oracle

Post Installation tasks

Lesson 2: Installation of Oracle Software on Windows

Overview

Pre Installation Requirements

Installing Oracle

Post Installation tasks

Class III : Architecture

Lesson 1: SGA & Server Architecture

Client, Server

SGA

Dedicated server and shared server

Lesson 2: Oracle Processes

Background processes

Utility processes

Server process

Lesson 3: Oracle Files (Part I)

Parameter files

Trace Files

Alert files

Data files

Temp files

Lesson 4: Oracle Files (Part II)

Control files

Redo log files

Password files

Change Tracking file

Flashback Log file

Data pump files

Class IV: Managing the Oracle Database

Lesson 1: Building an Oracle Database

Optimal Flexible Architecture

Oracle managed files

Use DBCA to build a database

Use DBCA to delete a database

Managing templates with DBCA

Manually building a database

Lesson 2: Managing the Oracle Instance

Using Enterprise Manager

Use SQLPlus and iSQLPLus

Start the database- various options

Shut down the database various options

Dynamic performance views

Lesson 3: Configure Oracle Network environment

Oracle Net Listener configuration

Naming methods

Tools for configuring the network

Create additional listeners and net service aliases.

Class V: Manage database storage structures

Lesson 1: Manage tablespaces

Datablocks, extents and segments

Tablespaces Create, manage

Space management in tablespace

Obtain tablespace information

Lesson 2: Manage Redo and undo

Define redo and undo

Monitor and administer undo

Configure UNDO retention

Configure redo log group and files

Archive log files

Lesson 3: Manage Schema objects (Part I)

Tables

Views

Sequences

Lesson 4: Managing Schema Objects (Part II)

Indexes

Synonym

Class VI: Application Development

Lesson 1: Administer User security

Create and administer user accounts

Create and manage roles

Create and manage privileges

Create and administer profiles

Lesson 2: Managing Data and concurrency

Transactions

Levels of locking

Lock conflicts and deadlock

Triggers and triggering events

Lesson 3: Oracle database security

Implement principle of least privilege

Audit database activity

Fine grained auditing

Class VII: Backup and Recovery

Lesson 1: Concepts

Types of failure

Checkpoint

Instance recovery

Configure a database for recoverability

ARCHIVE LOG mode

Lesson 2: Backup database

Consistent backup

Inconsistent backup

Incremental backup

Automate backup

Backup control file to trace

Lesson 3: Recover database

Recover a control file

Recover a redo log file

Recover a data file (system critical and non system critical)

Lesson 4: Perform flashback

What is flashback

Flashback table

Flashback DROP

Flashback Query

Flashback logs and Flashback database

Class VIII: Performance Tuning

Lesson 1: Proactive maintenance

Gather optimizer statistics

Manage AWR

Set ADDM

Warning and critical thresholds

React to performance issues

Lesson 2: Performance management using Advisors

SQL Tuning advisor

SQL access advisor

Memory advisor

Class IX: Oracle Utilities

Lesson 1: Move data

Data Pump

SQL Loader

External table

Class X: Automatic Storage Management (ASM)

Lesson 1: Using ASM

Overview of ASM

Administer ASM instance

Administer ASM diskgroups

Using ASM in database

TOPICS NOT COVERED IN CERTIFICATION BUT USEFUL TO KNOW FOR A DBA

Class XI: Schema Objects (Part III)

Lesson 1: Partitioned table and Indexes

Partitioning methods

Creating Partitioned tables

Creating Partitioned Indexes

Maintaining Partitioned tables

Lesson 2: Managing Views, Sequence & Synonym

Managing Views

Managing Sequence

Managing Synonyms

Lesson 3: Manage Space for schema objects

Manage tablespace alert

Manage storage parameters

Manage resumable space allocation

Reclaiming waste space

Class XII: Database Files (Part III)

Lesson 1: Managing control files

Guidelines for control files

Creating control files

Trouble shooting control file problems

Lesson 2: Managing Archived redo logs

Choosing between ARCHIVELOG and NOARCHIVELOG

Control Archiving

Manage Archive destination failures

Class XIII: Real Application Clusters (RAC)

Lesson 1: Overview of RAC

What is RAC?

Differences in administering RAC and Single instance Database

Starting and stopping RAC database and Instances

About The Training Provider: Learningdom

More Training from Learningdom

• Online QA Training
• QA training