Advanced SQL and Data Warehousing

Data mining and data warehousing are essential in business decision-making in an increasingly competitive information age. This course teaches students concepts, methods, and skills for working with data warehouses and mining data from these warehouses to optimize competitive business strategies. In this course, students develop analytical thinking skills required to identify effective data warehousing strategies, such as when to use outsourced or in-source data services. Students also learn to Extract, Transform and Load data into data warehouses (the ETL process.) and use the CRISP approach to data mining to extract vital information for data warehouses. The course also teaches students how to secure data and covers the ethical issues associated with data and data models for business decisions.