Course Content - SAP Native HANA Online Training

1. HANA as Database

1.1 Introduction to HANA Database and Architecture:

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

1.2 SQL programming –Coding:

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

1.3 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.

2. HANA as ETL and Data Warehousing

2.1 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 persistence

2.2 Modelling:

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


3. HANA as in for BW4 HANA and S4 HANA

3.1. BW/4 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.

3.2.   S/4 HANA Analytics

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

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

 4.1. 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.

 4.2. Node JS module and Web module

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

Share this with your friends:

Faculty Registration

Student Registration