Introduction to Oracle - CIS50

The information at this site is in draft form and is the property of Priscilla Grocer. The information may not be duplicated or distributed without her permission. ©Copyright 2002

Category Information
Information Introduction to CIS50 - methods, expectations etc.
Syllabus for CIS50
Resources Notes and handouts for CIS50
Presentations for CIS50
Bulletin Board for CIS50
Work Login instructions
Weekly Assignments for CIS50
Test information for CIS50
Oracle, SQL, SQL*Plus and PL/SQL resources Links to Oracle,SQL, SQL*Plus, and PL/SQL for CIS50
Reference books for Oracle, SQL, and PL/SQL

Back to the Top



Notes and handouts Link to retrieve
Introduction to Oracle and SQL Introduction to SQL in Oracle
Create a table in SQL
SQL Conditions
Working with SQL
SQL and SQL*Plus More on maintaining an SQL table
SQL functions
More SQL functions
Group SQL functions
Introduction to multiple tables (relational) - joins
Relational database examples
Subqueries
More on subqueries
Using input variables
More on variables with Oracle's SQL*Plus
Table maintenance revisited (again)
Continuation of table maintenance revisited (again)
Exporting an Oracle table
Introduction to views
Introduction to reports
Indexes in Oracle - An introduction
More on Primary and Foreign keys
Notes on key questions
More on views
Information on database objects
Script for input data
Introduction to user security
Copying a Table from DEMO
PL/SQL Introduction to PL/SQL
More examples of inner/outer procedures
Introduction to IF statements
More on PL/SQL IF statements
Introduction to loops
Data manipulation in PL/SQL - introduction
Record and table types
Introduction to Cursors
Example 1 using cursors
Continuing example 1 using cursors
Another set of cursor examples
Introduction to exceptions
Introduction to procedures
Introduction to functions
Internal procedures
More on internal procedures and functions
Still more on procedures and functions
Introduction to triggers
More on triggers
Developer 2000 Introduction to forms using the form wizard
Introduction to reports using the report wizard
More on forms
More on reports
Forms and buttons
Form without the wizard
Information about forms and triggers
Triggers etc.
Introduction to query building
Query builder with 2 related tables
Misc. Normalization definitions

Back to the Top

Powerpoint presentations of material. These presentations can be opened or downloaded for future viewing. Free viewer for PowerPoint
NOTE: Students are reporting more success using Netscape for these presentations.
Apparently the speaker notes are a problem with the downloaded viewer. I will make copies of the speaker notes and store them in word documents.
Presentations Link to retrieve
Introduction to Oracle and SQL Introduction to SQL in Oracle
      Separate speaker notes for Introduction to SQL in Oracle
Create a table in SQL
      Separate speaker notes for Create a table in SQL
SQL Conditions
      Separate speaker notes for SQL Conditions
Working with SQL
      Separate speaker notes for Working with SQL
SQL and SQL*Plus More on maintaining an SQL table
      Separate speaker notes for More on maintaining an SQL table
SQL functions - part 1 character
      Separate speaker notes for SQL functions - part 1 characters
SQL functions - part 2 numeric & date
      Separate speaker notes for SQL functions - part 2 numeric & date
More SQL functions (includes DECODE, ways to edit SQL code and nested functions)
      Separate speaker notes for more SQL functions
Group functions
      Separate speaker notes for group functions
Relational database notes and examples Goes with notes Introduction to multiple tables (relational) - joins - uses donor, donations and drive tables
      Separate speaker notes for relational database presentation
Normalization - information on third normal form
      Separate speaker notes for normalization presentation
Relational database examples - order system
      Separate speaker notes for relational database examples - order system
Student system relational database example
      Separate speaker notes for student system relational database example
Subqueries
      Separate speaker notes for subqueries
More on Subqueries
      Separate speaker notes for More on subqueries
Using Input Variables
      Separate speaker notes for Using Input Variables
More on variables with Oracle's SQL*Plus
      Separate speaker notes for More on variables with Oracle's SQL*Plus
Table maintenance revisited (again)
      Separate speaker notes for Table maintenance revisted (again)
Continuation of table maintenance revisited (again)
      Separate speaker notes for Continuation of table maintenance revisted (again)
Introduction to views
      Separate speaker notes for Introduction to views
Introduction to Reports
      Separate speaker notes for Introduction to reports
Indexes in Oracle - An Introduction
      Separate speaker notes for Indexes in Oracle - An Introduction
More on Primary and Foreign Keys also info from questions
      Separate speaker notes for More on Primary and Foreign Keys etc.
More on views
      Separate speaker notes for More on views
Database Objects in Oracle
      Separate speaker notes for Database Objects in Oracle
PL/SQL Introduction to PL/SQL
      Separate speaker notes for Introduction to PL/SQL
PL/SQL - Using IF statements
      Separate speaker notes for PL/SQL - Using IF statements
More on PL/SQL IF statements
      Separate speaker notes for More on PL/SQL IF statements
Introduction to loops
      Separate speaker notes for Introduction to loops
Data manipulation in PL/SQL - introduction
      Separate speaker notes on Data manipulation in PL/SQL - introduction
PL/SQL User Defined Types - record and table
      Separate speaker notes for PL/SQL User Defined Types - record and table
Covers: Cursors in PL/SQL, cursor example and continuation of first cursor example
      Separate speaker notes for Cursors in PL/SQL, cursor example and continuation of first cursor example
Covers: Another set of cursor exampes
      Separate speaker notes for Another set of cursor examples
Exceptions in PL/SQL
      Separate speaker notes for Exceptions in PL/SQL
Introduction to PL/SQL Procedures
      Separate speaker notes for Introduction to PL/SQL Procedures
Introduction to PL/SQL Functions
      Separate speaker notes for Introduction to PL/SQL Functions
More on Procedures - Internal Procedures
      Separate speaker notes for More on Procedures - Internal Procedures
Introduction to Triggers
      Separate speaker notes for Introduction to Triggers
More and Still More on Procedures and Functions
      Separate speaker notes for More and Still More on Procedures and Functions
More on Triggers
      Separate speaker notes for More on Triggers

Back to the Top

Test Information Link to retrieve
Final Exam - Due May 14th at 4:00 Check weekly assignment list for the final and status sheet

Back to the Top

Resources and sites on the Web Link to retrieve
Helpful links/notes SQL tutorial
This is an article on Oracle and databases
Information on relational databases etc.
Help with Oracle
Oracle/SQL/PL/SQL tutorial
More tutorial and information
PL/SQL User's Guide and reference
Oracle and relational database

Back to the Top

Reference/text books Information
Oracle Oracle8 A Beginners Guide
Abbey and Coe
Oracle Press/Osborne/McGrawHill
ISBN 0-07-882393-5
Osborne Press

A Guide to Oracle
Morrison and Morrison
Course Technologies
ISBN 0-7600-4992-0
Course Technologies
SQL A Guide to SQL featuring Oracle
Pratt
Course Technologies
ISBN 0-7600-4923-8
Course Technologies
PL/SQL Oracle PL/SQL Programming
Scott Urman
Oracle Press/Osborne/McGrawHill
ISBN 0-07-882176-2
Osborne Press

Oracle PL/SQL Programming
Feuerstein and Pribyl
O'Reilly
ISBN 1-56592-335-9


Send e-mail to Mrs. Grocer:

pgrocer@bristol.mass.edu

Back to the Top
Return to home page
Return to previous page