This advanced course will provide students with an in-depth understanding of the design and implementation of database warehousing and analytics database systems. Specific topics include data warehouse modeling and architecture, the ETL process, administration, security, column-store, streaming and NoSQL databases, and complex event processing. Students develop a complete data warehouse system including implementation of a business intelligence suite.
Prerequisite: CIS 3400 and (ZICK or ZKTP Student Group) and (have ZK4L or ZK4P student group: BBA majors must have completed courses listed here, https://zicklin.baruch.cuny.edu/4000-and-above-bus-course-enroll-criteria).