SAP HANA Online Training Overview

SAP High-performance Analytic Appliance is an In-Memory Database from SAP to store data and analyze large volumes of non-aggregated transactional data in real time. Basically SAP HANA is a database. It addresses many problems which are being faced in the traditional databases through its In-Memory concept.

Disk I/O when a hard drive is used to store the data, CPU sits idle during the time the data is being written. Hence Disk I/O always causes performance bottleneck. Whereas In-memory storage overcomes this problem since the data is stored in RAM rather than hard drive. SAP HANA utilises this technology reducing the performance risk.

Hence for HANA to be installed, we need to have good hardware configuration – 40 cores and 512 GB RAM.

With SAP HANA you get the power to develop In-Memory apps that analyze massive volumes of data in real-time.

 SAP HANA has both OLTP and OLAP capabilities

OLTP:   Simple queries like INSERT, UPDATE, DELETE etc.

Returns few records

Does not require much processing time

OLAP:  Complex aggregations – sometimes combination of various OLTP queries

Returns huge number of records depending upon the data

Requires more processing time

EX: Data warehouses 

Course Highlights:

  • You are going to be given the newest coaching course material on SAP HANA covering time period examples
  • The Trainer for SAP HANA has real-time expertise and still has executed variety of real-time HANA primarily based projects
  • You are going to be given the newest interview queries by method of that you’ll simply crack an interview.
  • Real-time project in SAP HANA, which is able to successively boost your confidence by raising your technical talent set.
  • All the net coaching sessions are going to be conducted in an exceedingly step by step methodology ranging from the fundamentals and ending at advance topics in SAP HANA.  



  • Introduction
  1. Introduction to SAP HANA
  2. Entirely new Possibilities
  3. SAP’s In-Memory Offering
  4. Hana in contrast to SAP Applications
  5. Hana in Detail
  • Look & Feel
  1. Structure of In-Memory computing studio
  2. Administrative view
  3. Navigator view
  4. How to configure perspectives
  5. How to create a package
  • Architecture
  1. Architecture of Hana- overview
  2. IMCE and surroundings
  3. Row store and column store
  4. Loading Data
  5. Data modelling concepts
  6. Reporting
  7. Persistence Layer of Hana
  8. Concept of Back up and Recovery
  • Data Provisioning and Replication
  1. Replication Server, process and Architecture
  2. Data Services
  3. SAP BODS and HANA
  4. Basic data service connection types
  5. Data services 4.0
  6. Full extractor though ODP
  7. Configure import server
  8. Create and execute a data seervice job to populate HANA
  • Modelling
  1. Purpose of the Information Modeler
  2. Levels of Modeling in Hana
  3. Create and display data for Attribute view
  4. Create and display data for Analytical view
  5. Create and display data for Calculation view
  6. Purpose of Import/Export functionality
  • Reporting
  1. Connectivity options for reporting on top of Hana
  2. Understand the Business Objects BI 4.0 platform and reporting possibilities
  3. Set up various connectivity to Hana system for reporting
  4. Business objects BI 4.0 Explorer
  5. Business objects BI 4.0 Enterprise
  6. Crystal Reports via odbc/jdbc connections
  7. Others, Microsoft Excel connectivity
  8. Exercises
  • User Management
  1. User Creation
  2. Role Creation and Assignment
  3. Analytic view (Authorization) Creation
  4. Security details
  5. Privileges
  6. Exercises


Share on FacebookShare on LinkedInTweet about this on TwitterGoogle+