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 (HA300v11)

GK# 0706 Vendor# HA300v11

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 SPS11.

Schedule

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

$

What You'll Learn

TOP
  • Develop information models in SAP HANA
  • Best practices for performance and flexibility
  • Approach SQL and SQLScript modeling
  • Implement system and objects security¬†
  • Restrict data access

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
  • Create Virtual Data Models with Core Data Services

5. Text, Spatial, and Predictive Modeling

6. Management and Administration of Models

  • Validate Information Models
  • Transport Information Models
  • Convert Deprecated Modeling Artifacts

7. Security in SAP HANA Modeling

  • Key Concepts of SAP HANA Security
  • Data Access Security

8. Optimization of Models

  • Best Practices
  • Performance of Models

Prerequisites

TOP
  • Basic knowledge of SAP HANA

Who Should Attend

TOP
  • Application consultant
  • Data consultant / manager
  • Database administrator

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