Database Systems


Fall 2020

This is Jim Gray. This is not Alan. This is not Santa Clause.

Documents

Books

Readings

Labs

  1. Setting up PostgreSQL
  2. Loading our CAP database
  3. Getting started with SQL queries
  4. SQL Queries: the subqueries Sequel
  5. SQL Queries: the joins Three-quel
  6. Interesting and Painful SQL Queries
  7. Normalization One
  8. Normalization Two
  9. Normalization Three
  10. Stored Procedures - Here is the courses and prerequisites script.

Projects

Online Learning

  • Class 0
  • Notes : -
    Lab : -
    Video : -
  • Class ½ - Special Saturday Session online
  • Link : -
  • Class 1
  • Notes : -
    Lab : -
    Video : -
  • Class 2
  • Notes : -
    Lab : -
    Video : -
  • Class 3
  • Notes : -
    Lab : -
    Video : -
  • Class 4
  • Notes : -
    Lab : -
    Video : -
  • Class 5
  • Notes : -
    Lab : -
    Video : -
  • Class 5½ - Special Saturday Session online
  • Link : -
  • Class 6 - Mid-term Exam in class
  • Class 7
  • Notes : -
    Lab : -
    Video : -
  • Class 8
  • Notes : -
    Lab : -
    Video : -
  • Class 9
  • Notes : -
    Lab : -
    Video : -
  • Class A
  • Notes : -
    Lab : -
    Video : -
  • Class B
  • Notes : -
    Lab : -
    Video : -
  • Class C
  • Notes : -
    Lab : -
    Video : -
  • Class D - Final Exam in class
  • Class E - Regular Monday session, but online.
  • Link : -
  • Class F - Final Project Due. Possible on-line demo.

Resources

Additional Material

Articles

Songs


Database Haiku

  • These are from Hugh Scott at SQL Server Central
    • Server is lifeless
      The customer is distraught
      Where is the backup?
    • Performance is slow
      All the disk drives are busy
      Where was the where clause?
    • The server is built
      Everything is now installed
      What was the password?
  • These are from former students. Got one?
    • I did the homework
      As difficult as it was
      Do I get an A?

Ted Codd
I reserve the copyright for all parts of my courses. Commercial reproduction of any course material, including lecture notes taken by students, without my EXPRESS WRITTEN consent, is prohibited. Seriously.