January

Week 1

SQL chapter 1

Tuesday 12 January

• course introduction & logistics
• the relational database model

Thursday 14 January

• prior to class finish chapter 1 of textbook
• lab 1 – Run your personal wikipedia

Week 2

SQL ch. 1 & 2

Tuesday 19 January

• RAT 1 (readiness assessment test on ch. 1 – closed book 1 3×5 card of notes)
• determine grade weights

Thursday 21 January

• git intro and git assignment
• creating and querying databases movies2.sql (the Rotten Tomatoes & Billboard data)
• Worksheet 1: The world – basic queries

Week 3

Chapter 3 of textbook

Tuesday 26 January

• Intro to PHP html version of slides
• Worksheet 1
• Delete and Insert

Thursday 28 January

• RAT 2 (ch. 2 & 3) one 3×5 card of note