TypeOnline Course


Audience & Prerequisites

Course Outline

Schedule & Fees


SAP HANA Training

SAP HANA (high-performance analytic appliance) is an application that uses in-memory database technology that allows the processing of massive amounts of real-time data in a short time. The in-memory computing engine allows HANA to process data stored in RAM as opposed to reading it from a disk. This allows the application to provide instantaneous results from customer transactions and data analyses.


  • Monitoring and optimization of telecommunications network
  • Supply chain and retail optimization
  • Fraud detection and security
  • Forecasting and profitability reporting
  • Energy use optimization and monitoring

Intended Audience

  • Working in Corporate and Building Career in ERP Solutions
  • System Administrator
  • System Architect
  • Technology Consultant


Candidates should have should have basic knowledge of ERP.

Course Outline                                                  Duration: 10 Days

    1. Introduction and Background of SAP HANA
      • SAP HANA Technology
      • SAP HANA Performance Benchmarks
      • SAP HANA Roadmap and Re-thinking Software Development
      • SAP HANA in Practice and Summary
  2. Hana Administration
    1. Database Administration Tasks
      • SAP HANA Architecture
      • Administration Tooling
      • The SAP HANA Cockpit
    2. Registering Resources to Manage
    3. The SAP HANA Cockpit Manager
      • Resource Management and Monitoring
      • Configuration Management
      • Resource Groups
      • Managing Tenant Databases
    4. Monitoring
      • Security
      • Alert Management
      • Backup and Recovery
      • System Properties
      • Analyzing Memory Usage
      • Analyzing SQL Statements
      • Analyzing Workloads
      • Workload Capture and Replay
      • Analyzing Trace Files
  3. ABAP Meets SAP HANA: Evolution and Architecture
    1. SAP HANA Ambitions
      • Hardware & Software Innovations
      • Evolution of ABAP and SAP HANA
      • ABAP for SAP HANA Architecture
      • Highlights of SAP NetWeaver Application Server ABAP 7.4
    2. SAP HANA Native Application Basics
      • SAP HANA Application Development Tools
      • SAP HANA Software Downloads
      • Access to SAP HANA Systems (in the Cloud)
      • Example Application
      • Database Schemas and Database Tables
      • Sequences and SQL Views
      • Authorizations
      • EPM Demo Schema
      • Single File Data Load of CSVs
      • Attribute Views
      • Analytic Views
      • Calculation Views
      • Analytic Privileges
      • Introduction to SQLScript
      • Create an SQLScript Procedure with SELECT Statement
      • Create an SQLScript Procedure with Calculation Engine (CE) Functions
      • Create an SQLScript Procedure with Imperative Logic
      • Using the SQLScript Debugger
      • Exposing and Consuming Data – Architecture
      • SAPUI5
      • Creating a User Interface with SAPUI5
      • OData Services
      • Creating a Simple OData Service
      • Creating a Complex OData Service
      • Calling an OData Service from the User Interface
  4. ABAP Development for SAP HANA
    1. Existing Code: Is It Still Valid?
      • Existing Code: What About Performance?
      • SQL Footprints in Your Productive System
      • Guided Performance Analysis
      • Quick Wins: Optimized ALV and Other Improvements
    2. Recent Open SQL Enhancements – Part 1
      • Recent Open SQL Enhancements – Part 2
      • Core Data Services: What’s in It for You?
      • Core Data Services: View Definition
      • Core Data Services: Associations
      • Native SAP HANA Usage in ABAP
      • ABAP Managed Database Procedures
      • Domain-Specific Usage of Core Data Services
      • SAP BW and ABAP for SAP HANA: A Perfect Match
      • Looking Ahead
      • Lifecycle Management
      • AP HANA UI Integration Services
      • Wrap-Up
  5. High Availability and Disaster Recovery with the SAP HANA Platform
    1. Introduction
      • Overview
      • High Availability, Backup, and Disaster Recovery – Setup Options
      • System Replication
      • Continuous Log Replay Replication
      • Host Auto-Failover/Scale-Out, Storage Replication
      • Backups
      • Backup Options
      • Recovery Options

Course Duration: 10 Days

Please write to us at info@itstechschool.com & contact us at +91-9870480053 for the course price & certification cost, schedule & location

Drop Us a Query


For more info kindly Contact Us.