Database Management for Business Analytics. 3 credits

Catalog description

Business analytics relies on wide variety of datasets that are maintained transactional databases and/or analytical data sources such as a data warehouse. This course familiarizes the use of Structured Query Language (SQL) to manage data in transactional databases. SQL coverage includes how to extract data, join tables, aggregations, and perform more complex analysis and data manipulations using subqueries. The course also introduces students to managing and working with analytical data using data warehouse, data cubes, analytical processing of historical data for dimensional analysis and preparation of data for data mining. Offered by Costello College of Business . May not be repeated for credit.