Oracle 9i

ExecuTrain
Alpharetta, Georgia, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' In this course, you will examine the basic Oracle concepts and how they relate to database administrators and developers, identify and apply the techniques of logical database design to design a basic entity-relationship diagram, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, write SQL statements to retrieve and manipulate data, create and execute a simple PL/SQL program, list the purpose and syntax of packages, procedures, triggers, and functions, list the objects in an Oracle database, and examine the overall architecture of the Oracle Relational Database Management System (RDBMS).

Objectives:
After completing this course, you will be able to list the users of Oracle, trace the history of databases, list the phases in the development life cycle for Oracle systems, distinguish between data modeling techniques, create entities, add attributes and relationships, use SQL*Plus, examine the purpose of denormalization, identify the advantages and disadvantages of iSQL*Plus, query with the SELECT statement, work with set operators, subqueries, joins, ANSI SQL: 1999-compliant joins, and grouping functions, work with tables, insert and update data in tables using the MERGE statement, commit and rollback changes to data, control a transaction with savepoints, grant and manage privileges to users. You will also be able to identify variables and constants, describe anonymous blocks, conditional logic flow, and cursors, list the purpose and syntax of packages, procedures, triggers, and functions, list the contents of a datablock, manage datablocks, describe the architecture of Oracle9i, and the overall operation of a Relational Database Management System (RDBMS).
Hardware and Software Required:
Browser Netscape Communicator 4.0
Browser Other: AOL 4.0
Operating System MacOS 8.5
Browser Microsoft Internet Explorer 4.0
Operating System MS-Windows 95

Table of Contents:

Introduction to Database Concepts

Users of Oracle

The Relational Database Model

The Development Life Cycle

Data Modeling and Database Design

Overview of Normalization

Data Modeling

Entities and Attributes

Entities and Their Relationships

Denormalization

Introduction to Structured Query Language

Introduction to SQL*Plus

The SELECT Statement

Other Structured Query Language Statements

Data Manipulation Language

Transaction Control Language (TCL)

Data Definition Language (DDL)

Data Control Language (DCL)

Procedural Language/Structured Query Language

Overview of PL/SQL

Stored Packages, Procedures, and Functions

Triggers

Database Objects

Data Blocks

Database Storage

Oracle and Object-Oriented Methodology

Oracle Architecture

The Oracle Database

The Oracle Instance

Executing SQL Statements

Other Oracle Products and Tools


...''

Phone:1-800-908-7246

School Address:



Jobs & Resumes: Alpharetta
Houses & Roommates: Alpharetta

Creating and Managing Controls with Visual Basic .NET
Creating and Managing Controls with Visual C# .NET
Object-Oriented Programming
MCSD
DHTML
E-Business: Fundamentals of E-Commerce
COM+
HTML
IBM WebSphere Portal
SQL, PL/SQL, and SQL*Plus
Java Programming
J2EE: Web Component Development
Java 2: Using IBM VisualAge to Create Java Applications
Java 2: Advanced Programming
JSP: Basic Website Development
Oracle Database 10g
Perl/CGI
PHP 4

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: In most cases you will get a unique submit code along with your each posting on this website. Please provide it as well as the message title if you want any assistance for editing/removal.