Home Semantic Web Semantic Web Methodology Cloud Computing Relational Database Design Introduction to ORACLE Cyber Security ORACLE Performance and Tuning Why Intervise? Contact

Introduction to ORACLE

Course Description This ORACLE Server based course provides the participant with knowledge to create tables and manipulate using the ORACLE Server. Participants create and execute stored procedures, implement business rules through triggers and maintain referential integrity through declarative referential integrity. Participants apply ORACLE object extensions through PL/SQL. Participants apply this knowledge through laboratory exercises. The duration of the course is five days (40 hours).

Student Learning Objectives/Outcomes

Upon completion of this course the student will:
  • an understanding of the client/server model.
  • an understanding of relational data base terms.
  • in-depth knowledge PL/SQL including packages.
  • in-depth knowledge in the manipulation data through SQL.
  • an understanding of how to create and use stored procedures and functions.
  • a thorough understanding of the DECODE function.
  • an understanding of the forms of referential integrity and the ability to implement referential integrity through declarative means as well as through triggers.
  • the ability to implement business rules through the use of triggers.
  • the ability to handle multi-server transactions.
  • in-depth knowledge of applying object-oriented solutions through ORACLE
  • a complete understanding of how to translate a relational data base design into a fully function data base.
Required Textbooks and Materials
Participants will receive course materials and a laboratory book.
Contact Information:

Scott Streit (301) 596-2550 (sstreit@intervise.com)

Scott Streit is the Chief Technology Officer of Intervise and a professor at Villanova. Mr. Streit performed a variety of functions for ORACLE including methodology development and performance tuning.

Course Pre-requisites, Co-requisites, and/or Other Restrictions

This five-day course is designed for ORACLE Server-based software developers.

Course Content

Transaction Management
Lecture 1 Overview of database processing
Lecture 2 Relational Databases
Lecture 3 ANSI SQL Data Manipulation Language (DML)
Lecture 4 PL/SQL Extensions
Lecture 5 Data Definition Language (DDL)
Lecture 6
Lecture 7 DBA Topics
Lecture 8 Miscellaneous Topics
www.intervise.com    Phone: (240) 599-9300