Oracle 9i

Computer Training Center - South Bend
South Bend, Indiana, United States

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

Course Description:

'' This course introduces students to the world of the Oracle® professional.

Overview: You will learn what Oracle is, how companies use it, and the roles and responsibilities of the individuals that create and manage Oracle systems. You will also learn about the development life cycle, and the activities that take place during each phase. In addition, you will learn to create a basic data model, and how to implement that model as a fully functioning Oracle database. Finally, you will learn about the basics of database storage and the overall architecture of the Oracle Relational Database Management System (RDBMS).

Topics covered include:
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
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 (DML)
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
Removing Oracle
Removing Oracle Databases and SoftwareTopic
Prerequisites: To ensure your success, we recommend you first take the following course or have equivalent knowledge:

�Introduction to Programming

...''

Phone:574.287.1053

School Address:

St. Joseph: 2364 S. Cleveland Ave | St Joseph, MI 49085 | 269.983.3903

South Bend: 2750 Foundation Drive| South Bend, IN 46628 | 574.287.1053


Jobs & Resumes: South Bend
Houses & Roommates: South Bend

InDesign CS - Level II
PageMaker 7.0
Microsoft Publisher 2003
QuarkXPress 6
Lotus Approach ME 9.5
Lotus Notes 6.0 - Database Features
Access 2007
Oracle 10g - Introduction
Relational Database
SQL Fundamentals
Oracle 8i - SQL, PL/SQL, and SQL*Plus
Illustrator CS
PageMill 3.0
Photoshop CS
CorelDRAW
ColdFusion MX
HTML
Paint Shop Pro 7.0
Javascript

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.
 

Facts: We provide free training course catalog service since 2003, in English and Chinese. Tens of thousands of visitors search our database from our portal and partners' websites each day.