Everything Oracle

Full Oracle Training
Real Time Full Audio and Visual Instruction
Learn at your own Pace

Learn to use SQL to create and manage relational databases and learn the new features and functions of PL/SQL. With our courses, you can prepare for Oracle 8i Database Administrator certification.

Press here to Purchase this Product includes all topics outlined
MSRP $179.95 Sale $99.95
Learn all the topics listed below

Oracle Main Page

Oracle Training

Oracle 8i DBA1

Introduction to Oracle: SQL and PL/SQL

Introduction to RDBMS and SQL *Plus

Functions, Tables, and Groups

Advanced SQL, SQL*Plus & Data Dictionary

DML and DDL Statements

Database Objects and Security

Oracle PL/SQL Basic Operations

Oracle 8i: Architecture and Administration

Introducing Procedure Builder

Oracle Server and Database Architecture

Oracle Instance, the Start-up and Shutdown Procedure

Data Dictionary and Database Files

Oracle Storage Architecture

Understanding Storage Allocation

Indexes and Constraints

Managing Oracle Database Security

SQL*Loader, Oracle Export and Import, and NLS

VIEW DEMO To view a demo please visit our website link. To view a demo you need to visit our website and click the link. If you do not have a shockwave player it will ask you to download it. You only need the shockwave player for the online demos only, although they are the same as the product for web purposes we have configured them to play in shockwave. Shockwave is similar to a flash player and can be downloaded free from Macromedia shockwave.com

Oracle 8i PL/SQL - Intro to RDBMS and SQL *Plus

The course aims to familiarize you with the basic concepts of database design. The course also provides a brief overview of relational database model since the Oracle database is based on this model. The course familiarizes you with the use of SQL and SQL *PLUS commands. The course will enable you to construct queries using SELECT statement with clauses, such as, WHERE, ORDER BY, and DISTINCT. You would also be able to retrieve data from a database using arithmetic, logical, comparison, and SQL operators.

Intro to RDBMS and SQL *Plus training covers such topics as:

RDBMS and SQL
Basics of SQL
Controlling Selected Rows
Operators

Oracle 8i PL/SQL - Functions, Tables, and Groups

This course covers the concepts of single row functions that enable the manipulation of data. The course essentially focuses on three single row functions: character functions, number functions, and date functions. The course also covers the concept of conversion that enables the conversion of a value from one datatype to another. The concept of retrieving data from, more than one table by using join statements is also covered. Additionally, the course discusses group functions that operate on sets of rows to give one result. Related Exam: Oracle Exam #1Z0-001: Introduction to Oracle: SQL and PL/SQL.

Functions, Tables, and Groups training covers such topics as:

Single Row Functions
Conversion Functions
Display Data From Multiple Tables
Working With Groups

Oracle 8i PL/SQL - Adv SQL, SQL *Plus & Data Dictionary

In this course, you will learn to create subqueries and queries using SET operators. The course describes the SQL *PLUS file commands and SET commands that are used to customize the SQL *PLUS environment. The course discusses the SQL *Plus format commands and script files and the concept of data dictionary tables and views.

Adv SQL, SQL *Plus & Data Dictionary training covers such topics as:

Subqueries
SQL *Plus Commands
Creating Reports
Data Dictionary

The course addresses the training needs of IT Professionals who use Oracle 8i. This course also addresses the needs of IT professionals who want to become certified under the Oracle8i Certified Database Administrator (DBA) Track.