SAP HANA Training

HANA Course Reviews

The course is practical oriented. Good place for learning.

DevOps Course Content

In-memory database management overview

• OLTP vs. OLAP
• Dictionary encoding & compression, data aging, data layout in memory, merge, join, Scan performance, Aggregate Functions, Database Indices, Parallel Data Processing
• Logging and Recovery (Logging for Dictionary-Encoded Columns), Replication
• Data aging (Data Aging vs. Data Archiving and Hot data vs. cold data)

Introduction to SAP HANA

• SAP HANA Overview
• Why to Choose SAP HANA?
• SAP HANA Hardware Partners
• SAP HANA Landscape
• Get Free Access to SAP HANA Server

SAP HANA Architecture

• SAP HANA Architecture Overview
• Advance Information on SAP HANA Architecture
• 2.3 Row Store Vs Column Store
• 2.4 SAP HANA Backup and Recovery

SAP HANA Studio

• SAP HANA Studio Overview
• Download and Install SAP HANA Studio
• Add an HANA System in SAP HANA Studio
• SAP HANA Studio Perspectives

Reporting on SAP HANA

• Reporting on SAP HANA - Overview
• Using Excel for Reporting on SAP HANA

SAP HANA Advanced Modelling

• Create advanced data models in HANA
• Work on SQL Script and Procedure
• Understand how views and procedures work behind the scene
• Create Analytic Privilege to secure the modelling views
• Do performance tune of the modelling views and procedures

SAP HANA Modelling

• SAP HANA Modelling Introduction
• Introduction to Star Schema
• Attributes and Measures in SAP HANA
• Working with Tables
• Attribute View
• Build Your First Attribute View
• Analytic View Overview
• Build Your First Analytic View
• Overview of Calculation View
• Build Your First Graphical Calculation View
• Build Your First Scripted Calculation View
• Modeller Perspective Revisited

ABAP for SAP HANA Development

• SAP HANA Overview & architecture, Row Store vs. Column Store
• SAP HANA Backup and Recovery, SAP HANA Modelling, Star Schema
• Attributes and Measures in SAP HANA (Attribute view, analytic view, calculation view)
• SAP HANA Studio & Eclipse IDE (Different prospective)
• ABAP Dictionary Enhancements, Data Type Systems, Database Schemas
• When to Use Columnar Storage? And When to Use Row Storage?
• ABAP Dictionary (Database-Specific Properties and Database-Specific Indices)
• advanced Search Helps (Type ahead and fuzzy)
• Recent Open SQL Enhancements (Syntax and select list)

Migration to SAP HANA

• Code-To-Data Paradigm - (HANA specific features – DB procedures & Native SQL, DB oriented programming - open SQL & advanced views)
• Existing code: Migrating to HANA (Detect > modify > explore)
• Holistic tools for quality assurance of ABAP code (ATC, SAT or ABAP Profiler, SQL Monitor - SQLM, SQL Performance Tuning Work list – SWLT)

On Demand

• More advanced concepts
• CDS Views (SP11 and SP12)
• CDS annotations
• Creating FIORI application using CDS views
• Creating list view, transactional apps using CDS view
• BOPF framework
• XS Advanced
• Server Side JS – XSJS: Creating, Extending, Calling, Debugging
• Web based HANA development
• UI5 Development
• Browser based IDEs (HCP, WEB IDE)
• HANA SP11 and SP12 features
• UI5 and FIORI design using BUILD and WEBIDE
• Introduction to HANA cloud platform(HCP) and cloud appliance library(CAL)

Modelling Views

Analytic Privilege

System Schemas and Their Importance

SQL Script

Procedure

HANA Performance Guidelines