MSCD664 - Introduction to NoSQL Databases: Syllabus

Instructor Information

Refer to Discussion Forum, Facilitator Introduction and Expectations

Course Title

MSCD664 - Introduction to NoSQL Databases

Course Description

The MSCD664 NoSQL database course will provide students with an introduction, overview and history of NoSQL databases (non-relational databases). The four types of NoSQL databases (e.g. Document-oriented, Key-Value Pair, Column-oriented and Graph) will be explored in detail.

Prerequisite Courses

MSCD600 – Database Architecture

Course Outcomes

Upon completion of this course, learners should be able to:

  1. Define, compare and use the four types of NoSQL Databases (Document-oriented, KeyValue Pairs, Column-oriented and Graph).
  2. Demonstrate an understanding of the detailed architecture, define objects, load data, query data and performance tune Column-oriented NoSQL databases.
  3. Explain the detailed architecture, define objects, load data, query data and performance tune Document-oriented NoSQL databases.
  4. Demonstrate an understanding of the detailed architecture, define objects, load data, query data and performance tune Key-Value Pair NoSQL databases.
  5. Explain the detailed architecture, define objects, load data, query data and performance tune Graph NoSQL databases.
  6. Evaluate NoSQL database development tools and programming languages.
  7. Perform hands-on NoSql database lab assignments that will allow students to use the four NoSQL database types via products such as Cassandra, Hadoop Hbase, MongoDB, Neo4J and Riak.

Course Materials

Required Texts

Sadalage, P. & Fowler, M. (2012). NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence. (1st Ed.). Upper Saddle River, NJ: Pearson Education, Inc. ISBN- 13: 978-0321826626 ISBN-10: 0321826620

Redmond, E. & Wilson, J. (2012). Seven Databases in Seven Weeks: A Guide to Modern Databases and the NoSQL Movement (1st Ed.). Raleigh, NC: The Pragmatic Programmers, LLC. ISBN-13: 978-1934356920 ISBN-10: 1934356921

Required Resources

American Psychological Association (current edition). APA Publication Manual. Retrieved from http://www.apastyle.org/.

Optional Resources

Robinson, I. Webber, J. & Eifren, E. (2013). Graph Databases. (1st ed.). Sebastopol, CA: O’Reilly Media, Inc. ISBN-13: 978-1-449-35626-2.

Technology Tools

CC&IS Virtual Lab: Login to your Citrix account using your Regisnet ID and password with the URL shown below. The browser that we recommend is Google Chrome or Firefox (avoid IE). The BI labs will provide detailed instructions for using the various tools that you will use during this course. http://myregisapp.regis.edu/Citrix/StoreWeb/

technical specifications

Library Tutorials

Purdue Online Writing Lab (OWL). Retrieved from https://owl.english.purdue.edu/owl/section/2/10/.

Research Tutorials (n.d.). Regis University Library.

Pre-Assignment

See Course Assignments and Activities table below for Week 1.

Course Assignments and Activities

Assignments for Online Course
Week Readings Graded Assignments or Assessments (Percentage)
1: Introduction, Overview, and History of NoSQL Databases – The Definition of the Four Types of NoSQL Databases

Sadalage & Fowler (2012). Chapters 1, 2, & 3

Redmond & Wilson (2012). Chapter 1

From the Expert: Introduction to Big Data, Hadoop, Map Reduce, and NoSQL

1.1 Introductions – initial response required by Wednesday of Week

1.2 Discussion Questions

1.3 Quiz 1

2: Column-oriented NoSQL databases using Apache HBASE

Sadalage & Fowler (2012). Chapters 4 & 5

Redmond & Wilson (2012). Chapter 4

From the Expert: Columnoriented NoSQL databases using Apache HBASE

2.1 Discussion Questions

2.2 Lab 1 - Hbase

2.3 Quiz 2

3: Column-oriented NoSQL databases using Apache Cassandra

Sadalage & Fowler (2012). Chapters 10, 12 & 13

From the Expert: Introduction to Cassandra

Course Resources: Review Scholarly Response Research Paper – Guidelines and Rubric

3.1 Discussion Questions

3.2 Lab 2 - Cassandra

3.3 Quiz 3

4: NoSQL Key/Value databases using MongoDB

Sadalage & Fowler (2012). Chapter 9

Redmond & Wilson (2012). Chapter 5

From the Expert: How to download and install the MongoDB

4.1 Discussion Questions

4.2 Lab 3 - Using and learning the MongoDB environment

4.3 Quiz 4

5: NoSQL Key/Value databases using Riak

Sadalage & Fowler (2012). Chapter 8

Redmond & Wilson (2012). Chapter 3

From the Expert: How to download and install the Riak-Ubuntu Virtualbox VM

5.1 Discussion Questions

5.2 Scholarly Response Due

5.3 Lab 4- Using and learning the Riak environment

5.4 Quiz 5

6: Graph NoSQL databases using Neo4J

Sadalage & Fowler (2012). Chapter 11

Redmond & Wilson (2012). Chapter 7

From the Expert: How to Download and Install Neo4j Video

6.1 Discussion Questions

6.2 Lab 5 - Download and Install Neo4j for your computer platform

6.3 Quiz 6

7: NoSQL database development tools and programming languages

Sadalage & Fowler (2012). Chapters 6, 7

From the Expert: Pig Programming, Hive and Python Map Reduce

7.1 Discussion Questions

7.2 Lab 6 – HiveQL

7.3 Quiz 7

8: Course Summary and Future Trends for NoSQL databases

Sadalage & Fowler (2012). Chapters 14 & 15

Redmond & Wilson (2012). Chapter 9

From the Expert: None

8.1 Week 8 Discussion Questions

8.2 Final Exam

TOTAL:

Summary of Assignments and Percentage Weight:

Assignments Weighted Percentage
Discussion Questions and Class Participation (7 ) 15%
Scholarly Response Research Paper (1) 15%
Labs (6) 25%
Quizzes (7) 20%
Final Exam 25%
TOTAL 100 %

CCIS Policies

Review the CCIS Policies on the Regis University website.

OTHER INFORMATION

NOTE TO LEARNERS: On occasion, the course facilitator may, at his or her discretion, alter the Learning Activities shown in this Syllabus. The alteration of Learning Activities may not, in any way, change the Learner Outcomes or the grading scale for this course as contained in this syllabus. Examples of circumstances that could justify alterations in Learning Activities could include number of learners in the course; compelling current events; special facilitator experience or expertise; or unanticipated disruptions to class session schedule.