SEED Infotech Ltd - Training & Certifications - Individual Programs - Modular Courses - Oracle 9i Certification- Oracle DBA Track

seedinfotech.com | Home | Contact Us | Enquiry

	Course Schedules
	Courses Offered








	Also See
	Object Centre of Excellence
	Prometric Testing Center

Home > Individual Programs > Modular Courses > Oracle 9i Certification > DBA Track Course

Oracle9i DBA Track

You will be able to...

-	Understand the architecture and processes of the Oracle database
-	Demonstrate the complete set of skills that are required for working independently as an expert DBA
-	Translate your knowledge and skills into increased visibility through the market's most highly valued database benchmark program.
-	Appear for OCA and OCP Certification Exams for DBA Track

Who should attend...

This course is valuable for those who are, or will be, working with Oracle9i. Experience with relational databases and familiarity with basic programming concepts are helpful. Computer Fundamentals and Windows Operating System knowledge is an advantage. Any Programming Language, DBMS like Dbase or FoxPro are preferred and Oracle 9i SQL and PL/SQL

Introduction to Oracle 9i : SQL (Exam – IZ0– 007)

Course Content

Duration : 45 Hrs.

Introduction

Writing Basic SQL SELECT Statements

Restricting and Sorting Data

Single- Row Functions

Displaying Data from Multiple Tables

Aggregating Data Using Group Functions

Subqueries

Producing Readable Output with iSQL *Plus

Manipulating Data

Creating and Managing Tables

Including Constraints

Creating Views

Other Database Objects

Controlling User Access

SQL Workshop

Using SET Operators

Oracle 9i Datetime Functions

Enhancements to the GROUP BY Clause

Advanced Subqueries

Hierarchical Retrival

Oracle 9i Extensions to DML and DDL Statements

Oracle 9i : Database Administration Fundamentals – I (IZ0 – 031)

Course Content

Duration : 45 Hrs.

Oracle Architectural Components

Getting Started with Oracle Server

Managing an Oracle Instance

Creating a Database

Using Data Dictionary and Dynamic Performance Views

Maintaining the Control File

Maintaining Online Redo Log Files

Managing Tablespaces and Data Files

Storage Structure and Relationships

Managing Undo Data

Managing Tables

Managing Indexes

Maintaining Data Integrity

Managing Password Security and Resources

Managing Users

Managing Privileges

Managing Roles

Auditing

Loading Data into a Database

Using Globalisation Support

Oracle 9i : Database Administration Fundamentals – II (IZ0 – 032)

Course Content

Duration : 45 Hrs.

Networking Overview

Oracle Net Architecture

Basic Oracle Net Server Side Configuration

Naming Method Configuration

Usage and Configuration of the Oracle Shared Server

Backup and Recovery Overview

Instance and Media Recovery Structures

Configuring the Database Archiving Mode

Oracle Recovery Manager Overview and Configuration

User – Managed Backups

RMAN Backups

User-Managed Complete Recovery

RMAN Complete Recovery

User – Managed Incomplete Recovery

RMAN Incomplete Recovery

RMAN Maintenance

Recovery Catalog Creation and Maintenance

Export and Import Utilities

Workshop

Oracle 9i Database Performance Tuning (IZ0 – 033)

Course Content

Duration : 45 Hrs.

Overview of Oracle9i Database Performance Tuning

Diagnostic and Tuning Tools

Database Configuration and I/O Issues

Tuning the Shared Pool

Tuning the Buffer Cache

Dynamic Instance Resizing

Sizing Other SGA Structures

Tuning the Oracle Shared Server

Optimizing Sort Options

Using Resource Manager

SQL Statement Tuning

Managing Statistics

Using Oracle Blocks Efficiently

Using Oracle Data Storage Structures Efficiently

Application Tuning

Using Materialised Views

Monitoring and Detecting Lock Contention

Tuning the Operating System

Workshop Overview