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