Location
Location

Uppal Hyderabad

Location
Phone

+91 70934 77157

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