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 relationships between data in different tables using the relational schema and data dictionary of an existing database, and identify the information needed to address specific questions in the given business context.
4. 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

• Syllabus (Xiaoying Tu - S26)