Resources

Resources by week

• Week 1
  • Lecture 1: Intro
  • Lecture 2: SQL (select)
  • Readings: Hoffman, Introduction to Structured Query Language
• Week 2
  • Lecture 3: SQL (schemas).
  • Northwind database
  • Recitation 1 (queries). Chinook database. Mediatype csv.
  • Lecture 4: SQL (group by)
  • Readings: Frazier, SQLite Documentation for 3120
• Week 3
  • Homework 1 due W 2/5/2020 2:30pm
• …
• Week 7
  • Prelim 1 T 3/3/2020 7:30pm
• …
• Week 11
  • Prelim 2 T 4/7/2020 7:30pm
• …
• Finals
  • Final Exam Sa 5/9/2020 9:00am