| |
|
| |
Oracle9i - Introduction Training Class
Course ID: 5877
|
|
| |
|
|
| |
|
|
| |
Oracle9i - Introduction Training Seminar
Overview:
In this course, students learn what Oracle is, how companies use it, and the roles and responsibilities of the individuals that create and manage Oracle systems.
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
Agenda |
|
| |
Lesson 1: Introduction to Database Concepts
Users of Oracle
The Relational Database Model
The Development Life Cycle
|
|
Lesson 2: Data Modeling and Database Design
Overview of Normalization
Data Modeling
Entities and Attributes
Entities and Their Relationships
Denormalization
|
Lesson 3: Introduction to Structured Query Language
Introduction to SQL*Plus
The SELECT Statement
|
Lesson 4: Other Structured Query Language Statements
Data Manipulation Language (DML)
Transaction Control Language (TCL)
Data Definition Language (DDL)
Data Control Language (DCL)
|
Lesson 5: Procedural Language/Structured Query Language
Overview of PL/SQL
Stored Packages, Procedures, and Functions
Triggers
|
|
Lesson 6: Database Objects
Data Blocks
Database Storage
Oracle and Object-oriented Methodology
|
Lesson 7: Oracle Architecture
The Oracle Database
The Oracle Instance
Executing SQL Statements
Other Oracle Products and Tools
| |
|
| |
|
|
|
| |
|
|
| |
Pre-requisites |
|
| |
Programming - Level 1
|
|
|
|
| |
|
|
|
|
| |
|
|
| |
|
|
|
| |
| |
|
|
| |
Oracle9i - Introduction Training Course Dates and Locations
|
|
| |
|
|
| |
Course ID: 5877
| Course Duration: 3 Days
|
|
| |
|
|
| |
Locations: |
|
| |
|
|
| |
|
|
| |
|
|
| |
| Start Date |
Price |
|
Location/Event Details |
Register Online |
Request
More Info |
|
Print/Fax
Register |
|
|
| |
|
|
| |
|
|
|
|
| |
|
|
|
| |
|
|
| |
|
|
| |
Select a market segment to view more courses
|
|
| |
|
|
| |
Or, select a category to view more Information Technology courses
|
|
| |
|
|
| |
 Browse By Category
Browse By Location
Browse New Courses
|
|
| |
|
|
|
| |
| |
|
|
|
|