MGT 5140 - Databases and Data Warehouses

(3) Credit Hours

The course covers both operational and analytical databases and provides knowledge integral to being a successful data analyst in today’s business environment. The fundamental concepts related to operational databases include conceptual design (entity relationship diagram), logical design (normalization) and physical schema. The analytical data warehouse topics include star schema design for data warehouses and data marts. Extract, transform, and load (ETL) is also covered as a technique that ties operational data and data warehouses. The course discusses several database management systems and uses SQL to create and query databases and data warehouses. Restricted to MBA, MACC and MS Data Analytics or Business Analytics Post Baccalaureate Certificate. Credit not allowed in both PMBA 5140 and MGT 5140. Differential Course Fee will be assessed. Business Graduate Course Fee will be assessed.Standard letter grade.