SAP HANA Online Training Course Content

SAP HANA Online Training

SAP HANA Online Training

SAP HANA Online Training Overview

SAP HANA Introduction

  1. In-Memory Computing
  2. Evolution of In-Memory computing at SAP
  3. History HANA
  4. HANA Hardware Sizing
  5. Product Availability Matrix
  6. HANA compare to BWA

SAP HANA Overview

  1. Architectural overview
  2. Row Store
  3. Column Store
  4. Persist ency Layer

SAP HANA Versions and Studio overview

  1. SAP HANA Version
  2. History of Service pack details
  3. Studio Overview
  4. HANA Studio Preferences
  5. HANA Studio Prospective

SAP HANA Engines

  1. Column Store Engine
  2. Row Store Engine
  3. Join Engine
  4. OLAP Engines
  5. Calculation Engine

SAP HANA Modeling  Attribute View

  1. How to connect tables using
  2. Inner Join
  3. Left Outer Join
  4. Right Outer Join
  5. Full Outer Join
  6. Text Join
  7. Referential Join
  8. Union
  9. Filter
  10. Calculated Column

Analytic View

  1. Left Outer Join – Attribute View
  2. Inner Join – Analytical View
  3. Right Outer Join – Analytical View
  4. Referential Join – Analytical View
  5. Calculated Attribute
  6. Calculated Measure
  7. Restricted Measure
  8. Filter
  9. Variable
  10. Input Parameter

Tables in HANA

  1. Column Store Table
  2. Row Store Table
  3. Table Type

SQL in HANA

  1. Basic SQL Knowledge
  2. Select Statement
  3. From Clause
  4. Where Clause
  5. Group By clause
  6. Having Clause
  7. Order by Clause
  8. Top N clause

SQL Procedure in HANA

  1. How to create Procedure
  2. Elements of the Procedure
  3. Procedures using Column Store Views
  4. IF-ELSE Logic
  5. For Loop Logic
  6. Cursor in HANA
  7. Dynamic Filter

CE based Script in HANA

  1. CE_COLUMN_TABLE
  2. CE_JOIN_VIEW
  3. CE_OLAP_VIEW
  4. CE_CALC_VIEW
  5. CE_JOIN
  6. CE_LEFT_OUTER_JOIN
  7. CE_RIGHT_OUTER_JOIN
  8. CE_FULL_OUTER_JOIN
  9. CE_PROJECTION
  10. CE_CALC
  11. CE_AGGREGATION
  12. CE_UNION_ALL

Calculation View

  1. Calculation View Graphical Method
  2. Calculation SQL Script method
  3. How to call Calculation view using SQL into Calculation Views

Miscellaneous

  1. Delivery Units
  2. Transport Individual HANA Models
  3. How to load Excel data into HANA using Studio
  4. Export/Import
  5. How to create Sequence

Need for SAP HANA

Today, most successful companies respond quickly to market changes and new opportunities. A key to this is the effective and efficient use of data and information by analyst and managers

HANA overcomes the limitations mentioned below −

  • Due to increase in “Data Volume”, it is a challenge for the companies to provide access to real time data for analysis and business use.
  • It involves high maintenance cost for IT companies to store and maintain large data volumes.
  • Due to unavailability of real time data, analysis and processing results are delayed.