This SAP HANA Modeling (HA300) training course is built to be suitable for release HANA 1.0 SPS12 and also HANA 2.0 SPS01 audiences. This course teaches the core capabilities of SAP HANA for modeling, and covers mainly Graphical modeling, which is illustrated by the SAP HANA Live virtual data model, as well as SQL-based modeling, mainly table functions and procedures, with a focus on performance. This HA300 course also introduces Core Data Services as a flexible method to model a persistence layer. The participants will gain knowledge about the management of modeling content in the SAP Web IDE for SAP HANA, and the key principles of object and data access security in a modeling context. We also provide an overview of advanced data processing in the areas of text, spatial, predictive and graph modeling.
- SAP HANA Introduction (HA100)
HA300 - SAP HANA Modeling Training Delivery Methods
- Official SAP training curriculum
- Train your whole team by bringing this course to your facility
HA300 - SAP HANA Modeling Training Course Benefits
Develop information models following SAP best practices for maximum performance and flexibilityGet started with SQL and SQLScript based modelingManage projects and modeling content in the Web IDEImplement security and data access controls around SAP HANA data modelsGet started with advanced data processing such as text, spatial, predictive and graph
SAP HANA Modeling Training Outline
- Connect Tables
- Create Dimension and Cube Calculation Views
- Create Hierarchies
- Create Calculated and Restricted Columns
- Filter Data
- Use Variables and Input Parameters
- Implement Currency Conversion
- Use SAP HANA Live
- Overview of Virtual Data Models built with Core Data Services (CDS)
- Introduce SQL and SQLScript
- Create a Persistence Layer Using CDS
- Create Table Functions and Procedures
- Work with Modeling Content
- Create and Manage Projects
- Overview of classical models migration to Web IDE
- Understand the Key Concepts of SAP HANA Security
- Define Data Access Security
- Define Roles
- Apply Best Practices to Model Design
- Introduction to Performance and Analysis Tools
