AEM 2820

Introduction to Database Management Systems

Course Description

Course information provided by the Courses of Study 2020-2021.

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.

When Offered Fall.

Permission Note Enrollment preference given to: Dyson students.
Prerequisites/Corequisites Prerequisite: AEM 2010.
Forbidden Overlaps Forbidden Overlap: due to an overlap in content, students will receive credit for only one course in the following group: AEM 2820, HADM 3740, HADM 6740.

• 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.

View Enrollment Information