Course offer

Newsletter




Course code: HA300« Back

SAP HANA Implementation and Modeling

In this course, you will develop advanced SAP HANA modeling skills, so that you are able to create sophisticated and high performance information views, which can expose data to applications and report consumers.

Previous courses

 DateDurationCourse priceHandbook priceCourse languageLocation 
11/25/2019 5 65 000 CZK included in course price Český jazyk Praha - SAP
 

AffiliateDurationCatalogue priceHandbook priceITB
Praha5 65 000 CZK included in course price 0
Bratislava5 1 920,00 EUR - 0

Previous courses

Goals

  • 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

    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
  • 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
    Příručka SAP

    Price:
    included in course price
    The prices are without VAT.