Presentations for CIS50 - Oracle and SQL

Presentations	Link to retrieve
Powerpoint presentations of material. These presentations can be opened or downloaded for future viewing. Free PowerPoint viewer for users Free viewer for PowerPoint Apparently the speaker notes are a problem with the downloaded viewer. I make copies of the speaker notes and store them in word documents.
Notes on relational database design normalization	Normalization - information on third normal form Separate speaker notes for normalization presentation Relational database information - information on 1 to 1, 1 to M, and M to M Separate speaker notes for relational database information
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 Zipped zersion of subqueries. Problem with version online. 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 SQLPlus Separate speaker notes for More on variables with Oracle's SQLPlus 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 Primary and Foreign constraints with a relational database Separate speaker notes to accompany primary and foreign constraints with a relational database 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

Send e-mail to Mrs. Grocer: pgrocer@bristolcc.edu

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