Learn From Experts...

Not just learning, it’s about Expertise

ORACLE Database

Oracle Database Administration & Management

Why Lightning Minds?

Experienced Trainers Never miss a class, All classes are recorded. Access to Training forums even after training.

COURSE OUTLINE

This brochure provides a high level description of the Oracle – Database Administration course offered by Lightning Minds Inc. This course is specially designed to address the needs of IT consultant who would like to pursue their career as Oracle Database Administrator. The goal of this course is to cover the Oracle architecture and internal mechanisms such that the student is able to perform basic DBA tasks such as database creation, startup and shutdown, and database management. The course also covers Oracle networking basics and the Oracle utility programs.

ORACLE – Database Administrator

TARGET PROFESSIONAL ACCREDITATIONS * Oracle Certified DBA (10g, 11g)

TARGET JOB ROLES *

Oracle SQL, PL/SQL Unix, Shell scripting

PREREQUISITES

OFFERINGS

Independent Consultants IT Consulting Companies

FORMAT

Classroom Online (Web & Audio Conference) On-Site at your facility **

For any questions regarding the training, fees structure or any other career opportunities, contact

Chari Kambaratraining@lightningminds.com(919) 247-7890

COURSE CONTENT

MODULE 1: ORACLE ARCHITECTURE, ADMINISTRATION & MANAGEMENT

Overview: This module starts with basic concepts of database, data modeling and walks you through the fundamentals of Oracle database.

CONTENTS ORACLE DATABASE ARCHITECTURE

Physical Structure of the Database

Logical Structure of the Database

Memory Structures

Background Processes

ORACLE DATABASE ADMINISTRATION

Oracle Installation

Database Startup Modes

Database Shutdown Modes

Setting Parameters in the Parameter file

Creating a Database

Creating Data Dictionary Views

Creating Standard Packages

Suspending and Quiescing the Database

Parameter file Management

Creating Server Parameter file using Text Parameter file

Managing Server Parameter file

Creating Text Parameter file using Server Parameter file

Tablespace Management

Creating and Managing Dictionary Managed Tablespaces

Creating and Managing Locally Managed Tablespaces

Creating and Managing Default Temporary Tablespaces

Creating Tablespaces with Non Default Block Size

Tablespace Management

Creating and Managing Dictionary Managed Tablespaces

Creating and Managing Locally Managed Tablespaces

Creating and Managing Default Temporary Tablespaces

Creating Tablespaces with Non Default Block Size

Creating and Maintaining the Data Files

Creating and Maintaining OMF Datafiles

Creating and Maintaining the Control Files

Creating and Maintaining Multiple OMF Control files

Creating and Maintaining the Redo Log Files

Creating and Maintaining Multiple OMF Redolog files

Managing Archived Redo Log Files

Log Miner

ORACLE DATABASE MANAGEMENT

Creating Rollback Segments

Managing Rollback Segments

Sizing Rollback Segments

Creating and Managing Undo Tablespaces

Storage Structures and Relationships

Automatic Segment Space Management

Table Management

Creating and Managing Normal Tables

Sizing Tables

Partitioned Table Management

Creating and Managing Range Partitioned Table

Creating and Managing Hash Partitioned Table

Creating and Managing Composite Partitioned Table

Creating and Managing List Partitioned Table

Creating and Managing Index-Organized Tables

Creating and Managing Clusters Tables

Creating and Managing Temporary Tables

Redefining Tables Online

Flashback Queries

Resumable Operations

Index Management

Creating and Managing B*Tree Indexes

Creating and Managing Bitmap Indexes

Creating and Managing Partition Indexes

Creating and Managing Function Based Indexes

Index Monitoring

Creating and Managing Users

Creating and Managing Roles

Creating and Managing Profiles

User Authentication

Passwordfile Management

Database Auditing

Globalization Parameter

Loading Methods

SQL*Loader

Direct Load

Hands On Project on Database Normalization Hands on Oracle Installation, Users and Roles management Exercise on SQL*PLUS Commands Project using TOAD Data Modeler

Tools TOAD Data Modeler, SQL*PLUS, ISQL*PLUS

MODULE 2: ORACLE NETWORK ADMINISTRATION

Overview: This module covers topics of Oracle Network Administration and Security.

Contents ORACLE NETWORK ADMINISTRATION

Oracle Networking Overview

Oracle Net Stack Communication Architecture

Oracle Net Services Server Side Configuration

Oracle Net Services Client Side Configuration

Usage and Configuration of Oracle Names Method

Usage and Configuration of the Shared Servers

Usage and Configuration of Connection Manager

Troubleshoot the Network Environment

Security in Network Environment

Hands On Comprehensive exercise on SQL & Database Objects Security setup, Password recovery, configuration.

Tools SQLPLUS, SQLTRACE, TKPROF, Oracle SQL Developer, TOAD

MODULE 3: ORACLE BACKUP & RECOVERY

Overview: This module covers deeper into Oracle Backup and Recovery.

Contents ORACLE BACKUP & RECOVERY

Backup and Recovery Considerations

Logical Backup using Export Utility

Logical Recovery using Import Utility

Transportable Tablespaces

Physical Backup without Recovery Manager

Cold or Offline Backup

Hot or Online Backup

Types of Failures and Troubleshooting

Physical Recovery without Recovery Manager

Complete Recovery with Archiving

Incomplete Recovery with Archiving

ORACLE RECOVERY MANAGER (RMAN)

Oracle Recovery Manager Overview

Creating and Maintaining Recovery Catalog

Recovery Manager Commands

Physical Backup using Oracle

Recovery Manager

Restoring and Recovering using Oracle Recovery Manager

Hands On Hands on Backup and Recovery. Hands on with Different modes of Backup and Recovery.

Tools Oracle SQL Developer, TOAD, SQL*Loader

MODULE 4: ORACLE PERFORMANCE & APPLICATION TUNING

Overview: This module discusses about Oracle Performance Tuning and Advanced SQL and PL/SQL.

Contents ORACLE PERFORMANCE TUNINGS

Database Planning

Oracle Alert Files and Trace Files

Dynamic Performance Views

Oracle Utilities

Tuning Shared Pool

Tuning Database Cache

Tuning Redo Log Buffer

Using the ANALYZE Statement

Using the DBMS_STATS Package

SQL Trace and TKPROF

Using EXPLAIN PLAN

Using Oracle Blocks Efficiently

Optimize Sort Operations

Tuning Rollback Segments

Monitoring and Detecting Lock Contention

Contention Issues

ORACLE APPLICATION TUNING Resource Manager

Resource Manager Overview

Configuring Resource Manager

UNIX Tools or Commands

Dbverify

Hands On Hands on with Advanced sql and pl/sql topics.Tuning the Oracle Database.