SAP ABAP on HANA Training

Module 1: Overview of SAP HANA

• SAP HANA Basics and Technical Concepts
• High Performance Analytical Architecture
• SAP HANA Studio
• ABAP and SAP HANA
• SAP HANA Client
• ABAP Development Tools (ADT)
• Components and Tools of SAP HANA
• Hardware and Software Technology Innovations
• Advanced Database Management

Module 2: SAP HANA SQL Concepts

• New Feature of SQL Clauses
• Reading Data from a Table or View
• Duplicate Elimination
• Calculated Columns and Functions
• Sorting and Limiting Result Sets
• Aggregation and Grouping Data
• WHERE Clause
• SQL Functions
• Using Tuple Variables
• Case Statements in SQL
• Group By
• Order By
• IS NULL/NOT NULL
• Between
• LIKE Predicate
• Order Precedence
• Aggregate Functions
• UNION and UNION ALL
• Joining Table
  • Inner Join
  • Left and Right Outer Join
  • Full Outer Join
• Data Manipulation
  • Insert/Update/Delete
• Data Definition
  • Create Column table
  • Alter Table
  • Rename Table

Module 3: Introduction to AMDP

• Overview of AMDP
• Features of AMDP
• AMDP Developing Environment
• Syntax of AMDP Class
• AMDP Method
• ABAP Managed Database Procedure (AMDP)
• Advantages of AMDP Process