Back

Database Management for Policy Analytics

90-838

Units: 12

Description

This course on database management systems provides students in public policy and healthcare analytics with valuable, marketable skills for efficiently managing and analyzing data. Mastery of database systems is essential for transforming raw data into actionable insights, whether it is for driving public policy decisions or improving healthcare outcomes. By focusing on practical, hands-on experience with relational databases, this course ensures that students develop the expertise needed to excel in data-driven environments, making them more competitive in their respective fields.

Learning Outcomes

By the end of the course, students should be able to:

  1. Perform basic installation and configuration of database systems following step-by-step instructions.
  2. Describe the fundamental principles of the relational model and identify their applications in real-world data management context.
  3. Interpret the Entity-Relationship Diagram (ERD) of an existing relational database depicted in Unified Modeling Language (UML)
  4. Explain how business rules translate into an existing relational database design in a given real-world context and discuss its implications in the physical implementation of the database.
  5. Analyze a given data retrieval task in a given database and fulfill it by formulating database queries using appropriate Structured Query Language (SQL) constructs, including but not limited to:
    1. Logical operators
    2. Built-in functions (including analytic functions)
    3. Inner and outer joins
    4. Grouping and aggregation
    5. Subqueries
  6. Design conceptual database models using UML diagramming notation, translate conceptual models into logical models, and implement physical database designs with SQL.
  7. Develop user-defined functions and triggers in an RDBMS.
  8. Differentiate between relational and non-relational databases based on their intended purposes and design principles.
  9. Create simple queries using the MongoDB Aggregation Pipeline.

 

Prerequisites Description

Admission to the MSPPM-DA program

Syllabus