SAP HANA NATIVE

Course Content:

1 Introduction to Modeling

2. SAP HANA Architecture

SAP HANA In-Memory Database

Columnar Data Storage

Parallel Processing

3. SAP HANA Database Architecture

4. Getting Started

Quick Tour: SAP HANA Modeler Perspective

Add a System

The Systems View

Information View Editor

5. Introduction to Database Tables

Fields classification (Attributes & Measures)

Key Fields, Primary Keys, Foreign Keys, Records(Rows), Fields (Columns), Values

6. Creating/Importing Table Definitions and Data

BODS,SLT,Flat File,SDA

7. Creating Information Views

Attribute Views (Standard, Time, Derived)

Analytic Views

Calculation Views (Graphical & Scripted)

8. Different Types of Joins and their differences

9. Working with nodes (Projection, Join, Union, Aggregation, Rank)

10. Calculated Columns & Restricted Columns

Different Functions in Calculated Columns

11. Filters, Variables and Input parameters

12. Dynamic Currency Conversions

13. LEVEL Hierarchy and PARENT-CHILD Hierarchy

14. SQL Statements

DDL (CREATE, ALTER, RENAME, DROP)

DML (SELECT, INSERT, UPDATE, DELETE)

DCL (GRANT, REVOKE)

Windows Functions (RANK, DENSE RANK, ROW NUMBER, LEAD, LAG, Cumulative SUM)

15. Sequences, Synonyms, Triggers, CDS Artifacts

16. Stored Procedures

17. Table Functions

18. Decision Tables

19. Analytic Privileges

20. XSODATA

21. Plan Visualization.

22. Performance Optimization

23. Different Options In HANA Studio

Delivery Units, Import/Export

Change Transport, Auto Documentation

Migration, Mass Copy, Schema Mapping, Generate Time Data

Label Mapping, Propagate Columns to Semantics

Show Lineage, Replacing Nodes and Data Sources.

Remaining Information Views and Columns.

Managing Object Versions.

24. A4O and SAP Lumira Reporting Tools

25. 4 Real time scenarios