SAP Native HANA Course Content

Course Overview:

Course Name               SAP Native HANA 
Demo Classes              On Demand
Mode of Classes          Online
Course Duration          40-45 Hours
Class Availability        Weekdays & Weekends
Demo Training            Email ID :

Native HANA means it is something build on top of the HANA BOX and it can have the full HANA performance and benefits and there is another term called non-native HANA applications which means the developments done using other technologies can also run on top of HANA, like .net, java applications.

The term HANA enterprise is related to the release like HANA platform edition, enterprise edition and enterprise extended edition.


HANA as Database

Introduction to HANA Database and Architecture.

  • HANA Servers, Engines and Data base versions.
  • HANA Studio, HANA Web Workbench.
  • Design and run time objects, Schema, Content and different prospective.
  • XS classic and XS Advanced.

SQL programming– Coding

  • SQL syntax for Creating Tables and Views.
  • Insert, update and delete data using SQL
  • Partitioning, Compression and Indexing.
  • Synonyms, Data base Triggers and Sequences.
  • SQL Queries, Sub Queries or nested.
  • Joins, Union, Aggregation, Rank and Partition

SQL Scripting

  • Standard SQL functions, Custom functions
  • Stored Procedures
  • CURSOR processing
  • If then else and CASE statement.
  • While loop and For Loops.
  • Exception Handling
  • Dynamic SQL
  • SQL Code debugging.
  • Performance optimization of code.

HANA as ETL and Data Warehousing

Data Provisioning

  • BO Data Services, Data flows.
  • Smart Data Access (SDA)
  • Smart Data Integration (SDI)
  • ETL using SQL code
  • Flow Graphs and Replication tasks.
  • Core Data Services for data persistency


  • Calculation views
  • User Defined Table functions.
  • Performance Optimization of the views.
  • Decision tables
  • Text analysis
  • HANA Security, Analytical Privileges.

HANA as in for BW4 HANA and S4 HANA


  • HANA Optimized Cubes.
  • Advanced DSO, Open ODS view and Composite Providers.
  • SAP Classic object migration, Performance optimization projects.
  • HANA Query Designer.
  • Mixed approaches with Native HANA.

S/4 HANA Analytics

  • Core Data Services, Data persistency and Consumption.
  • ABAP CDS Views for analytics.
  • Embedded analytics in OData browser.

HANA 2.0 SP 2, XS Advanced, using Web IDE for HANA

Database module

  • HANA Express Edition on Google Cloud platform.
  • XS commands in Secure Shell (SSH)
  • HDI container, Database module deployment.
  • Synonyms to access Classical schema.
  • CDS artifacts
  • ETL Flow graphs in Web IDE for HANA.
  • GitHub Integration for Source control.

Node JS module and Web module

  • Workshop on a complete native Object development.
  • Server side Java Script or Node JS.
  • OData Services to provide the data access.
  • Web module development for user applications.