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/18 Course Overview and Introduction to Databases
8/23 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)
8/25 SQL: Data Definition Chapter 7
8/30 The Relational Model Chapter 4
9/1 Relational Algebra Chapter 5.1
9/6 Catchup Day None
9/8 Introduction to Data Modeling Chapter 2
9/13, 15 Entity-Relationship Modeling Chapter 12
9/20, 22 Normalization Chapter 14
9/27, 10/4, 10/6 Conceptual, Logical, and Physical Database Design Chapters 16, 17, 18, 19, 23
10/11 Catch up day None
10/13 Introduction to Scripting Languages perl 1
10/18 Perl Basics
10/20 Midterm None
10/25, 10/27 (Engineers Day), 11/1 Regular Expressions
11/3 Manipulating File Systems with Perl
  1. Perl File Commands
  2. Perl System Commands
11/8 Web Scripting with Perl
11/10, 15, 17 The Python Language
11/22 Python and Graphical User Interfaces TBA
11/24 Thanksgiving None
11/29 Catch up None