Course Code	Description
HA100	SAP HANA – Introduction
HA300	SAP HANA - Implementation and Modeling
HA400	ABAP Programming for SAP HANA
E_HANAAW_12	SAP Certified Development Specialist - ABAP for SAP HANA (Edition 2016)

HA100-SAP HANA – Introduction

• Describing SAP HANA

  • Understanding the Need for a Modern Digital Platform
  • Describing how SAP HANA Powers a Digital Platform

• Architecture of SAP HANA

  • Outlining Components of SAP HANA
  • Working with SAP HANA interfaces
  • Understanding Key Features of SAP HANA Database
  • Understanding Run-Time and Design-Time Architectures
  • Describing High Availability
  • Describing Security Features of SAP HANA

• Analytical Processing with SAP HANA

  • Understanding Core Modeling with SAP HANA
  • Understanding Virtual Data Models with SAP HANA
  • Defining SAP HANA Spatial Processing
  • Defining Text Analytics
  • Explaining Predictive Modeling
  • Describing Graph Processing

• Data Management with SAP HANA

  • Describing Data Management
  • Describing Data Acquisition Tools
  • Describing SAP HANA Vora

• Powering Applications with SAP HANA

  • Describing the Types of Applications you can run on SAP HANA
  • Running SAP Enterprise Suites on SAP HANA
  • Connecting SAP Business Intelligence Tools to SAP HANA
  • Outlining SAP Business Warehouse on SAP HANA
  • Describing SAP HANA Data Warehousing Foundation
  • Building Native HANA Applications

• Appendix: Continuing your SAP HANA Learning Journey

HA300-SAP HANA - Implementation and Modeling

• Information Views

  • Connect Tables
  • Create Dimension and Cube Calculation Views

• Modeling Functions

  • Create Hierarchies
  • Create Calculated and Restricted Columns
  • Filter Data
  • Use Variables and Input Parameters
  • Implement Currency Conversion
  • Create Decision Tables

• SQL Script and Procedures

  • Introduce SQL and SQLScript
  • Create Table Functions and Procedures
  • Use the SQL Debug Tools

• Virtual Data Models in SAP HANA

  • Use SAP HANA Live
  • Overview of Virtual Data Models built with Core Data Services (CDS)

• Text, Spatial, Predictive and Graph Modeling

• Management and administration of Models

  • Validate Information Models
  • Transport Information Models
  • Rename, copy move models
  • Define schema mapping
  • Convert Deprecated Modeling artifacts using migration tools

• Security in SAP HANA Modeling

  • Understand the Key Concepts of SAP HANA Security
  • Define Data Access Security

• Optimization of Models

  • Apply Best Practices to Model Design
  • Introduction to Plan Visualizer and Explain Plan tools

HA400-ABAP Programming for SAP HANA

• Introduction

  • Understanding SAP HANA and how it impacts the ABAP development paradigm
  • Introduction to ABAP Development Tools (also known as ABAP in Eclipse)

• Taking ABAP to SAP HANA

  • Accessing SAP HANA as a Secondary Database
  • Tools to detect potential functional and performance issues when migrating to SAP HANA: Code Inspector and ABAP Test Cockpit, ABAP Trace and ABAP Profiler, SQL Trace
  • Tools to prioritize performance issues: SQL Monitor, SQL Performance Tuning Worklist
  • Performance Rules and Guidelines for ABAP in the context of SAP HANA

• Database Independent Code-to-Data

  • New Open SQL
  • Defining advanced views using Core Data Services (CDS) and CDS Associations in ABAP
  • Incorporating Authorization Checks with CDS in ABAP

• SAP HANA specific Code-to-Data

  • Using native SQL and ABAP Data Base Connectivity (ADBC)
  • Creating, using and debugging ABAP Managed Database Procedures

• Consuming SAP HANA Objects in ABAP>

  • Consuming SAP HANA views in ABAP using native SQL and ADBC
  • Consuming SAP HANA database procedures using native SQL and ADBC

• SAP HANA Proxy Objects

  • Creating and using External Views
  • Database Procedure Proxies
  • HANA Transport Container

• Advanced Topics

  • Using SAP HANA Full Text Search in ABAP
  • Enabling input fields for type-ahead search
  • SAP List Viewer (ALV) for SAP HANA