Audio for CIS50 - Oracle and SQL

Category Information - Frequently you will find that the audio goes well with the Smartboard
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
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