DATABASE & WAREHOUSE SYSTEM (3/1 Credits)

Learning Outcomes :

On successful completion of this course, student will be able to: Describe the basic concept of data warehouse, data architecture, data warehouse design methodology; design Entity Relationship Diagram, cardinalities, relationship, and normalization; demonstrate database system, querying, and data cleaning, analyze usiness Requirement Specification.

Topics :

Introduction to Data Warehouse, Data Warehouse Architecture & Methodology, Requirement Specification, Conceptual Database Design, Logical Database Design, Normalization, Early Project Discussion – Requirement Spec & Conceptual, Physical Database Design, MySQL Workbench Database Development, Introduction to SQL, Filtering SQL, Aggregating in SQL, Sorting and Grouping SQL, Case Study Observation, Joining Data in SQL, OLAP (Online Analytical Procressing), Missing Values Handling, Data Analysis in Data Warehouse, Case Study Discussion, Conceptual Database Design, Physical Database Design, Physical Database Design, MySQL Workbench Study Case, Early Project Presentation, SQL: Filtering & Aggregating Data, SQL: Sorting & Grouping Data, Data Transformation, Data Analysis in Data Warehouse, Business Intelligence Dashboard Development, Supply Chain Dashboard Development, Final Project Discussion, Final Project Presentation