SAP HANA Modeling

SAP HANA Modeling
Certification Training

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
Click here for more information