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