Oracle Overview Seminar — A 1-Day Course

 Open Public Course Closed In-House Course

Synopsis

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

Objectives

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

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

Suitable For

This course is intended for:

• This 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.

Prerequisites

Delegates should be familiar with Information Technology concepts and computer terms and have a basic understanding of Relational Database systems. This can be obtained by attending our Relational Databases & Data Modelling Overview course.

Publicly scheduled dates, locations, and prices

Outline Course Contents

Database Concepts

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

Oracle Product Overview

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

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

Oracle Database Objects

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

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

High Availibility

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

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

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