CS 3330 – Fall 2019

Database Concepts

Handouts

Exam 1 Study Materials

Exam 2 Study Materials

Homework Assignments

  • HW 01 – Due Sept 18, 2019 uploaded to Canvas by 11pm
    • Replace the duplicated 4 questions (sorry about that) with the following 2:
      • Write SQL Create Table Statements for the three relations in the schema at the start of the assignment
      • Write SQL Insert statements to add 5 rows to each of the three tables you just created.
  • HW 02 – SQL Fun
    • The Database for HW2 is Here.

Other Websites &  Readings

  • SQL Practice –
    • Hacker Rank SQL Domain – Gives you queries to write in SQL and will score them.
    • SQL Zoo – Allows you to write SQL to respond to questions.

Tools & Topics for Project (Work-in-Progress)

  • Express JS – “Fast, unopinionated, minimalist web framework for Node.js”
  • KNEX.js – SQL Query Builder for Node.js