Smartboard for CIS50 - Oracle and SQL

Category Information
Smart Board Notes Fall 2017 (audio under audio) Best viewed with accompanying audio.
Intro to Oracle (9/5/17) Accompanying audio
Continuing SQL (9/7/17) Accompanying audio
Maintain and functions SQL (9/12/17) Accompanying audio
Functions and groups (9/14/17) Accompanying audio
Intro relational databases (9/19/17) Accompanying audio
Quiz and databases (9/21/17) Accompanying audio
Databases and subqueries (9/26/17) Accompanying audio
Subqueries inclass (9/28/17) Accompanying audio
Variables and maintenance (10/3/17) Accompanying audio
Views and reports (10/5/17) Accompanying audio
Subquery quiz and intro indexes/constraints (10/12/17) Accompanying audio
Keys, indexes/constraints (10/17/17) Accompanying audio
Finishing up SQL (10/24/17) Accompanying audio
Intro PL/SQL and IF (10/26/17) Accompanying audio
Loops and intro cursors (10/31/17) Accompanying audio
Cursors (example of 2 cursors)(11/2/17) Accompanying audio
Cursors continued (11/7/17) Accompanying audio
Cursors selects (11/9/17) Accompanying audio
Exceptions and things skipped (11/16/17) Accompanying audio
Intro to procedures (11/21/17) Accompanying audio
Smart Board Notes Fall 2016 (audio under audio) Best viewed with accompanying audio.
Intro to databases (9/6/16) Accompanying audio
Intro to SQL (9/8/16) Accompanying audio
More SQL: conditions, maintenance (9/13/16) Accompanying audio
More SQL: functions (9/15/16) Accompanying audio
Quiz and multiple tables (9/20/16) Accompanying audio
Relationships (9/22/16) Accompanying audio
Joins and subqueries (9/27/16) Accompanying audio
Subqueries examples (9/29/16) Accompanying audio
Practice exercise (10/4/16) Accompanying audio
Variables and maintenance (10/6/16) Accompanying audio
Views and reports (10/13/16) Accompanying audio
Views and reports (10/13/16) Accompanying audio
Constraints and keys (10/18/16) Accompanying audio
More constraints,keys and also views (10/20/16) Accompanying audio
Wrapup SQL, intro PL/SQL (10/25/16) Accompanying audio
PL/SQL if loop etc. (11/1/16) Accompanying audio
PL/SQL data manipulation and intro cursors (11/3/16) Accompanying audio
PL/SQL continuing cursors (11/8/16) Accompanying audio
Working on cursors (11/10/16) Accompanying audio
Nov 15th, there was low attendance so we decided to spend the day debugging problems that students brought up to discuss. THere is no Smartboard but I had the recorder on so I am posting the audio. It is doing last weeks homework.
Cursors and... (11/17/16) Accompanying audio
Cursors, types and exceptions (11/22/16) Accompanying audio
Procedures (11/29/16) Accompanying audio
Procedures, functions, blocks and triggers (12/1/16) Accompanying audio
More triggers (12/6/16) Accompanying audio
Smart Board Notes Fall 2015 (audio under audio) Best viewed with accompanying audio.
Intro to databases (9/8/15) Accompanying audio
Intro to SQL (9/10/15) Accompanying audio
Maintenance and functions (9/15/15) Accompanying audio
Functions cont (9/17/15) Accompanying audio
Linking tables (9/22/15) Accompanying audio
Relating tables (9/24/15) Accompanying audio
Subqueries (9/29/15) Accompanying audio
More Subqueries (10/1/15) Accompanying audio
Input variables (10/6/15) Accompanying audio
Table Maintenance (10/8/15) Accompanying audio
Views and Reports (10/15/15) Accompanying audio
Indexes, keys, constraints (10/20/15) Accompanying audio
Indexes, keys, constraints cont (10/22/15) Accompanying audio
Views, seq and intro PL/SQL (10/27/15) Accompanying audio
If and loops in PL/SQL (11/3/15) Accompanying audio
Data manipulation (11/5/15) Accompanying audio
Cursors (11/10/15) Accompanying audio
Cursors cont (11/12/15) Accompanying audio
Pat McDonough talking about careers & Cursors cont (11/17/15) Accompanying audio
Exceptions, first handout, tables and records (11/19/15) Accompanying audio
Procedures and functions (12/1/15) Accompanying audio
Triggers (12/3/15) Accompanying audio
Smart Board Notes Fall 2014 (audio under audio) Best viewed with accompanying audio.
Intro to databases (9/2/14) Accompanying audio
Create and query (9/4/14) Accompanying audio
Login to Oracle and queries (9/9/14) Accompanying audio
Queries, maintenance, functions (9/11/14) Accompanying audio
Functions and grouping (9/16/14) Accompanying audio
We worked on the Oracle Quiz of week 3 in class so no audio or Smartboard.
Multiple tables (9/23/14) Accompanying audio
Multiple tables and intro subqueries (9/25/14) Accompanying audio
More subqueries and play computer exercise (9/30/14) Accompanying audio
Computer exercise and variables (10/2/14) Accompanying audio
Variables and maintenance (10/7/14) Accompanying audio
Scripts, views and reports (10/9/14) Accompanying audio
Indexes, keys and constraints (10/14/14) Accompanying audio
Thursday, Oct 16th was a short lecture - most of the time was spent with students working on the example.
Indexes, keys and constraints cont (10/16/14) Accompanying audio
Wrapup SQL, intro PL/SQL (10/21/14) Accompanying audio
PL/SQL IF statements (10/23/14) Accompanying audio
PL/SQL loops, seq and intro cursors (10/28/14) Accompanying audio
PL/SQL cursors (10/30/14) Accompanying audio
More cursors (11/4/14) Accompanying audio
Wrapping up cursors (11/6/14) Accompanying audio
Open lab November 13th.
Exceptions and procedures (11/18/14) Accompanying audio
Procedures and functions (11/20/14) Accompanying audio
Triggers (11/25/14) Accompanying audio
PL/SQL cursors examples (12/2/14) Accompanying audio
PL/SQL wrapup (12/4/14) Accompanying audio
Smart Board Notes Fall 2013 (audio under audio) Best viewed with accompanying audio.
Intro to databases (9/3/13)Accompanying audio
Login and intro SQL (9/5/13)Accompanying audio
SQL and Queries (9/10/13)Accompanying audio
Maintenance, intro functions and quiz (9/12/13)Accompanying audio
More functions (9/17/13)Accompanying audio
More functions and multiple tables (9/19/13)Accompanying audio
Relational database (9/24/13)Accompanying audio
Subqueries (9/26/13) Accompany audio
Variables and maintenance (10/1/13)Accompanying audio
Review exercise (10/3/13)Accompanying audio
Views and Reports (10/8/13) Accompany audio
Oct 10th catch up day.
Constraints, keys, indexes (10/17/13) Accompany audio
Constraints, keys, indexes and start PL/SQL (10/22/13) Accompany audio
PL/SQL intro and IF (10/24/13) Accompany audio
PL/SQL Loops (10/29/13) Accompany audio
PL/SQL using seq and intro cursors (10/31/13) Accompany audio
PL/SQL cursors continued (11/5/13) Accompany audio
More PL/SQL cursors continued (11/7/13) Accompany audio
PL/SQL cursors and exceptions (11/12/13) Accompany audio
PL/SQL procedures (11/14/13) Accompany audio
PL/SQL procedures and functions (11/21/13) Accompany audio
PL/SQL triggers (11/26/13) Accompany audio
PL/SQL examples (12/3/13) Accompany audio
More PL/SQL examples (12/5/13) Accompany audio
Smart Board Notes Fall 2012 (audio under audio) Best viewed with accompanying audio.
Intro to Oracle and SQL (9/4/12)Accompanying audio
Login and SQL conditions (9/6/12)Accompanying audio
Maintenance and functions (9/11/12)Accompanying audio
Quiz and functions (9/13/12)Accompanying audio
Relational database (9/18/12)Accompanying audio
Relational database continued (9/20/12)Accompanying audio
Relational database and join (9/25/12)Accompanying audio
Subqueries (9/27/12)Accompanying audio
Input variables and maintenance (10/2/12)Accompanying audio
Views and reports (10/11/12)Accompanying audio
Constraints and indexes (10/16/12)Accompanying audio
Constraints and indexes cont (10/18/12)Accompanying audio
Intro to PL/SQL (10/23/12)Accompanying audio
Decisions in PL/SQL (10/25/12)Accompanying audio
Loops in PL/SQL (11/1/12)Accompanying audio
Intro to cursors in PL/SQL (11/6/12)Accompanying audio
More cursors in PL/SQL (11/8/12)Accompanying audio
Continuing cursors in PL/SQL (11/13/12)Accompanying audio
Wrapup cursors and Exceptions (11/15/12)Accompanying audio
Inner code, data and intro procedures (11/20/12)Accompanying audio
Record, type, procedures, functions (11/27/12)Accompanying audio
Triggers, procedures, functions (11/29/12)Accompanying audio
Smart Board Notes Fall 2011 (audio under audio) Best viewed with accompanying audio. The PDF shows better that the PowerPoints.
Intro to Relational Databases (9/6/11) Accompanying audio
Log in to Oracle (9/8/11) Accompanying audio
Beginning Oracle (9/13/11) Accompanying audio
Oracle queries and maintenance (9/15/11) Accompanying audio
Oracle functions (9/20/11) Accompanying audio
Functions and Quiz (9/22/11) Accompanying audio
Multiple tables (9/27/11) Accompanying audio
Multiple tables cont (9/29/11) Accompanying audio
Subqueries (10/4/11)Accompanying audio
Variables (10/13/11)Accompanying audio
Maintain, scripts, view (10/18/11)Accompanying audio
Reports and intro constraints (10/20/11)Accompanying audio
Constraints (10/25/11)Accompanying audio
Sequence annd intro PL/SQL (10/27/11)Accompanying audio
PL/SQL IF statements (11/1/11)Accompanying audio
PL/SQL loop statements (11/3/11)Accompanying audio
Open lab with problem notes (11/8/11)Accompanying audio
Open lab solving odd number problem (11/10/11)Accompanying audio
Intro cursors (11/15/11)Accompanying audio
More cursors (11/17/11)Accompanying audio
More cursors (11/22/11)Accompanying audio
Exceptions and start procedures (11/29/11)Accompanying audio
Cursors and procedures (12/1/11)Accompanying audio
Procedures & functions (12/6/11)Accompanying audio
Triggers (12/8/11)Accompanying audio
Smart Board Notes Fall 2010 (audio under audio) Best viewed with accompanying audio. The PDF shows better that the PowerPoints.
The Smartboard was not working for the first class. These are the notes that we went over:
Intro to Oracle (9/7/10), Installation Notes, Creating a table, Introduction to SQL in Oracle
Intro to Oracle cont. (9/9/10) PDF format Accompanying audio
Intro to Oracle cont. (9/9/10) PowerPoint Accompanying audio
Maintenance and functions (9/14/10) PDF format Accompanying audio
Maintenance and functions(9/14/10) PowerPoint Accompanying audio
Group functions (9/16/10) PDF format Accompanying audio
Group functions(9/16/10) PowerPoint Accompanying audio
Relational database (9/21/10) PDF format Accompanying audio
Relational database (9/21/10) PowerPoint Accompanying audio
Relational database cont (9/23/10) PDF format Accompanying audio
Relational database cont (9/23/10) PowerPoint Accompanying audio
Multiple tables and subqueries (9/28/10) PDF format Accompanying audio
Multiple tables and subqueries (9/28/10) PowerPoint Accompanying audio
Join and subquery review (9/20/10) PDF format Accompanying audio
Join and subquery review (9/30/10) PowerPoint Accompanying audio
Variables and maintenance (10/5/10) in PDF format Accompanying audio.
October 7th canceled.
Views and reports (10/14/10) in PDF format Accompanying audio
Indexes, keys, constraints (10/19/10) in PDF format Accompanying audio
Indexes, keys, constraints cont. (10/21/10) in PDF format Accompanying audio
Sequence etc and intro PL/SQL (10/26/10) in PDF format Accompanying audio
Using Putty and IF and LOOP in PL/SQL (10/28/10) in PDF format Accompanying audio
PL/SQL loops and example (11/2/10) in PDF format Accompanying audio
PL/SQL in class project (11/4/10) in PDF format Accompanying audio
Intro to Cursors (11/9/10) in PDF format Accompanying audio
Cursors (11/16/10) in PDF format Accompanying audio
More Cursors (11/18/10) in PDF format Accompanying audio
Clean up left overs (11/23/10) in PDF format Accompanying audio
Exceptions and procedures (11/30/10) in PDF format Accompanying audio
Procedures and functions (12/2/10) in PDF format Accompanying audio
I was out sick on December 7th.
Triggers (12/92/10) in PDF format Accompanying audio
Smart Board Notes Fall 09 (audio under audio) Best viewed with accompanying audio.
Intro to Oracle (9/8/09) PDF format Accompanying audio
Intro to Oracle (9/8/09) PowerPoint Accompanying audio
Intro to queries (9/10/09) PDF format Accompanying audio
Intro to queries (9/10/09) PowerPoint Accompanying audio
More intro material (9/11/09) PDF format Accompanying audio
More intro material (9/11/09) PowerPoint Accompanying audio
Maintenance and functions (9/15/09) PDF format Accompanying audio
Maintenance and functions (9/15/09) PowerPoint Accompanying audio
Functions (9/17/09) PDF format Accompanying audio
Functions (9/17/09) PowerPoint Accompanying audio
Finish functions (9/18/09) PDF format Accompanying audio
Finish functions (9/18/09) PowerPoint Accompanying audio
Relational databases (9/22/09) PDF format Accompanying audio
Relational databases (9/22/09) PowerPoint Accompanying audio
Relational databases cont (9/24/09) PDF format Accompanying audio
Relational databases cont (9/24/09) PowerPoint Accompanying audio
Relating multiple tables (9/25/09) PDF format Accompanying audio
Relating multiple tables (9/25/09) PowerPoint Accompanying audio
Sept 29th was catch up day and or Quiz day depending on what you needed.
Relating and joins (10/1/09) PDF format Accompanying audio
Relating and joins (10/1/09) PowerPoint Accompanying audio
Joins and subroutines (10/2/09) PDF format Accompanying audio
Joins and subroutines (10/2/09) PowerPoint Accompanying audio
Design and subroutines (10/6/09) PDF format Accompanying audio
Design and subroutines (10/6/09) PowerPoint Accompanying audio
Input variables (10/8/09) PDF format Accompanying audio
Input variables (10/8/09) PowerPoint Accompanying audio
Input variables cont (10/9/09) PDF format Accompanying audio
Input variables cont (10/9/09) PowerPoint Accompanying audio
Maintenance and Views (10/15/09) PDF format Accompanying audio
Maintenance and Views (10/15/09) Powerpoint Accompanying audio
Views and Reports (10/16/09) PDF format Accompanying audio
Views and Reports (10/16/09) Powerpoint Accompanying audio
Keys and indexes (10/20/09) PDF format Accompanying audio
Keys and indexes (10/20/09) PowerPoint Accompanying audio
No notes for 10/22 and 10/23, I was at a conference.
Keys and constraints (10/27/09) PDF format Accompanying audio
Keys and constraints (10/27/09) PowerPoint Accompanying audio
Finishing SQL (10/29/09) PDF format Accompanying audio
Finishing SQL (10/29/09) PowerPoint Accompanying audio
Lab on 10/30.
Carol on putty access (11/3/09) PDF format Accompanying audio
Carol on putty access (11/3/09) PowerPoint Accompanying audio
PL/SQL intro and if (11/5/09) PDF format Accompanying audio
PL/SQL intro and if (11/5/09) PowerPoint Accompanying audio
PL/SQL if and intro loops (11/6/09) PDF format Accompanying audio
PL/SQL if and intro loops (11/6/09) PowerPoint Accompanying audio
PL/SQL loops, intro, nesting (11/10/09) PDF format Accompanying audio
PL/SQL loops, intro, nesting (11/10/09) PowerPoint Accompanying audio
Data manipulation (11/12/09) PDF format Accompanying audio
Data manipulation (11/12/09) PowerPoint Accompanying audio
Cursors (11/13/09) PDF format Accompanying audio
Cursors (11/13/09) PowerPoint Accompanying audio
Cursors with inclass project (11/17/09) PDF format Accompanying audio
Cursors with inclass project (11/17/09) PowerPoint Accompanying audio
Cursors with inclass project cont (11/19/09) PDF format Accompanying audio
Cursors with inclass project cont (11/19/09) PowerPoint Accompanying audio
Cursors with inclass project cont and new project started (11/20/09) PDF format Accompanying audio
Cursors with inclass project cont and new project started (11/20/09) PowerPoint Accompanying audio
Lab on 11/23/09.
Cursors, types and tables (12/1/09) PDF format Accompanying audio
Cursors, types and tables (12/1/09) PowerPoint Accompanying audio
Procedures and cursors (12/3/09 10:00) in PDF Accompanying audio
Procedures and cursors (12/3/09 9:00) in PowerPoint Accompanying audio
I was out sick on 12/4/09.
Exceptions and procedures (12/8/09 10:00) in PDF No accompanying audio
Exceptions and procedures (12/8/09 9:00) in PowerPoint No accompanying audio
Subroutines and functions (12/10/09 10:00) in PDF accompanying audio
Subroutines and functions (12/10/09 9:00) in PowerPoint Accompanying audio
Procedures and functions (12/11/09 10:00) in PDF accompanying audio
Procedures and functions (12/11/09 9:00) in PowerPoint Accompanying audio
Triggers (12/15/09 10:00) in PDF accompanying audio
Triggers (12/15/09 9:00) in PowerPoint Accompanying audio
Smart Board Notes Fall 08 (audio under audio) Best viewed with accompanying audio.
Note that I exported the first class in week one in three ways - I have decided that the pdf and the PowerPoint are most usable, so from now on I will simply export those two formats.
Database Design - normalization (9/2/08) PDF format Accompanying audio
Database Design - normalization (9/2/08) PowerPoint Accompanying audio
Database Design - normalization cont (9/4/08) PDF format Accompanying audio
Database Design - normalization cont (9/4/08) PowerPoint Accompanying audio
Intro SQL and login (9/5/08) PDF format Accompanying audio
Intro SQL and login (9/5/08) PowerPoint Accompanying audio
Oracle queries intro (9/9/08) PDF format Accompanying audio
Oracle queries intro (9/9/08) PowerPoint Accompanying audio
More queries (9/11/08) PDF format Accompanying audio
More queries (9/11/08) PowerPoint Accompanying audio
More queries & maintenance (9/12/08) PDF format Accompanying audio
More queries & maintenance (9/12/08) PowerPoint Accompanying audio
Functions (9/16/08) PDF format Accompanying audio
Functions (9/16/08) PowerPoint Accompanying audio
More Functions (9/18/08) PDF format Accompanying audio
More Functions (9/18/08) PowerPoint Accompanying audio
Group Functions (9/19/08) PDF format Accompanying audio
Group Functions (9/19/08) PowerPoint Accompanying audio
Relational, multiple tables (9/23/08) PDF format Accompanying audio
Relational, multiple tables (9/23/08) PowerPoint Accompanying audio
Relational, multiple tables cont (9/25/08) PDF format Accompanying audio
Relational, multiple tables cont (9/25/08) PowerPoint Accompanying audio
Relational, multiple tables more (9/26/08) PDF format Accompanying audio
Relational, multiple tables more (9/26/08) PowerPoint Accompanying audio
Subqueries intro (9/30/08) PDF format Accompanying audio
Subqueries intro (9/30/08) PowerPoint Accompanying audio
I was out sick on 10/2/08.
Subqueries cont (10/3/08) PDF format Accompanying audio
Subqueries cont (10/3/08) PowerPoint Accompanying audio
Input and variables (10/7/08) PDF format Accompanying audio
Input and variables (10/7/08) PowerPoint Accompanying audio
Maintenance and Views (10/9/08) PDF format Accompanying audio
Maintenance and Views (10/9/08) PowerPoint Accompanying audio
Views and Reports (10/10/08) PDF format Accompanying audio
Views and Reports(10/10/08) PowerPoint Accompanying audio
Indexes intro (10/16/08) PDF format Accompanying audio
Indexes intro(10/16/08) PowerPoint Accompanying audio
I was at a conference on 10/17/08.
Indexes, keys and constraints (10/21/08) PDF format Accompanying audio
Indexes, keys and constraints (10/21/08) PowerPoint Accompanying audio
Finishing SQL (10/23/08) PDF format Accompanying audio
Finishing SQL (10/23/08) PowerPoint Accompanying audio
On 10/24/08 we had a question and answer lab.
Introduction to PL/SQL (10/28/08) PDF format Accompanying audio
Introduction to PL/SQL (10/28/08) PowerPoint Accompanying audio
On 10/30/08 and 10/31/08 I was away an an NSF conference.
Writing PL/SQL in class (11/4/08) PDF format Accompanying audio
Writing PL/SQL in class (11/4/08) PowerPoint Accompanying audio
PL/SQL loops (11/6/08) PDF format Accompanying audio
PL/SQL loops (11/6/08) PowerPoint Accompanying audio
Beginning PL/SQL revisted (11/7/08) PDF format Accompanying audio
Beginning PL/SQL revisited (11/7/08) PowerPoint Accompanying audio
I was at a grant meeting on 11/12/08.
Introduction to cursors (11/13/08) PDF format Accompanying audio
Introduction to cursors (11/13/08) PowerPoint Accompanying audio
Multiple cursors (11/14/08) PDF format Accompanying audio
Multiple cursors (11/14/08) PowerPoint Accompanying audio
Cursor examples & tables (11/18/08) PDF format Accompanying audio
Cursor examples & tables (11/18/08) PowerPoint Accompanying audio
Cursor examples cont (11/20/08) PDF format Accompanying audio
Cursor examples cont(11/20/08) PowerPoint Accompanying audio
Cursor examples & exceptions(11/21/08) PDF format Accompanying audio
Cursor examples & exceptions(11/21/08) PowerPoint Accompanying audio
All day lab on 11/25/08.
Cursor, procedures, functions (12/2/08) PDF format Accompanying audio
Cursor, procedures, functions (12/2/08) PowerPoint Accompanying audio
Cursor, procedures cont (12/4/08) PDF format Accompanying audio
Cursor, procedures cont (12/4/08) PowerPoint Accompanying audio
Functions (12/5/08) PDF format Accompanying audio
Functions (12/5/08) PowerPoint Accompanying audio
All day open lab on 12/9/08.
Triggers (12/11/08) PDF format I was out sick today - this is what I would have covered in class
Triggers (12/11/08) PowerPoint I was out sick today - this is what I would have covered in class
Smart Board Notes Fall 07 (audio under audio) Best viewed with accompanying audio.
Note that I exported the first class in week one in three ways - I have decided that the pdf and the PowerPoint are most usable, so from now on I will simply export those two formats.
Database Design - normalization (9/4/07) PDF format Accompanying audio
Database Design - normalization (9/4/07) PowerPoint Accompanying audio
Database Design - normalization cont. (9/6/07) PDF format Accompanying audio
Database Design - normalization cont. (9/6/07) PowerPoint Accompanying audio
Database Introducing Oracle (9/7/07) PDF format Unfortunately no audio
Database Introducing Oracle (9/7/07) PowerPoint Unfortunately no audio
Oracle and conditions (9/11/07) PDF format Accompanying audio
Oracle and conditionsc(9/11/07) PowerPoint Accompanying audio
Conditions and editing (9/13/07) PDF format Accompanying audio
Conditions and editing (9/13/07) PowerPoint Accompanying audio
Maintenance and functions (9/14/07) PDF format Accompanying audio
Maintenance and functions (9/14/07) PowerPoint Accompanying audio
Group functions (9/18/07) PDF format Accompanying audio
Group functions (9/18/07) PowerPoint Accompanying audio
In class quiz on Sept 20th.
Relating multiple tables (9/21/07) PDF format Accompanying audio
Relating multiple tables (9/21/07) PowerPoint Accompanying audio
Relating multiple tables cont. (9/25/07) PDF format Accompanying audio
Relating multiple tables cont. (9/25/07) PowerPoint Accompanying audio
In class quiz on Sept 27th.
Starting subqueries (9/28/07) PDF format Accompanying audio
Starting subqueries (9/28/07) PowerPoint Accompanying audio
Intro PL/SQL (10/20/07)
Subqueries & joins (10/2/07) PDF format No audio
Subqueries & joins (10/2/07) PowerPoint No audio
Variables (10/11/07) PDF format Accompanying audio
Variables (10/11/07) PowerPoint Accompanying audio
Variables & maintenance (10/12/07) PDF format Accompanying audio
Variables & maintenance (10/12/07) PowerPoint Accompanying audio
Views & reports (10/16/07) PDF format Accompanying audio
Views & reports (10/16/07) PowerPoint Accompanying audio
Indexes, contraints and keys (10/23/07) PDF format Accompanying audio
Indexes, contraints and keys (10/23/07) PowerPoint Accompanying audio
Keys (10/25/07) PDF format Accompanying audio
Keys (10/25/07) PowerPoint Accompanying audio
Intro PL/SQL (10/20/07)
PL/SQL and Ifs (11/1/07) PDF format Accompanying audio
PL/SQL and Ifs (11/1/07) PowerPoint Accompanying audio
PL/SQL and Loops (11/6/07) PDF format Accompanying audio
PL/SQL and Loops (11/6/07) PowerPoint Accompanying audio
Introduction to cursors (11/8/07) PDF format Accompanying audio
Introduction to cursors (11/8/07) PowerPoint Accompanying audio
More intro to cursors (11/9/07) PDF format Accompanying audio
More intro to cursors (11/9/07) PowerPoint Accompanying audio
Types and arrays (11/13/07) PDF format Accompanying audio
Types and arrays (11/13/07) PowerPoint Accompanying audio
Cursors (11/15/07) PDF format Accompanying audio
Cursors (11/15/07) PowerPoint Accompanying audio
Cursors (11/16/07) PDF format Accompanying audio
Cursors (11/16/07) PowerPoint Accompanying audio
Cursors & intro exceptions (11/27/07) PDF format Accompanying audio
Cursors & intro exceptions (11/27/07) PowerPoint Accompanying audio
Cursors, exceptions, procedures (11/30/07) PDF format Accompanying audio
Cursors, exceptions, procedures (11/30/07) PowerPoint Accompanying audio
Procedures & functions (12/6/07) PDF format Accompanying audio
Procedures & functions (12/6/07) PowerPoint Accompanying audio
Procedures, functions, and triggers (12/7/07) PDF format Accompanying audio
Procedures, functions, and triggers (12/7/07) PowerPoint Accompanying audio
Smart Board Notes Fall 06 (audio under audio) Best viewed with accompanying audio.
Note that I exported the first class in week one in three ways - I have decided that the pdf and the PowerPoint are most usable, so from now on I will simply export those two formats.
Notes on relational databases and 3rd normal form (9/5/06) Accompanying audio
Notes on relational databases and 3rd normal form in PDF format (9/5/06) Accompanying audio
Notes on relational databases and 3rd normal form in PowerPoint (9/5/06) Accompanying audio
More notes on database development in PDF format (9/7/06) Accompanying audio
More notes on database development in PowerPoint (9/7/06) Accompanying audio
SQL and WHERE in PDF format (9/12/06) Accompanying audio
SQL and WHERE in PowerPoint (9/12/06) Accompanying audio
SQL functions in PDF format (9/14/06) Accompanying audio
SQL functions in PowerPoint (9/14/06) Accompanying audio
Group functions etc in PDF Format (9/19/06) Accompanying audio
Group functions etc in PowerPoint(9/19/06) Accompanying audio
Relational database notes in PDF Format (9/26/06) Accompanying audio
Relational database notes in PowerPoint (9/26/06) Accompanying audio
Relational database in PDF Format (9/28/06) Accompanying audio
Relational database in PowerPoint (9/28/06) Accompanying audio
Join and Subqueries in PDF Format (9/29/06) Accompanying audio
Join and Subqueries in PowerPoint (9/29/06) Accompanying audio
Subqueries and Input Variables in PDF Format (10/3/06) Accompanying audio
Subqueries and Input Variables in PowerPoint (10/3/06) Accompanying audio
Input variables and maintenance in PDF Format (10/6/06) Accompanying audio
Input variables and maintenance in PowerPoint (10/6/06) Accompanying audio
Maintenance and views in PDF Format (10/12/06) Accompanying audio
Maintenance and views in PowerPoint (10/12/06) Accompanying audio
Reports in PDF Format (10/13/06) In class lab/experiment so audio limited
Reports in PowerPoint (10/13/06) In class lab/experiment so audio limited
Indexes, keys and constraints in PDF Format (10/17/06) Accompanying audio
Indexes, keys and constraints in PowerPoint (10/17/06) Accompanying audio
Indexes, keys and constraints cont. in PDF Format (10/19/06) Accompanying audio
Indexes, keys and constraints cont. in PowerPoint (10/19/06) Accompanying audio
Wrapup of SQL and start of PL/SQL in PDF Format (10/26/06) Accompanying audio
Wrapup of SQL and start of PL/SQL in PowerPoint (10/26/06) Accompanying audio
PL/SQL if and loop in PDF Format (10/27/06) Accompanying audio
PL/SQL if and loop in PowerPoint (10/27/06) Accompanying audio
PL/SQL loop in PDF Format (10/31/06) Accompanying audio
PL/SQL loop in PowerPoint (10/31/06) Accompanying audio
PL/SQL misc and nested loopsin PDF Format (11/2/06) Accompanying audio
PL/SQL misc and nested loops in PowerPoint (11/2/06) Accompanying audio
Records, types, arrays in PDF Format (11/7/06) Accompanying audio
Records, types arrays in PowerPoint (11/7/06) Accompanying audio
Intro cursors in PDF Format (11/9/06) Accompanying audio
Intro cursors in PowerPoint (11/9/06) Accompanying audio
More cursors in PDF Format (11/14/06) Accompanying audio
More cursors in PowerPoint (11/14/06) Accompanying audio
Set of cursor examples in PDF Format (11/16/06) Accompanying audio
Set of cursor examples in PowerPoint (11/16/06) Accompanying audio
Procedures and functions in PDF Format (11/28/06) Accompanying audio
Procedures and functions in PowerPoint (11/28/06) Accompanying audio
Procedures and functions cont in PDF Format (12/1/06) Accompanying audio
Procedures and functions cont in PowerPoint (12/1/06) Accompanying audio
Smart Board Notes (Fall 05) some with audio Notes on relationships
Notes on conditions
Notes on Oracle relationships
Review (10/18/05)
PL/SQL:
PL/SQL IF statements (10/28/05)
Audio accompanying PL/SQL IF statements
PL/SQL IF statements cont (11/1/05)
Audio accompanying PL/SQL IF statements cont
PL/SQL intro, nested and intro loops (11/3/05)
Audio accompanying PL/SQL intro, nested and intro loops (11/3/05)
Loops - while and for (11/4/05)
Audio accompanying PL/SQL Loops - while and for (11/4/05)
Introduction to cursors (11/15/05)
Audio accompanying Introduction to cursors (11/15/05)
More introduction to cursors (11/18/05)
Audio accompanying More introduction to cursors (11/18/05)
Procedures/functions/review of cursors (12/1/05)
Audio accompanying Procedures/functions/review of cursors (12/1/05)
Triggers and MOD11 (12/6/05)
Audio accompanying presentation on triggers and MOD11 (12/6/05)
Smart Board Notes (Fall 04) Class notes on order database
Notes to accompany class examples week 1
Notes on conditions
Notes on functions
Notes on groups
Relationships between donor, drive and donation
Notes on relating and types of joins
Oracle join command
Notes on input variables
Notes on constraints
Notes on primary and foreign keys
Introduction to PL/SQL
Notes on PL/SQL IF statements
Notes on PL/SQL loops
Notes on nested PL/SQL (global/local)
Notes on the table structure in PL/SQL
Introduction to cursors in PL/SQL
Continuation of cursors in PL/SQL
Notes on Oracle procedures
Notes on Oracle functions and procedures
Notes on procedures, functions and triggers
Smart Board Notes (prior to Fall 04) Class notes in answer to questions about decoder and functions
Class notes on grouping (where and having)
Class notes Oracle indexes
Class notes on primary and foreign keys using inventory tables - 1 page of sketches
Notes on PL/SQL loops in Oracle
Recreation of class notes on establishing the property tax relational database
Cursor information to accompany the handout continuing example 1 using cursors
Notes from in class on the cursor examples that use the manager id and the table
Notes from class discussion on Oracle and procedures
Notes from class questions about cursors - review
Notes from class discussion on cursors and triggers

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

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