Lecture Notes


Important: The dates and the assigned readings are tentative until a few days before the actual class so you should make sure you check this site regularly. Chapter assignments refer to chapters in the Connolly and Begg textbook.

Date Topics Assigned Readings
8/22 Course Overview and Introduction to Databases Chapter 1
8/27 Introduction to Data Modeling Chapter 2
8/29 The Relational Model Chapter 4
9/3, 5 SQL: Data Manipulation
  1. w3schools SQL Tutorial. Read all the SQL Basic, play with the SQL demo, and read the following topics in the advanced section:
    • SQL Order By
    • SQL and & or
    • SQL In
    • SQL Between
    • SQL Join
    • SQL Create
  2. My SQL Notes
  3. Chapter 6 (skim)
9/10 SQL: Data Definition Chapter 7
9/12 Relational Algebra Chapter 5.1
9/17 Catchup Day None
9/19, 24 Entity-Relationship Modeling Chapter 12
9/26, 10/1 Normalization Chapter 14
10/3 Physical Database Design
  1. physical design
  2. Chapter 18
10/8 Midterm Exam None
10/10 Introduction to Scripting Languages
  • perl 1
  • Videos:
    1. Extendible Hashing
    2. ScriptingLanguageIntro
    3. Perl-Introduction
10/15 Perl Basics
10/17 Fall Break None
10/22 Regular Expressions, Functions, and Files perl 2
10/24 (Engineering Day)--No class but online video regular expression introduction and regular expression wrapup ---
10/29 Perl Sorting, Modules, and Object-Oriented Programming perl 2
10/31
  1. PHP Tutorial-Read the PHP Basics section through PHP functions
  2. Introduction to PHP
  3. Getting Started in PHP
  4. Brad's Cliff Notes Version of PHP
  5. Geoff Mazeroff's Cliff Notes Version of PHP
PHP Basics
11/5 Creating xhtml forms XHTML forms
11/7
  1. PHP Tutorial
    • Read the PHP Basics section from PHP Forms to the end
    • PHP Cookies
    • PHP Sessions
  2. Handling Forms
Handling Forms and Session Management in PHP
11/12
  1. PHP SQL-Read the PHP SQL section up to MySQL Delete.
  2. my PHP SQL notes
  3. XML Introduction
  4. XML Schemas
  5. PHP XML Parsing
XML and PHP interface to mySQL
11/14
  1. w3 schools JavaScript notes up to, and including, JS Validation.
  2. my JavaScript notes
  3. Arrays, Functions, and Objects
  4. w3 schools JS Objects. First
Introduction to JavaScript
11/19
  1. w3 schools JS HTML DOM. First go to "Learn JavaScript" and then to "JS HTML DOM".
  2. Javascript DOM
HTML DOM and Javascript DOM API
11/21
  1. Forms and form validation
  2. Regular Expressions
Forms, Events, and Regular Expressions
11/26
  1. w3schools Ajax tutorial
  2. My Ajax notes
Ajax
11/28 Thanksgiving  
12/3 AJAX in-class exercise Attendance is mandatory