AEM 2820
Introduction to Database Management Systems
Introduces the principals and functions of relational database management systems (DBMS) and their business application. Students will explore both logical and physical database designs and develop a clear understanding of the concepts and terminology related to DBMS. A small relational database will be designed and students will learn to run SQL queries. Students will learn a set of skills to describe what happened in the past using queries, descriptive statistics, data visualization, and some data mining techniques. Excel add-ins and other DBMS software may also be employed.
Topics
- Discuss database management systems and design.
- Explain the terminology related to database management systems.
- Describe the design and implementation of a database management system.
- Execute queries using SQL syntax.
- Build models to solve real-world business problems.
- Demonstrate knowledge of skills for supporting the decision-making process.
Official roster learning outcomes
Prerequisites & course information
AEM 2010.
Sources
Catalogue variants
- Introduction to Database Management Systems · 3.0 · Undergraduate