Live Chat
Monday - Friday 8am - 6pm EST Chat Now
Contact Us
Monday - Friday 8am - 8pm EST 1-866-716-6688 Other Contact Options
Checkout

Cart () Loading...

    • Quantity:
    • Delivery:
    • Dates:
    • Location:

    $

SAP HANA Modeling (HA300v12)

Develop advanced SAP HANA modeling skills.

GK# 0707 Vendor# HA300v12

Course Overview

TOP

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.

This course is based on software release:

  • SAP HANA SPS12

Schedule

TOP
  • Delivery Format:
  • Date:
  • Location:
  • Access Period:

$

What You'll Learn

TOP
  • Develop information models following SAP best practices for maximum performance and flexibility
  • Advanced data processing such as text, spatial, predictive and graph
  • SQL and SQLScript based modeling
  • Implement security and data access controls around SAP HANA data models

Outline

TOP
Viewing outline for:

Classroom Live Outline

1. Information Views

  • Connect tables
  • Create dimension and cube calculation views

2. Modeling Functions

  • Create hierarchies
  • Create calculated and restricted columns
  • Filter data
  • Use variables and input parameters
  • Implement currency conversion
  • Create decision tables

3. SQL Script and Procedures

  • Introduce SQL and sqlscript
  • Create table functions and procedures
  • Use the SQL debug tools

4. Virtual Data Models in SAP HANA

  • Use SAP HANA live
  • Virtual data models built with core data services (cds)

5. Text, Spatial, Predictive and Graph Modeling

6. Management and Administration Of Models

  • Validate information models
  • Transport information models
  • Rename, copy move models
  • Schema mapping
  • Convert deprecated modeling artifacts using migration tools

7. Security in SAP HANA Modeling

  • Key concepts of SAP HANA security
  • Data access security

8. Optimization of Models

  • Best practices to model design
  • Plan visualizer and explain plan tools

Prerequisites

TOP
  • Basic knowledge of SAP HANA
  • The HA100 course provides a good understanding of SAP HANA and it is mandatory for participants who want to attend this course
  • Basic knowledge of row and column table storage
  • First experience in data modeling
  • Basic SQL knowledge
  • Basic understanding of SAP Business Objects BI products

Who Should Attend

TOP
  • Business application consultant
  • Data consultant / manager
  • Database administrator
  • Application developer
  • BI specialist

Follow-On Courses

TOP
Course Delivery

This course is available in the following formats:

Classroom Live

Receive face-to-face instruction at one of our training center locations.

Duration: 5 day

Virtual Classroom Live

Experience expert-led online training from the convenience of your home, office or anywhere with an internet connection.

Duration: 5 day

Request this course in a different delivery format.
Enroll