Any Future Plans are Tentative

• June 9th: Jump into SQL using SQLite
• June 11th: Build a CRUDy app for well RESTed people
• June 16th: Select scavenge, Hello MySQL Scavenger Hunt Answers (there are many possible answers btw):
  1. select distinct(name) from student, takes, course where student.ID = takes.ID and takes.course_id = course.course_id and course.dept_name = "Comp. Sci."; ALTERNATIVELY (but not as nice): select distinct(name) from takes natural join student where substr(course_id,1,2) == "CS";
  2. select name, ID from student S where not exists (select distinct(ID) from takes T where T.ID = S.ID and year < 2009 union select distinct(ID) from takes T where T.ID = S.ID and year=2009 and semester in ('Spring', 'Summer'));
  3. select max(salary) as d_max, dept_name from instructor group by dept_name order by d_max asc limit 0, 1;
• June 18th: Dirty DB Dayz
• June 23th: Oh girl, you got the keys to my chart
• June 25th: Indices ORMagic?
• June 30th: ACID trippin'
• July 2nd: Halfway Home
• July 7nd: Hello Mongo
• July 9nd: NoSQL Designing
• July 14nd: Building APIs with Mongoose
• July 16nd: Workshop Day
• July 21nd: Firebase Crud and basic client-side Javascript
• July 23nd: Clean-up Topics
• July 28th: Final Class