sap all online training contact numbers

SAP HANA Online Training

SAP HANA is an in-memory database management system, wherein HANA stands for ‘High-Performance Analytic Appliance’. It is designed to maintain transactional processing and real-time analytics. In this module, the in-memory computing engine permits HANA to process the data that is stored in RAM rather than reading it from a disk. This in turn will allow providing instant results from data analysis and customer transactions. SAP HANA can either be installed on-site as an appliance or can also be purchased as a cloud service. This module helps data analysts to inquire large volumes of data in real-time scenario. Another powerful feature of this module is that it can process huge quantities of data in real-time scenario. This platform can evaluate huge quantities of data in local memory so that ultimately the outcome of this analysis and transactions can help you make better business decisions. Some of the core concepts covered in this module are Introduction to SAP HANA, Installation, Implementation and modeling, data provisioning, in-memory computing concepts, architecture overview etc.


  • Basic knowledge of database technologies.

Why Choose Us?

SAPAllOnlineTraining is devoted to offer you the best training not only in terms of learning the core concepts of HANA, but also providing you seamless support as and when required. We have already conducted a decent number of batches for this module, and have got a good response for our training efforts. With a team of HANA trainers who are not only skilled but also have relevant experience in executing HANA projects, we assure you that you will be able to reap the full benefits of SAP HANA Online training program conducted by SAPAllOnlineTraining.With a keen insight as to how this module is being implemented real-time in various organizations worldwide, we will see to that you will understand the technology from an industry point of view. Rest assured you will get a detailed course material that includes a step-by-step explanation for you to understand the technology in-depth. We believe in a win-win situation and hence will see to that our candidates should obtain the maximum benefit of our training programs and at the same time our team should also feel content that they have satisfied their candidates by offering valuable services.

SAP HANA Online Training Course Contents

Duration: 5 – 6 Weeks


  • “An in-memory ` database is a database management system that primarily relies on main memory for computer data storage”.

SAP HANA is SAP AG’s implementation of in-memory database technology. Following are the components related to SAP HANA

  • SAP HANA DB refers to the database technology itself,
  • SAP HANA Studio refers to the suite of tools provided by SAP for modeling,
  • SAP HANA Appliance refers to HANA DB as delivered on partner certified hardware as an appliance. It also includes the modeling tools from HANA Studio as well replication and data transformation tools to move data into HANA DB,

What is HANA?

HANA (High performance Analytical Appliance) is a new In-Memory data management appliance released by SAP which is more of separate plug-in (Software & Hardware) for faster analytical activities. This application allows processing of massive quantities of real time data in the main memory of the server to provide immediate results for analysis.

HANA is a pre-configured analytic appliance. SAP’s hardware partners provide the hardware and pre-install the SAP in-memory solution on that hardware.

Why HANA ?

  • While HANA has been called variously an acronym for Hasso’s New Architecture (a reference to SAP founder Hasso Plattner)
  • High Performance Analytic Appliance.
  • HANA is a name not an acronym.

Course Out Line – SAP HANA 1.0


  •  Introduction to SAP HANA
  • SAP In-Memory Strategy
  • HANA compare to BWA

In-Memory Computing, Big Data and SAP HANA

  • Introduction to In-Memory Computing and Big Data
  • In-Memory Computing and Analytics
  • Big Data Introduction
  • Introduction to SAP HANA
  • SAP HANA as in In-Memory Computing Solution
  • SAP HANA as an Enabler of Big Data Solutions
  • SAP HANA Capabilities
  • SAP HANA Database Concepts…..
  • Impact of Modern Hardware on Database System Architecture.


  • Hana Engine Overview
  • IMCE surroundings
  • Different HANA Engine Types
  • Row Store
  • Column Store
  • Persistency Layer
  • Business Impact of new architecture
  • Columnar and Row-Based Data Storage
  • Advantages of Columnar Tables

Data Modeling with SAP HANA Studio

  • SAP HANA Studio Overview and Terminology
  • Getting Started with SAP HANA Information Modeler
  • Adding a System
  • Opening Perspectives
  • Using Quick Launch
  • Creating a Package
  • Example Scenario
  • Building Attribute Views
  • Creating an Attribute View
  • Defining Table Joins 4
  • Defining Output
  • Checking, Saving, and Activating Views
  • Creating the Time Attribute View
  • Building Analytic Views
  • Creating an Analytic View
  • Copying an Analytic View
  • Building Calculation Views Using the Graphical Method
  • Implement information models in SAP HANA

Advanced Concepts in SAP HANA Studio

  • Derived Attribute Views
  • Calculated Attributes
  • Restricted and Calculated Measures
  • Filter and Variable Operations
  • Filters
  • Variables and Input Parameters
  • Currency Conversion
  • Creating a Leveled Hierarchy
  • Creating a Parent-Child Hierarchy
  • Processing Content Objects
  • Previewing Data of Content Objects
  • Validating Models
  • Comparing Versions of Content Objects
  • Viewing Version History of Content Objects
  • Switching Ownership of Inactive Objects
  • Generating Object Documentation
  • Enabling Multilanguage Support for Objects
  • Checking Model References
  • Viewing the Job Log
  • Personalizing Studio
  • Versioning
  • Checking Model References
  • Customizing Perspectives


  • Introduction to SQL script and script based calculation views 5
  • Using SQL & Using SQLScript
  • Using SAP HANA Studio to Execute SQL and SQLScript Statements
  • Table Type Definition
  • INSERT, UPDATE, DELETE statements
  • Data definition and access control
  • Data Types
  • Renaming Columns
  • Functions & Expressions
  • Procedures introduction
  • Writing procedures
  • Procedure Calls

Data Provisioning

  • Choosing a Data Provisioning Method
  • Strategic Considerations
  • Technical Considerations

Option 1: Trigger-Based Replication: SAP Landscape Transformation

  • How SLT Works
  • SLT Configuration
  • SLT Administration (Start, Replicate, Stop, Suspend,Resume)
  • Extended Features

Option 2: ETL-Based Replication: SAP Data Services

  • Preparing SAP HANA to Receive Data from SAP Data Services
  • Loading Data

Option 3:Log-Based Replication: Sybase Replication Server and Load Controller

Option 4: Direct Extractor Connection

  • DXC Technology
  • Important Considerations for the Use of DXC 6


  • SAP HANA and the SAP BusinessObjects BI Platform
  • Overview of the SAP Business Objects Tools
  • SAP Business Objects Dashboards (Xcelsius) .
  • SAP Business Objects Web Intelligence
  • SAP Business Objects Explorer
  • SAP Business Objects Analysis
  • SAP Business Objects Design Studio
  • SAP Crystal Reports
  • Connecting SAP Business Objects BI Tools to SAP HANA
  • Universes with Open and Java Database Connections (ODBC/JDBC)
  • IDT Access to Attributes, Calculations, and Analytical Views
  • Connecting to Excel with Open Database Objects (ODO) and MDX
  • BICS Connections
  • Connectivity Summary

User Management & Administrator

  • Security
  • Creating Users
  • Creating Roles
  • Privileges
  • User Administration 7

Hot Topics

  • BW 7.3 powered by HANA Overview
  • Business Suite on HANA Overview
  • Rapid Deploy Solutions Overview
  • HANA Innovations
  • Information Composer
  • Exercises


  • Steps:
  • Provisioning the relevant tables
  • Creating attribute view, analytic view & calculation views for COPA Model
SAP is a registered trademark of SAP AG. is not endorsed by or affiliated with SAP AG or any of its subsidiaries