SAP HANA 2.0

Unit 1: SAP HANA Foundation

1) Introduction to In-Memory Computing – Fundamentals of SAP HANA
2) Columnar store database, Massive Parallel Processing, Data Compression
3) SAP HANA Landscapes and Scenarios
4) Architecture of SAP HANA

Unit 2: Deployment Strategies

1) On–Premise
2) On–Cloud
3) Side-Car

Unit 3: SAP HANA Studio Interface

1) Adding SAP HANA System – Perspectives
2) Administration
3) Modeling
4) Development

Unit 4: SAP HANA Modeling

1) Catalog - Schemas
2) Creating Columnar and Row based table
3) Loading data from flat file to HANA tables
4) Creating Packages
5) Different types of packages
6) Attribute View
7) Analytic View
8) Calculation View
9) Different types of Joins
10) Variables
11) Filters
12) Restrcited and Calculated Columns
13) Create Hierarchies
14) Currency Conversion

Unit 5: Using SQL in Models

1) Introducing SAP HANA SQL
2) Working with SQLScript
3) Creating and Using Functions
4) Creating and Using Procedures

Unit 6: Replicating Data to SAP HANA

1) Business Objects Data Services (BODS)
2) SAP Landscape Transformation (SLT)
3) SDA
4) DXC

Unit 7: SAP HANA Reporting Overview (BOBJ)

1) BO WEBi
2) BO IDT (BO UNX)
3) SAP Lumira

Unit 8: Admin and Security in SAP HANA Modeling

1) Understanding Roles and Privileges
2) Defining Analytic Privileges
3) Defining Roles
4) Schema Mapping
5) Transportation of schemas