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