OR110 Introduction to Oracle Relational Databases

OVERVIEW

This course provides an overview of Oracle and a review of relational concepts such as referential integrity, primary keys, foreign keys, locking, and  programming considerations.  Topics will also include Oracle architecture, SQL, SQL*Plus, TOAD and PL/SQL programming. This class is also offered in a generic version without mention of Oracle specifics.

DURATION: 1 DAY

OBJECTIVES

• Briefly explain how the relational model works and how Oracle implements it.
•  Demonstrate the relational model, and how to review an Entity Relationship Diagram (ERD). 
• Name several relational objects (tables, indexes, etc.)  and briefly explain their purpose. 
• Define the use of a dictionary and demonstrate how to reference relational objects. 
• Explain Oracle components and their use (e.g. Forms, Report, Developer 2000). 
• Discuss integrity constraints and use of primary keys, foreign keys and indexes in Oracle. 
• Define the client/server configuration and the Oracle Architecture that supports it. 
• Explain the 3 categories of SQL statements and their use. 
• Demonstrate the execution of dynamic SQL through the interactive facilities TOAD and SQL*PLUS. 
• Define Oracle’s SQL functions and special features, and demonstrated using TOAD. 
• Define the use of PL/SQL programming for procedures, triggers and functions. 
• Explain the basic program structures available (e.g. Loops, IF/THEN, GOTO, Cursors) 
• Demonstrate the execution of a PL/SQL program.

INTENDED AUDIENCE

This course is designed for people who need an overview of relational database concepts and specifically how it relates to Oracle.  This includes project leaders/managers, application developers, operations staff, technical support staff involved in Oracle development or use.

FORMAT/MATERIALS

This course includes a combination of lecture, demonstration and discussion.  Each participant will receive a course manual which will be a useful reference guide after class. There is an optional textbook available.

CONTENT

RELATIONAL CONCEPTS AND FACILITIES

• Relational Database Management Systems
• Relational objects
  • Schema, users
  • Databases
  • Tablespaces
  • Tables
  • Indexes
  • Views
• Relational Structures and logical model
• Relational Issues
  • Data Independence
  • Referential Integrity
  • Data Security  
• Relational Operators
  • Select
  • Project
  • Intersection
  • Difference
  • Union
  • Join