Oracle Overview Seminar

1 day @ £395.00  
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

Follow-On Courses


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 7: 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

Pre-Requisite Courses

Follow-On Courses



       Home     Let Us Call You     Enquiry     Make Booking     Top

Make A Booking



Oracle User Group - Membership Benefits

Oracle User Group - Membership Benefits

 

MOD Career Transition

Ministry Of Defense - Career Transition Partnership

 

We have created our website to the following W3C standards, this helps makes our pages easier to use for you.

Valid HTML 4.01 Transitional

Valid CSS!

If you find a non-compliant page on our site, please let us know and we will endeavour to fix it immediately.
 

Publicly Scheduled
Training Locations
London centre:
6 Long Lane
Barbican
London
EC1A 9HF
UK

telephone:
+44 (0)20 7600 6116
Manchester centre:
MWB Manchester
Pall Mall Court
61-67 King Street
Manchester
M2 4PD
UK
Birmingham centre:
MWB Birmingham
43 Temple Row
Birmingham
B2 5LS
UK
Bristol centre:
Woodhouse Manor
Fern Hill
Almondsbury
Bristol
BS32 4LX
UK
Leeds centre:
c/o Blue Chip Training Solutions
11 New Princess Street
Leeds
LS11 9BA
UK
Edinburgh centre:
16 St Mary's Street
Edinburgh
Scotland
B3 2HJ
UK
Please contact our London office for all enquiries.

telephone:
+44 (0)20 7600 6116

or email:

info@
stayahead.com