2023-2024 Academic Catalog

Dec 21, 2024

2023-2024 Academic Catalog [ARCHIVED CATALOG]

BAN 5501 - Database Management and SQL for Analytics

This course serves as an introduction and overview of the database management body of knowledge (DMBOK) from a managerial perspective. The learning objectives will be to acquire a comprehensive understanding of the basic concepts of database design and usage, as well as develop practical skills for utilizing databases to their fullest extent. Correct database design will be emphasized both as a theoretical foundation and a practical necessity.
The following topics are the focus of the course:
•   High-level, general database concepts and design
•   Design, create and manipulate an individual relational database including the utilization of SQL as a fundamental tool
•   Interpret and apply client database needs
•   Discuss and apply best practices of User Interface Design to database applications
•   Identify and discuss new developments and trends in databases including the use of data warehouses, data lakes and hubs, and X analytics.

Prerequisites: BAN 4500 (can be taken concurrently)

*This prerequisite does not apply to MSAA students.

Anticipated Terms Offered: Annually