Learning Objectives

• See the syllabus. Let me know which of the objectives you felt was not fulfilled.

Remember What We Covered?

• The big introduction to, and overview of, the field of databases
• The major database models and what they each do well
• Redis
• The Coin Game
• SocketIo
• Programming Redis with an async library
• A little bit of canvas graphics
• MongoDB (Thank you MongoDB University)
• A big overview of SQL
• Design of relational database schemas
• Postgres
• SQL
• Sequelize, Why ORMs, and Migrations (YIKES)
• Callbacks, Promises, and Async/Await
• REST APIs
• Writing web services with Node backed by Postgres with a Sequelize interface
• Graph databases
• Neo4j and Cypher
• Relational algebra (a little)
• Normalization of relations (a little)

Things We Did Not Cover

• Relational Caculus
• The depths of normalization theory
• Views, roles, and a few other DBA things
• Physical Stuff, like storage layout (though you got a bit in the context of Mongo)
• HBASE and Cassandra (I’M SORRY!)

Things to Study

First of all: practice, practice, practice, writing queries in:

• Redis
• Mongo
• Postgres SQL
• Cypher

And note, there will be one little question about Sequelize, most likely of the form “what is wrong with this attempt to do something in Sequelize?”

Sample Problems

Head over to the Practice Problems and do everything related to Redis, Mongo, SQL, Postgres, Sequelize, Neo, Cypher, and Asynchronous Programming.

Help

Please come to office hours during finals week. You must have two people from each group come for a session.

• Monday: 8:45-12
• Tuesday: 8:45-3
• Wednesday: 2-5
• Thursday: 4-6

Logistics

• Final Exam appears online at Monday at Noon
• Final Exam must be emailed to me by Friday at 8am
• Duration NOT TO EXCEED 3 hours
• Usual NO SOLICITATION RULE