PMBA 5140 - Data Bases 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. Open to PMBA majors only. Credit not allowed in both MGT 5140 and PMBA 5140.Differential Course Fee will be assessed. Business Graduate Course Fee will be assessed.Standard letter grade.