Schedule

• Lecture 1: “Introduction to Databases” on Tuesday, August 25
  • Syllabus
  • Slides
• Lab 1: “Database Schema Exploration” on Thursday, August 27, due Monday, August 31
  • Prepare by reading Chapter 1 through Chapter 2.1
  • Description
• Homework 1: “Database Schema Design” assigned Thursday, August 27, due Monday, August 31
  • Description
• Lecture 2: “Introduction to ER Modeling” on Friday, August 28
  • Prepare by reading Chapter 3 through Chapter 3.4
  • Slides
    
    

• Lecture 3: “Advanced ER Modeling” and “Data Lifecycle” on Tuesday, September 1
  • Prepare by finishing Chapter 3
  • Advanced ER Modeling Slides
  • Data Lifecycle: Planning Slides
• Homework 2: “ER Schema Interpretation” assigned Tuesday, September 1, due Monday, September 7
  • Description
• Lab 2: “ER Schema Design” on Thursday, September 3, due Monday, September 7
  • Description
• Lab 3: “Privacy Laws” on Friday, September 4, due Monday, September 7
  • Description
    
    

• Lecture 4: “Relational Model” and “SQL DDL” on Tuesday, September 8
  • Prepare by reading Chapter 5
  • Relational Model Slides
  • SQL DLL Slides
• Homework 3: “The Relational Data Model” assigned Tuesday, September 8, due Monday, September 14
  • Description
• Lab 4: “SQL DDL” on Thursday, September 10, due Monday, September 14
  • Description
• Lecture 5: “Relational Algebra” on Friday, September 11
  • Prepare by reading Chapter 8 through section 8.5
  • Slides
    
    

• Lecture 6: “Relational Calculus” on Tuesday, September 15
  • Prepare by finishing Chapter 8
  • Slides
• Homework 4: “Relational Algebra and Calculus” assigned Tuesday, September 15, due Monday, September 21
  • Description
• Lab 5: “Relational Algebra and Calculus Practice” on Thursday, September 17, due Monday, September 21
  • Description
• Lecture 7: “ER to Relational Mapping” and “Introduction to SQL DML” on Friday, September 18
  • Prepare by skimming Chapter 4 and reading Chapter 9
  • ER to Relational Mapping Slides
  • SQL DML Slides
• Homework 5: “ER to Relational Mapping” assigned Friday, September 18, due Wednesday, September 23
  • Description
    
    

• Lab 6: “SQL DML” on Tuesday, September 22, due Monday, September 28
  • Prepare by reading Chapter 6
  • SQL DML Slides
  • Description
• Lab 7: “Docker” on Thursday, September 24 due Monday, September 28
  • Prepare by reading Docker’s introductory tutorial and CACM’s “A Decade of Docker Containers”
  • Docker Slides
  • Description
• Lecture 8: “Review” on Friday, September 25
  • Prepare by reviewing feedback on your homework, catching up with reading, and identifying topics you have questions about
    
    

• Midterm Exam 1 on Tuesday, September 29
  • Covering all material up to and including Lecture 7 and Homework 5
  • You may use a one-sided 8.5”×11” review sheet. If you use a review sheet, you must turn it in with your exam.
• Lecture 9: “Database Programming” on Thursday, October 1
  • Prepare by skimming Chapter 10
  • Slides
• Homework 6: “Project Proposals” assigned Thursday, October 1, due Monday, October 5
  • Description
• Lab 8: “Database Programming with SQLite” on Friday, October 2, due Monday, October 5

Advanced Reading

SQL Antipatterns, by Bill Karwin. Available through the Clark Library.