This course will provide you with an overview and practical introduction to the methodology and tools to develop a custom SQL-based data warehouse.
Overview
AI, Data Science & Cloud Certificates from Google, IBM & Meta — 40% Off
One plan covers every Professional Certificate on Coursera. 40% off Coursera Plus Annual.
Unlock All Certificates
Syllabus
- Choosing SAP HANA to Build a Data Warehouse
- Describing a Custom SQL Data Warehouse
- Describing the Key Features of SAP HANA
- Outlining the SAP HANA Development Environment
- Getting Started with a Development Project
- Choosing SAP HANA to Build a Data Warehouse
- Designing the Data Warehouse
- Choosing a Reference Data Warehouse Architecture
- Selecting a Modeling Approach
- Designing the Data Warehouse
- Implementing the Data Warehouse
- Implementing the Data Warehouse Architecture in SAP HANA
- Loading Data from External Schemas
- Defining Tables in the Data Warehouse
- Working with Flowgraphs
- Developing the Persistent Layers of the Data Warehouse
- Developing the Virtual Layers of the Data Warehouse
- Moving the Data Warehouse to Production
- Implementing the Data Warehouse