This course will provide you with an overview and practical introduction to the methodology and tools to develop a custom SQL-based data warehouse.
2,000+ Free Courses with Certificates: Coding, AI, SQL, and More
The Most Addictive Python and SQL Courses
Overview
Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
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