SAP HANA Course Outline ( Duration is 8 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
• Attribute Hierarchy 
• Analytical Views
• Calculation Views
• Export & Import
• Currency Conversion
• Units Conversion

5. CE-Function

• Calculation Views Using CE Function
• Different Type of CE Function
• CE-Function on Views
• CE-Function for JOIN, UNION

6. SQL Queries Basis  

• DDL 
• DML
• Writing Simple Queries
• Select, Insert, Update, Delete, Distinct
• Join, Inner Join, Left Outer Join, Right Outer Join, Full Join, Cross Join

7. SQL Queries  

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

8. 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

9. 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

10. SAP BW ON HANA Using DXC: Direct Extractor

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

11. Security

• Creating Users
• Creating Roles
• Privileges
• User Administration 

12. Admin Tools

• Backup
• Recover 
• Transport Manager
• Administration Overview 

13. ABAP on HANA

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

SAP HANA Course Outline ( Duration is 8 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
• Attribute Hierarchy 
• Analytical Views
• Calculation Views
• Export & Import
• Currency Conversion
• Units Conversion

5. CE-Function

• Calculation Views Using CE Function
• Different Type of CE Function
• CE-Function on Views
• CE-Function for JOIN, UNION

6. SQL Queries Basis  

• DDL 
• DML
• Writing Simple Queries
• Select, Insert, Update, Delete, Distinct
• Join, Inner Join, Left Outer Join, Right Outer Join, Full Join, Cross Join

7. SQL Queries  

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

8. 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

9. 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

10. SAP BW ON HANA Using DXC: Direct Extractor

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

11. Security

• Creating Users
• Creating Roles
• Privileges
• User Administration 

12. Admin Tools

• Backup
• Recover 
• Transport Manager
• Administration Overview 

13. ABAP on HANA

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