Back

Introduction to Database Management

90-728

Units: 6

Description

This introductory database course with a focus on SQL offers vital technical skills for transforming complex data into actionable insights, a key competence across various disciplines including public policy management and arts and entertainment management. SQL skills enable public policy professionals to analyze societal data effectively, aiding in impactful policy-making. Similarly, in arts and entertainment management, SQL proficiency is key for managing data on productions and audience trends, supporting strategic decisions.

Learning Outcomes

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

  1. Install and configure a simple database system 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 basic and intermediate database queries using appropriate Structured Query Language (SQL) constructs, including:
    1. Logical operators
    2. Built-in functions
    3. Inner and outer joins
    4. Grouping and aggregation
    5. Subqueries

Prerequisites Description

No pre-requisites.

Syllabus