DATA 620 - Database Technologies - Spring 2017

Department of Mathematics and Information Technology

Dr. Angela Berardinelli

Important Dates for Spring 2017

  • Tuesday, January 17 - First class
  • Monday, January 23 - Last day to add/drop
  • Thursday, February 16 - Deadline to select your course project
  • Tuesday, February 28 - Exam 1
  • Tuesday, March 7 and Thursday March 9 - Spring Break (no class)
  • Tuesday, March 21 - Exam 2
  • Thursday, April 6 - Exam 3
  • Tuesday, April 11 - Advising Day (no class)
  • Thursday, April 13 - Easter Break (no class)
  • Friday, April 21 - Last day to withdraw
  • Tuesday, May 2 - Exam 4
  • Tuesday, May 9 - Final Project Meetings

Course Description

A course in relational and non-relational databases, with MySQL and MongoDB as the tools of choice. Students will study SQL, database administration, database design, the differences between relational and NoSQL databases and their respective advantages, and the particulars of MySQL and MongoDB. 3 credits.

Prerequisites: None.

Additional information:

  • This elective course is suitable for graduate students in both the Data Science program and the Applied Intelligence program.
  • The central question of the course will be "How do I get good data out of a database quickly and efficiently for the purposes of quantitative or qualitative analysis?"
  • We will compare and contrast several different types of data storage (spreadsheets, relational databases, document databases, column store databases, graph databases).
  • As the official course description states, we will discuss database design and database administration. However, our focus will be on how to write clear, efficient data-fetching queries.
  • No previous knowledge of programming or database technologies will be assumed.

Resources

There will be no required textbook.

A virtual machine custom built for this course will be provided on the course website.

Office Hours: The perfect opportunity to ask general questions about course material, specific questions about homework problems or in-class examples, questions about your grade, questions about your project, etc. My office location and office hour schedule are on my home page. You can also e-mail me to set up an appointment outside of office hours if that suits your schedule better.

Grading Information

If you have a weighted average of at least... You will earn a(n):
90% A
85% B+
80% B
75% C+
70% C
65% D+
60% D

There will be four in-class exams; each will account for 15% of your final grade in the course. The rest of your grade will come from completing milestones in the course project.