| Category |
Information |
|---|
| Smart Board Notes Fall 11 (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 10 (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
|