About This Course
Get up close and personal with two different database management technologies: relational and NoSQL. Through this course, students will discover the advantages and disadvantages of these two database technologies, as well as how to select the right one (or a combination of both) for an organization’s technology portfolio. Over the course of the semester, students gain hands-on experience with a relational database management system (MySQL) and two NoSQL database management systems (MongoDB and Neo4j), and an opportunity to research cutting-edge database management technology in a group project. Less about building database management systems from scratch, this course is more about the relative strengths and weaknesses of two dominant database types.
Sample course topics: Entity relation modeling, structured query language, key-value and column family, relational databases, advanced SQL, data warehouse, and distributed transaction management.
Sample textbooks: Database Systems: Introduction to Databases and Data Warehouses, Nenad Jukic, Susan Vrbsky, and Svetlozar Nestorov.
NoSQL Distilled: A Brief Guide to the Emerging World of Polyglot Persistence, Pramod J. Sadalage and Martin Fowler.
DBA, business administration, Metropolitan State University; MS, management of technology, University of Minnesota; BS, mathematics/computer science, Lawrence Technological University, Southfield, MI
Dr. Howey has worked in information technology and data management since 1975. At Univac Defense Systems (now Unisys), he developed software for real-time air traffic control and military command and control systems. Later, he was a data warehouse/business intelligence consultant for PricewaterhouseCoopers and IBM, among others. Most recently, he worked in enterprise architecture, information architecture, data warehousing/business intelligence, and data governance at Target and UnitedHealth Group. He has taught courses at Augsburg University and the Carlson School of Management. He is a Certified Data Management Professional (CDMP), a Certified Business Intelligence Professional (CBIP) and a Certified TOGAF 9 Enterprise Architect.
INet 4707 – Introduction to Databases