Category | Information - Frequently you will find that the audio goes well with the Smartboard |
---|---|

Audio/lectures Fall 2018 |
Intro to Oracle (9/4/18) See notes under Smartboard presentation Intro to SQL (9/6/18) See notes under Smartboard presentation Maintain and functions (9/11/18) See notes under Smartboard presentation Groups (9/13/18) See notes under Smartboard presentation We worked on the Oracle quiz today (9/18) in class so there are no notes or audio. Remember that you are playing computer and NOT RUNNING things in Oracle. Multiple tables (9/20/18) See notes under Smartboard presentation Multiple tables cont and intro subqueries (9/25/18) See notes under Smartboard presentation More subqueries (9/27/18) Smartboard crashed so go back to 9/26/17 and 9/28/17 Variables (10/2/18) See notes under Smartboard presentations Maintenance and views (10/4/18) See notes under Smartboard presentations Reports (10/9/18) See notes under Smartboard presentations Keys, constraints, indexes (10/11/18) See notes under Smartboard presentations Wrapup SQL (10/16/18) See notes under Smartboard presentations Intro PL/SQL (10/23/18) See notes under Smartboard presentations Ques reports, loops, data (10/30/18) See notes under Smartboard presentations Finish intro and start cursors (11/1/18) See notes under Smartboard presentations Continuing cursors (11/6/18) See notes under Smartboard presentations More cursors (11/8/18) See notes under Smartboard presentations Cursors and exceptions (11/15/18) See notes under Smartboard presentations Type records/tables and procedures (11/20/18) See notes under Smartboard presentations Procedures and functions (11/27/18) See notes under Smartboard presentations Triggers and arrays (11/29/18) See notes under Smartboard presentations |

Audio/lectures Fall 2017 | Best use is frequently with the accompanying Smartboard presentation. Intro to Oracle (9/5/17) See notes under Smartboard presentation 9/7/17: Unfortunately I forgot to turn on the recorder, so I went through the Smartboard and recorded notes - but I am sure there are things I said in class that are missing. I suggest you look at the Smartboard notes and audio under Fall 2016 as well. Look at the information under September 8th on Intro to SQL. Continuing SQL (9/7/17) See notes under Smartboard presentation Maintain and functions (9/12/17) See notes under Smartboard presentation Functions and groups (9/14/17) See notes under Smartboard presentation Intro relational databases (9/19/17) See notes under Smartboard presentation Quiz and databases (9/21/17) See notes under Smartboard presentation Databases and subqueries (9/26/17) See notes under Smartboard presentation Subqueries inclass (9/28/17) See notes under Smartboard presentation Variables and maintenance (10/3/17) See notes under Smartboard presentation Views and reports (10/5/17) See notes under Smartboard presentation Subquery quiz and intro indexes/constraints (10/12/17) See notes under Smartboard presentation Keys, indexes/constraints (10/17/17) See notes under Smartboard presentation Finishing up SQL (10/24/17) See notes under Smartboard presentation Intro PL/SQL and IF (10/26/17) See notes under Smartboard presentation Loop and intro cursors (10/31/17) See notes under Smartboard presentation Cursors (example of 2 cursors) (11/2/17) See notes under Smartboard presentation Cursors continued (11/7/17) See notes under Smartboard presentation Cursors selects (11/9/17) See notes under Smartboard presentation Exceptions and things skipped (11/16/17) See notes under Smartboard presentation Intro to procedures (11/21/17) See notes under Smartboard presentation Functions and procedures (11/28/17) See notes under Smartboard presentation Trigger and array (12/5/17) See notes under Smartboard presentation Careers (12/7/17) See notes under Smartboard presentation |

Audio/lectures Fall 2016 | Best use is frequently with the accompanying Smartboard presentation. Intro to databases (9/6/16) See notes under Smartboard presentation Intro to SQL (9/8/16) See notes under Smartboard presentation More SQL: conditions, maintenance (9/13/16) See notes under Smartboard presentation More SQL: functions (9/15/16) See notes under Smartboard presentation Quiz and multiple tables (9/20/16) See notes under Smartboard presentation Relationships (9/22/16) See notes under Smartboard presentation Joins and subqueries (9/27/16) See notes under Smartboard presentation Subquery examples (9/29/16) See notes under Smartboard presentation Practice exercise (10/4/26) See notes under Smartboard presentation Variables and maintenance (10/6/16) See notes under Smartboard presentation Views and reports (10/13/16) See notes under Smartboard presentation Constraints and keys (10/18/16) See notes under Smartboard presentation More constraints, keys and also views (10/20/16) See notes under Smartboard presentation Wrapup SQL, intro PL/SQL (10/25/16) See notes under Smartboard presentation PL/SQL if loop etc (11/1/16) See notes under Smartboard presentation PL/SQL data manipulation and intro cursors (11/3/16) See notes under Smartboard presentation PL/SQL continuing cursors (11/8/16) See notes under Smartboard presentation Working on cursors (11/10/16) See notes under Smartboard presentation Debugging (11/15/16) See notes under Smartboard presentation Cursors and... (11/17/16) See notes under Smartboard presentation Cursors, types and exceptions (11/22/16) See notes under Smartboard presentation Procedures (11/29/16) See notes under Smartboard presentation Procedures, functions, blocks, triggers (12/1/16) See notes under Smartboard presentation More triggers (12/6/16) See notes under Smartboard presentation |

Audio/lectures Fall 2015 | Best use is frequently with the accompanying Smartboard presentation. Intro to databases (9/8/15) See notes under Smartboard presentation Intro to SQL (9/10/15) See notes under Smartboard presentation Maintenance and functions (9/15/15) See notes under Smartboard presentation Functions cont (9/17/15) See notes under Smartboard presentation Linking tables (9/22/15) See notes under Smartboard presentation Relating tables (9/24/15) See notes under Smartboard presentation Subqueries (9/29/15) See notes under Smartboard presentation More Subqueries (10/1/15) See notes under Smartboard presentation Input variables (10/6/15) See notes under Smartboard presentation Table Maintenance (10/8/15) See notes under Smartboard presentation Views and Reports (10/15/15) See notes under Smartboard presentation Indexes, keys and constraints (10/20/15) See notes under Smartboard presentation Indexes, keys and constraints cont (10/22/15) See notes under Smartboard presentation Views, seq and intro PL/SQL (10/27/15) See notes under Smartboard presentation If and loops in PL/SQL (11/3/15) See notes under Smartboard presentation Data manipulation (11/5/15) See notes under Smartboard presentation Cursors (11/10/15) See notes under Smartboard presentation Cursors cont (11/12/15) See notes under Smartboard presentation Pat McDonough talking about careers & Cursors cont (11/17/15) See notes under Smartboard presentation Exceptions, first handout, tables and records (11/19/15) See notes under Smartboard presentation Procedures and functions (12/1/15) See notes under Smartboard presentation Triggers (12/3/15) See notes under Smartboard presentation |

Audio/lectures Fall 2014 | Best use is frequently with the accompanying Smartboard presentation. Intro to databases (9/2/14) See notes under Smartboard presentation Create and query (9/4/14) See notes under Smartboard presentation Login to Oracle and queries (9/9/14) See notes under Smartboard presentation Queries, maintenance, functions (9/11/14) See notes under Smartboard presentation Functions and grouping (9/16/14) See notes under Smartboard presentation We worked on the Oracle Quiz of week 3 in class so no audio or Smartboard. Multiple tables (9/23/14) See notes under Smartboard presentation Multiple tables and intro subqueries (9/25/14) See notes under Smartboard presentation More subqueries and play computer exercise (9/30/14) See notes under Smartboard presentation Computer exercise and variables (10/2/14) See notes under Smartboard presentation Variables and maintenance (10/7/14) See notes under Smartboard presentation Scripts, views, reports (10/9/14) See notes under Smartboard presentation Indexes, keys, constraints (10/14/14) See notes under Smartboard presentation Thursday, Oct 16th was a short lecture - most of the time was spent with students working on the example. Indexes, keys, constraints cont (10/16/14) See notes under Smartboard presentation Wrapup SQL, intro PL/SQL (10/21/14) See notes under Smartboard presentation PL/SQL IF statements (10/23/14) See notes under Smartboard presentation PL/SQL loops, seq and intro cursors (10/28/14) See notes under Smartboard presentation PL/SQL cursors (10/30/14) See notes under Smartboard presentation More cursors (11/4/14) See notes under Smartboard presentation Wrapping up cursors (11/6/14) See notes under Smartboard presentation Open lab on Thursday, Nov 13th. Exceptions and procedures (11/18/14) See notes under Smartboard presentation Procedures and functions (11/20/14) See notes under Smartboard presentation Triggers (11/25/14) See notes under Smartboard presentation PL/SQL cursor examples (12/1/14) See notes under Smartboard presentation PL/SQL wrapup (12/4/14) See notes under Smartboard presentation |

Audio/lectures Fall 2013 | Best use is frequently with the accompanying Smartboard presentation. Intro to databases (9/3/13)See notes under Smartboard presentation Login and intro SQL (9/5/13)See notes under Smartboard presentation SQL and Queries (9/10/13)See notes under Smartboard presentation Maintenance, intro functions and quiz (9/12/13)See notes under Smartboard presentation More functions (9/17/13)See notes under Smartboard presentation More functions and multiple tables (9/19/13)See notes under Smartboard presentation Relational database (9/24/13)See notes under Smartboard presentation Subqueries (9/26/13) See notes under Smartboard presentations Variables and maintenance (10/1/13)See notes under Smartboard presentation Review exercise (10/3/13)See notes under Smartboard presentation Views and reports (10/8/13) See notes under Smartboard presentations Oct 10th was a catch up class. Constraints, keys, indexes (10/17/13) See notes under Smartboard presentations Constraints, keys, indexes and start PL/SQL (10/22/13) See notes under Smartboard presentations PL/SQL intro and IF (10/24/13) See notes under Smartboard presentations PL/SQL loops (10/29/13) See notes under Smartboard presentations PL/SQL using seq and intro cursors (10/31/13 See notes under Smartboard presentations PL/SQL cursors continued (11/5/13) See notes under Smartboard presentations More PL/SQL cursors continued (11/7/13) See notes under Smartboard presentations PL/SQL cursors and exceptions (11/12/13) See notes under Smartboard presentations PL/SQL procedures (11/14/13) See notes under Smartboard presentations PL/SQL procedures and functions (11/21/13) See notes under Smartboard presentations PL/SQL triggers (11/26/13) See notes under Smartboard presentations PL/SQL examples (12/3/13) See notes under Smartboard presentations More PL/SQL examples (12/5/13) See notes under Smartboard presentations |

Audio/lectures Fall 2012 | Best use is frequently with the accompanying Smartboard presentation. Intro to Oracle and SQL (9/4/12)See notes under Smartboard presentation Login and SQL conditions (9/6/12)See notes under Smartboard presentation Maintenance and functions (9/11/12)See notes under Smartboard presentation Quiz and functions (9/13/12)See notes under Smartboard presentation Relational database (9/18/12)See notes under Smartboard presentation Relational database continued (9/20/12)See notes under Smartboard presentation Relational database and join (9/25/12)See notes under Smartboard presentation Subqueries (9/27/12)See notes under Smartboard presentation Input variables and maintenance (10/2/12)See notes under Smartboard presentation Views and reports (10/11/12)See notes under Smartboard presentation Constraints and indexes (10/16/12)See notes under Smartboard presentation Constraints and indexes cont (10/18/12)See notes under Smartboard presentation Intro to PL/SQL (10/23/12)See notes under Smartboard presentation Decisions in PL/SQL (10/25/12)See notes under Smartboard presentation Loops in PL/SQL (11/1/12)See notes under Smartboard presentation Intro to cursors in PL/SQL (11/6/12)See notes under Smartboard presentation More cursors in PL/SQL (11/8/12)See notes under Smartboard presentation Continuing cursors in PL/SQL (11/13/12)See notes under Smartboard presentation Wrapup cursors and Exceptions (11/15/12)See notes under Smartboard presentation Inner code, data and intro procedures (11/20/12)See notes under Smartboard presentation Record, type, procedure, functions (11/27/12)See notes under Smartboard presentation Triggers, procedure, functions (11/29/12)See notes under Smartboard presentation |

Audio/lectures Fall 2011 | Best use is frequently with the accompanying Smartboard presentation. Intro to Relational Databases (9/6/11) See notes under Smartboard presentation Log in to Oracle (9/8/11) See notes under Smartboard presentation Beginning Oracle(9/13/11) See notes under Smartboard presentation Oracle queries and maintenance (9/15/11) See notes under Smartboard presentation Oracle functions (9/20/11) See notes under Smartboard presentation Functions and Quiz (9/22/11) See notes under Smartboard presentation Multiple tables (9/27/11) See notes under Smartboard presentation Multiple tables cont (9/29/11) See notes under Smartboard presentation Subqueries (10/4/11)See notes under Smartboard presentations Variables (10/13/11)See notes under Smartboard presentations Maintain, script, views (10/18/11)See notes under Smartboard presentations Reports and intro constraints (10/20/11)See notes under Smartboard presentations Constraints (10/25/11)See notes under Smartboard presentations Sequence and intro PL/SQL (10/27/11)See notes under Smartboard presentations PL/SQL IF statements (11/1/11)See notes under Smartboard presentations PL/SQL loop statements (11/3/11)See notes under Smartboard presentations Mostly an open lab so not much content (11/8/11)See notes under Smartboard presentations Mostly an open lab solving odd number problem (11/10/11)See notes under Smartboard presentations Intro to cursors (11/15/11)See notes under Smartboard presentations More cursors (11/17/11)See notes under Smartboard presentations More cursors (11/22/11)See notes under Smartboard presentations Exceptions and start procedures (11/29/11)See notes under Smartboard presentations Cursors and procedures (12/1/11)See notes under Smartboard presentations Procedures & functions (12/6/11)See notes under Smartboard presentations Triggers (12/8/11)See notes under Smartboard presentations |

Audio/lectures Fall 2010 | Best use is frequently with the accompanying Smartboard presentation. Intro to Oracle (9/7/10) See notes under Smartboard presentation Intro to Oracle cont. (9/9/10) Accompanying Smartboard presentation Maintenance and functions (9/14/10) Accompanying Smartboard presentation Group functions (9/16/10) Accompanying Smartboard presentation Relational database (9/21/10) Accompanying Smartboard presentation Relational database cont (9/23/10) Accompanying Smartboard presentation Multiple tables and subqueries (9/28/10) Accompanying Smartboard presentation Joins and subquery review (9/30/10) Accompanying Smartboard presentation Variables and maintenance(10/5/10) Accompanying Smartboard presentation Oct 7th class canceled. Views and reports (10/14/10) Accompanying Smartboard presentation Indexes, constraints, keys (10/19/10) Accompanying Smartboard presentation Indexes, constraints, keys cont. part a(10/21/10) Accompanying Smartboard presentation Indexes, constraints, keys cont. part b (10/21/10) Accompanying Smartboard presentation Sequence etc and intro PL/SQL (10/26/10) Accompanying Smartboard presentation Using Putty and IF and LOOP in PL/SQL (10/28/10) Accompanying Smartboard presentation PL/SQL loops and example (11/2/10) Accompanying Smartboard presentation PL/SQL in class project (11/4/10) Accompanying Smartboard presentation Intro to Cursors (11/9/10) Accompanying Smartboard presentation Cursors (11/16/10) Accompanying Smartboard presentation Cursors (a few notes after some work in class 11/16/10) Accompanying Smartboard presentation More Cursors (11/18/10) Accompanying Smartboard presentation Clean up left overs (11/23/10 lost the last part) Accompanying Smartboard presentation Exceptions and procedures (11/30/10) Accompanying Smartboard presentation Procedures and functions (12/2/10) Accompanying Smartboard presentation I was out sick on December 7th. Triggers (12/9/10) Accompanying Smartboard presentation |

Audio/lectures Fall 2009 | Best use is frequently with the accompanying Smartboard presentation. Intro to Oracle (9/8/09) Accompanying Smartboard presentation Intro to queries (9/10/09) Accompanying Smartboard presentation More intro material (9/11/09) Accompanying Smartboard presentation Maintenance and functions (9/15/09) Accompanying Smartboard presentation Functions (9/17/09) Accompanying Smartboard presentation Finish Functions (most of class quiz) (9/18/09) Accompanying Smartboard presentation Relational databases (9/22/09) Accompanying Smartboard presentation Relational databases cont (9/24/09) Accompanying Smartboard presentation Relating multiple tables (9/25/09) Accompanying Smartboard presentation Sept 29th was catch up day and or Quiz day depending on what you needed. Relating and joins (10/1/09) Accompanying Smartboard presentation Joins and subroutines (10/2/09) Accompanying Smartboard presentation Design and subroutines (10/6/09) Accompanying Smartboard presentation Input variables (10/8/09) Accompanying Smartboard presentation Input variables cont. (10/9/09) Accompanying Smartboard presentation Maintenance and views (10/15/09) Accompanying Smartboard presentation Views and reports (10/16/09) Accompanying Smartboard presentation Keys and indexes. (10/20/09) Accompanying Smartboard presentation No notes for 10/22 and 10/23, I was at a conference. Keys and constraints. (10/27/09) Accompanying Smartboard presentation Finishing SQL (10/29/09) Accompanying Smartboard presentation Lab on 10/30. Carol with putty access (11/3/09) Accompanying Smartboard presentation PL/SQL intro and if (11/5/09) Accompanying Smartboard presentation PL/SQL if and intro loop (11/6/09) Accompanying Smartboard presentation PL/SQL loops, intro, nesting (11/10/09) Accompanying Smartboard presentation Data manipulation (11/12/09) Accompanying Smartboard presentation Cursors (11/13/09) Accompanying Smartboard presentation Cursors with inclass project (11/17/09) Accompanying Smartboard presentation Cursors with inclass project cont (11/19/09) Accompanying Smartboard presentation Cursors with inclass project cont and start new project (11/20/09) Accompanying Smartboard presentation Lab on 11/24/09. Cursors, types, tables (12/1/09) Accompanying Smartboard presentation Cursors and exceptions (12/3/09) Accompanying Smartboard presentation I was out sick on 12/4/09. Sorry, battery problem and audio lost on 12/8/09. Subroutines and functions (12/10/09) Accompanying Smartboard presentation Procedures and functions (12/11/09) Accompanying Smartboard presentation Triggers (12/15/09) Accompanying Smartboard presentation |

Audio/lectures Fall 2008 | Best use is frequently with the accompanying Smartboard presentation. Database Design - normalization (9/2/08) Accompanying Smartboard presentation (note last part got lost) Database Design - normalization cont (9/4/08) Accompanying Smartboard presentation SQL intro and login (9/5/08) Accompanying Smartboard presentation Oracle queries intro (9/9/08) Accompanying Smartboard presentation More queries (9/11/08) Accompanying Smartboard presentation More queries & maintenance (9/12/08) Accompanying Smartboard presentation Functions (9/16/08) Accompanying Smartboard presentation More functions (incomplete - need decode)(9/18/08) Accompanying Smartboard presentation Group functions (battery low missed a lot( (9/19/08) Accompanying Smartboard presentation Relational, multiple tables (9/23/08) Accompanying Smartboard presentation Relational, multiple tables cont (9/25/08) Accompanying Smartboard presentation Relational, multiple tables more (9/26/08) Accompanying Smartboard presentation Subqueries intro (9/30/08) Accompanying Smartboard presentation I was out sick on 10/2/08. Subqueries cont & lab time(10/3/08) Accompanying Smartboard presentation Input & variables(10/7/08) Accompanying Smartboard presentation Maintenance and Views (10/9/08) Accompanying Smartboard presentation Views and Reports (10/10/08) Accompanying Smartboard presentation Indexes intro (10/16/08) Accompanying Smartboard presentation I was at a conference on 10/16/08. Indexes, keys, constraints (10/21/08) Accompanying Smartboard presentation Finishing SQL (10/23/08) Accompanying Smartboard presentation On 10/23/08 we had a question and answer lab. Introducing PL/SQL (10/28/08) Accompanying Smartboard presentation On 10/30/08 and 10/31/08 I was at a NSF conference. Writing PL/SQL in class (11/4/08) Accompanying Smartboard presentation PL/SQL loops (11/6/08) Accompanying Smartboard presentation Beginning PL/SQL revisited (11/7/08) Accompanying Smartboard presentation On 11/12/08 I was at a grant meeting/ Introduction to cursors (11/13/08) Accompanying Smartboard presentation Multiple cursors (11/14/08) Accompanying Smartboard presentation Cursor examples cont (11/20/08) Accompanying Smartboard presentation Cursor examples & exceptions (11/21/08) Accompanying Smartboard presentation Cursor examples & exceptions (battery problem - end of lecture here) (11/21/08) Accompanying Smartboard presentation All day lab on 11/25/08. Cursor, procedures, functions (12/2/08) Accompanying Smartboard presentation Cursor, procedurescont (12/4/08) Accompanying Smartboard presentation Functions (12/5/08) Accompanying Smartboard presentation Functions cont (tech problem) (12/5/08) Accompanying Smartboard presentation |

Audio/lectures Fall 2007 | Best use is frequently with the accompanying Smartboard presentation. Database Design - normalization (9/4/07) Accompanying Smartboard presentation Database Design - normalization cont. (9/6/07) Accompanying Smartboard presentation Oracle and conditions (9/11/07) Accompanying Smartboard presentation Conditions and editing (9/13/07) Accompanying Smartboard presentation Maintenance and functions (9/14/07) Accompanying Smartboard presentation Group functions (9/18/07) Accompanying Smartboard presentation In class quiz on Sept 20th. Relating multiple tables (9/21/07) Accompanying Smartboard presentation Relating multiple tables cont. (9/25/07) Accompanying Smartboard presentation In class quiz on Sept 27th. Starting subqueries (9/28/07) Accompanying Smartboard presentation I am having trouble with both the reorder and my voice. I suggest you look for recordings from last Fall. Variables (10/11/07) Accompanying Smartboard presentation Views & reports (10/16/07) Accompanying Smartboard presentation < |

Audio/lectures Fall 2006 | Best use is frequently with the accompanying Smartboard presentation. Intro Database (9/5/06) Accompanying Smartboard presentation More Intro database (9/7/06) Accompanying Smartboard presentation Starting SQL (9/8/06) Accompanies Oracle notes (create a table in SQL and Introduction to SQWL in Oracle) More SQL with WHERE (9/12/06) Accompanying Smartboard presentation and notes Functions (9/14/06) Accompanying Smartboard presentation and notes Editing and functions (9/15/06) Please see notes on editing and notes on fuctions Group functions etc (9/19/06) Smartboard presentation and notes Relational database (9/21/06) Use notes on relational databases (problem with Smartboard capture) Relational database notes (9/26/06) Accompanying Smartboard presentation Relational database notes (9/28/06) Accompanying Smartboard presentation Joins and Subqueries (9/29/06) Accompanying Smartboard presentation Subqueries and Input Variables (10/3/06) Accompanying Smartboard presentation Input variables and maintenance (10/6/06) Accompanying Smartboard presentation Maintenance and views (10/12/06) Accompanying Smartboard presentation Reports (10/13/06) Accompanying Smartboard presentation Indexes and Keys (10/17/06) Accompanying Smartboard presentation Indexes and Keys continued (10/19/06) Accompanying Smartboard presentation Wrapup of SQL and Introduction to PL/SQL (10/26/06) Accompanying Smartboard presentation PL/SQL if and loops (10/27/06) Accompanying Smartboard presentation PL/SQL loops (10/31/06) Accompanying Smartboard presentation PL/SQL misc and nested loops (11/2/06) Accompanying Smartboard presentation Records/types/array (11/7/06) Accompanying Smartboard presentation Intro to cursors (11/9/06) Accompanying Smartboard presentation More cursors (11/14/06) Accompanying Smartboard presentation Set of cursor examples (11/16/06) Accompanying Smartboard presentation Procedures and functions (11/28/06) Accompanying Smartboard presentation Procedures and functions cont (12/1/06) Accompanying Smartboard presentation |

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

Back to the Top

Return to home page

Return to previous page