SAP ABAP HANA

SAP HANA Course ( Duration is 4 weeks )

1. HANA Introduction—HA100

• Introduction to SAP HANA
• HANA – In Memory Computing
• Technology overview
• HANA – In Memory Strategy
• HANA Architecture
• HANA System requirements
• HANA Modules
• HANA with BW
• HANA with ECC

2. Architecture

• HANA Engine Overview
• Different HANA Engine Types
• Row Store
• Column Store
• Persistency Layer
• Business Impact of new architecture

3. Modeling—HA300

• HANA Modeling studio
• Modeling Process flow
• Levels of Modeling in SAP HANA
• Schema and Overview 
• Creating Tables in Data 
• Loading some sample Data from Local File 
• Normal View concept 

4. Advance Modeling –HA300

• Concept of Package
• Attributes
• Measures
• Attributes Views
• Attribute Time Based View
• Analytical Views
• Calculation Views
• Export & Import
• Currency Conversion

5. SQL Queries Basis  

• DDL 
• DML
• Writing Simple Queries
• Select, Insert, Update, Delete

6. SQL Queries  

• Synonyms
• Triggers 
• Procedures
• Sequence Creation
• Functions
• Decision Table

7. Loading and replication process

• SAP HANA database
• HANA client components
• HANA Data loading process
• Loading and replication process
• Data loading mechanism
• Data replication process
• Replication Server
• Replication Architecture
• BO Data Services data extraction
• Introduction to Data Services

8. DATA PROVISIONING: SAP LANDSCAPE TRANSFORMATION (SLT)

• Data provisioning overview
• Load, Replicate, Stop Replicate, Suspend, Resume
• SAP landscape transformation set-up
• Concept of SLT replication
• Architecture and key building block
• Technical requirement and system set-up information for LT replication server

9. SAP BW ON HANA Using DXC: Direct Extractor

• Loading data from BW to HANA via BODS
• Impact of BW on HANA

10. Security

• Creating Users
• Creating Roles
• Privileges

11. Admin Tools

• Transport Manager

12. ABAP on HANA

• SQL Procedure in HANA
• ABAP Programming 
• ABAP Conversion on HANA
• SQL Scenarios on HANA