SAP Training : Powering-Up for SAP HANA

Powering-Up for SAP HANA (HANA 1.0 SPS05)

SAP Training Overview

This course is about SAP HANA SPS05. Combining the important topics from four SAP courses, we have created one 4 day high intensity learning experience. Through lectures and labs, we explore the HANA architecture, data structures, indexes and new SPS05 features. The students will use HANA, model tables and views, program with SQLScript while learning how and when to index as well as control data consistency. HANA tools will be used for programming, quering, monitoring, evaluating query performance and adminstration.

SAP Training Audience

This course is for developers who want to learn SAP HANA.

SAP Training Prerequisites

Basic database knowledge

SAP Training Objectives

Upon completion of this workshop, the participant will be able to:

Review Environment, Hardware and HANA Concepts
Use High-Performance Analytic Appliance
Understand HANA Architecture
Access SAP HANA in the Cloud
Use the HANA Tools
Dissect HANA Data Structures
Model HANA Applications
Understand Index Creation and Use
Explore HANA Queries
Explain Query Performance
Learn to Control Transactions
Move Data into and out of HANA
Setup Security
Backup a HANA database
Optional: Review ABAP, BW, ERP(ECC) on HANA

SAP Training Course duration

4 Days, Lecture and Labs

SAP Training Course outline

NOTE: Detailed topic outline upon request

    1. Overview and Concepts

    2. HANA Tools

    3. Architecture/Internals

    4. HANA in the Cloud

    5. HANA SQL

    6. Data Structures

    7. Indexes

    8. Modeling

    9. Attribute Views

    10. Analytic Views

    11. Calculation Views

    12. SQLScript Programming

    13. Explain Plan

    14. Query Optimization

    15. Transactions

    16. Moving Data, Provisioning

    17. Scaling Out

    18. Security

    19. Monitoring, Traces

    20. Backup, Recovery, Availability

    Appendix (Options)

       A1. R Language on HANA

       A2. ABAP on HANA

       A3. SAP BW 7.3 on HANA

       A4. SAP ERP 6.0 on HANA