S5

Oracle Overview Seminar Course Overview

This Oracle Overview Seminar is designed to give delegates an understanding of the concepts of an Oracle database, its capabilities and features.  A product overview will cover the basic features of the Oracle database such as Oracle architecture, database objects, transaction processing and security.  By the end of this seminar delegates will be able to:-

• identify the main features that are available with an Oracle database
• understand the architecture of an Oracle database and to identify the Oracle data types and database structures

Skills Gained

The delegate will gain an understanding of:

• Relational Database concepts
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications
• Oracle Support Services
• Oracle Database Interfaces
• Oracle Database Objects
• Oracle Architecture
• Real Application Clusters
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks
• Tool Sets for Administering and configuring an Oracle database
• Backup and recovery concepts
• Database optimization

Who will the Seminar Benefit?

This Oracle Overview Seminar is designed for decision makers, managers, project managers, system analysts and people with some technical background who want an overview of the capabilities of the Oracle database.

Seminar Objectives

To identify the main features available with an Oracle database.  To understand the architecture of an Oracle database and to identify the Oracle datatypes and database structures.

Note

There is no practical content within this Oracle Overview Seminar.

Requirements

Delegates should be familiar with Information Technology concepts and computer terms and have a basic understanding of Relational Database systems.  This can be obtained on the pre-requisite course.

Pre-Requisite Courses

• Relational Databases & Data Modelling Overview

Follow-On Courses

• Oracle SQL

NOTE: Course technical content is subject to change without notice.

---

Oracle Overview Seminar Training Course

Course Contents - DAY 1

Course Introduction

• Administration and Course Materials
• Course Structure and Agenda
• Delegate and Trainer Introductions

Session 1: DATABASE CONCEPTS

• Database Management Systems
• Relational Database Structures
• The Data Dictionary
• Supported Data Types

Session 2: ORACLE PRODUCT OVERVIEW

• Oracle Product Overview
• Grid Computing
• Oracle Database Server
• Oracle Application Server
• Oracle Applications 11i/R12
• Oracle Support Services

Session 3: DATABASE INTERFACES

• Interacting with an Oracle Database
• Structured Query Language
• Access a Database using SQL*Plus
• Access a Database using SQL Developer
• PL/SQL Objects
• Web Based Management and Development Tools
• Java
• Extensible Markup Language (XML)
• Oracle Programming Interfaces
• Database Utilities
• Oracle Connectivity Products

Session 4: ORACLE DATABASE OBJECTS

• Logical Database Structure
• Tablespaces and Datafiles
• Tables
• Views
• Indexes
• Sequences

Session 5: ORACLE DATABASE 10G AND 11G ARCHITECTURE

• Oracle Architecture
• Oracle Instance
• Memory Structures
• Parameter Initialization Files
• Oracle Background Processes
• Server and Client Processes
• The Oracle Database

Session 6: HIGH AVAILIBILITY

• Real Application Clustering
• Data Guard and Standby Databases
• Automatic Storage Management
• Flashback
• Data Recovery Advisor
• Proactive Health Checks

Session 7: DATABASE SECURITY

• Users and Schemas
• Privileges and Roles
• Synonyms and Links
• Password Management
• Auditing
• Virtual Private Databases
• Oracle Label Security
• Database Resource Manager
• Fined Grained Auditing
• Transparent Tablespace Encryption

Session 8: ADMINISTERING AND CONFIGURING A DATABASE

• Administrative Tools available to a DBA
• Using Oracle Enterprise Manager to manage a database
• Create a Database with DBCA
• Backup and Recovery Concepts
• Database Templates
• Overview of Backup, Restore and Recover
• Tuning Information Sources