Call Us: +91-9000011489

Register for Free Demo

1 What is SAP HANA…?

2 Why is SAP HANA so FAST…?

3 SAP HANA Architecture

  • Understanding about Index Server & Engines

4 Discussion on SAP HANA Use Cases

5 Introducing SAP HANA Studio

6 SAP HANA Database Concepts

  • Schema
  • Database Tables – Column Store & Row Store
  • Database Views
  • Synonyms
  • Triggers
  • Sequences
  • Table-UDF (User Defined Functions)
  • Introduction to Stored Procedures
  • Introduction to Table Types
  • Column Views

7 Basic SQL

8 Stored Procedures

  • Simple Stored Procedures
  • Looping Statements
  • Conditional Statements
  • Using Arrays
  • Using Cursor
  • Using Temp & Table Types
  • Stored Procedures with Column Views
  • Using SQL Functions
  • Using CE-Functions
  • Debugging Stored Procedures

9 SAP HANA Modeling

  • Understanding Different Types of Joins in SAP HANA
  • Left Outer, Inner, Right Outer, Referential, Temporal, Text, Spatial Attribute View
  • Standard Attribute View
  • Time Based Attribute View
  • Derived Attribute View
  • Creating Calculated Column
  • Creating Hierarchies in Attribute Views
  • Dynamic Filter -Using Input Parameters
  • Enabling Attributes View for Time Travel Queries by using History Tables

10 Analytical View

  • Understanding STAR Join Node
  • Creating Calculated Columns & Measures
  • Restricted Columns
  • Counters
  • Input Parameters
  • Variables
  • Semantics
  • Analytical View Properties
  • Focusing on Temporal Join in Analytical View
  • Mapping of Input Parameters

11 Calculation View

  • Understanding Calculation View Properties
  • SQL Scripted Based & Graphical Mode
  • Understanding Different Nodes in Calculation View
  • Projection
  • Aggregation
  • Join
  • Union
  • Rank
  • Understanding Dynamic Join
  • Understanding KEEP FLAG property
  • Understanding TRANSPARENT Filter Property
  • Understanding STAR Join Node
  • Creating Calculated Columns & Measures
  • Restricted Columns (Dynamic with Input Parameters)
  • Counters
  • Input Parameters
  • Variables
  • Semantics
  • Extract Semantics
  • Creating Hierarchies in Calculation View
  • Processing of HANA Models

12 Analytical Privileges

  • Static
  • Dynamic with Stored Procedures

13 Decision Tables

  • Updating
  • What if Analysis