SAP HANA Modeling

COURSE DETAILS


Code: HA300-v012
Tuition (USD): $3,350.00 • Virtual (5 days) - $3,350.00 • Classroom (5 days)




Skills Gained
• 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

Who Can Benefit
• Business application consultant
• Data Consultant / Manager
• Database Administrator
• Application developer
• BI specialist

Prerequisites
• Essential:
-HA100 - SAP HANA Introduction

• Recommended:
-None

Course Details

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

Course based on software release

• SAP HANA SPS12