Week 5 - I/O, data management & More

Learning objectives

• Data management SQL statement

Lecture notes:

Tuesday

• lecture-notes-05-tue.txt

• class-script-05-tue-1.sql

• slides triggers

• class-script-05-tue-2.sql

Thursday

• Advanced topics:
  • Slides
• Bash programming:
  • Bash essentials
  • Vim editor

Data:

• Class data GitHub repository

How to sync your fork

• How-to sync your fork

Resources

1. Jeffrey D. Ullman and Jennifer Widom (2008). A First Course in Database Systems. 3rd ed. Upper Saddle River, NJ: Pearson/Prentice Hall.
   Access via Library Catalog

   • Complete but theoretical introduction to relational databases, data modeling, and relational algebra.