In this course you use analytical elements of SQL for answering business intelligence questions. You learn features of relational database management systems for managing summary data commonly used in business intelligence reporting. Because of the importance and difficulty of managing implementations of data warehouses, you also delve into storage architectures, scalable parallel processing, data governance, and big data impacts. In the assignments in this course, you can use either Oracle or PostgreSQL.

WHAT YOU WILL LEARN

• DBMS extensions, a review of schema patterns, data warehouses used in practice problems and assignments, and examples of data warehouses in education and health care.
• Extension of the SQL SELECT statement for subtotal operators.
• Extended processing model for SQL analytic functions that support common analysis in business intelligence applications.
• DBMS extensions for efficient query execution.

SKILLS YOU WILL GAIN

• Data Warehousing
• Materialized View
• Data Warehouse
• SQL