SAP HANA Modeling
Area of Interest: Modeling, Development, Industry Solutions
Software Solution: SAP HANA, HANA Programming, SAP Data Science
Course Objectives
This course will prepare you to:
- Develop information models following SAP best practices for maximum performance and flexibility
- Get started with advanced data processing such as text, spatial, predictive and graph
- Get started with SQL and SQLScript based modeling
- Implement security and data access controls around SAP HANA data models
Target Audience
- Business application consultant
- Data Consultant / Manager
- Database Administrator
- Application developer
- BI specialist
Prerequisites
Essential
HA100 – SAP HANA Introduction
Recommended
None
Course based on software release
SAP HANA SPS12
Course Content
Information Views
- Connect Tables
- Create Dimension and Cube Calculation Views
Modeling Functions
- Create Hierarchies
- Create Calculated and Restricted Columns
- Filter Data
- Use Variables and Input Parameters
- Implement Currency Conversion
- Create Decision Tables
SQL Script and Procedures
- Introduce SQL and SQLScript
- Create Table Functions and Procedures
- Use the SQL Debug Tools
Virtual Data Models in SAP HANA
- Use SAP HANA Live
- Overview of Virtual Data Models built with Core Data Services (CDS)
Text, Spatial, Predictive and Graph Modeling
Management and administration of Models
- Validate Information Models
- Transport Information Models
- Rename, copy move models
- Define schema mapping
- Convert Deprecated Modeling artifacts using migration tools
Security in SAP HANA Modeling
- Understand the Key Concepts of SAP HANA Security
- Define Data Access Security
Optimization of Models
- Apply Best Practices to Model Design
- Introduction to Plan Visualizer and Explain Plan tools
Training Schedule
| Batch: | Online Option | ||||
| Delivery Type: | Online | Register R 42,625 | |||
| Professionals | One Year | English | |||
| Batch: | February 2018 | ||||
| Address: | 5, Prince Adelowo Adedeji Street, Peninsula, Phase 1, Lekki | ||||
| State: | Lagos | R 36,375 | |||
| Delivery Type: | Sap Academy | Register | |||
| Professionals | 12th Feb 2018 - 16th Feb 2018 | English | |||
| Batch: | April 2018 | ||||
| Address: | 5, Prince Adelowo Adedeji Street, Peninsula, Phase 1, Lekki | ||||
| State: | Lagos | R 36,375 | |||
| Delivery Type: | Sap Academy | Register | |||
| Professionals | 9th Apr 2018 - 13th Apr 2018 | English | |||
| Batch: | May 2018 | ||||
| Address: | 5, Prince Adelowo Adedeji Street, Peninsula, Phase 1, Lekki | ||||
| State: | Lagos | R 36,375 | |||
| Delivery Type: | Sap Academy | Register | |||
| Professionals | 7th May 2018 - 11th May 2018 | English | |||
| Batch: | October 2018 | ||||
| Address: | 5, Prince Adelowo Adedeji Street, Peninsula, Phase 1, Lekki | ||||
| State: | Lagos | R 36,375 | |||
| Delivery Type: | Sap Academy | Register | |||
| Professionals | 22nd Oct 2018 - 26th Oct 2018 | English | |||