SAP HANA Online Training Course Content

Unit 1 – Introduction

• 1.1 Overview of SAP HANA 1.0
• 1.2 Components
• 1.3 Hardware Vendors
• 1.4 Table format in SAP HANA

Unit 2 – Architecture

• 2.1 Appliance Architecture Overview
• 2.2 Database Engine View
• 2.3 Data-Loading View
• 2.4 Data-Modeling View
• 2.5 Reporting view
• 2.6 Administration View
• 2.7 Persistence Layer

Unit 3 – SAP HANA Setup

• 3.1 System Landscaping
• 3.2 Sizing Guidelines
• 3.3 Scale Up/Out configurations

Unit 4 – Data Provisioning

• 4.1 Via BO Data services w/o ODP API
• 4.2 Via BO Data services ODP enabled data sources
• 4.3 Sybase replication – Log based replication (overview)
• 4.4 SLT Replication Transformation
• 4.5 DXC

Unit 5 – SAP HANA Studio Introduction

• 5.1 Administration Console
• 5.2 Information Modeler
• 5.3 Life Cycle management
• 5.4 System Monitor

Unit 6 – SAP HANA Modeling

• 6.1 Attribute View
• 6.2 Analytic View
• 6.3 Calculation View
• 6.4 Variables in HANA
• 6.5 SQL Script
• 6.6 Procedures
• 6.7 Hierarchies
• 6.8 Auto Documentation
• 6.9 Performance Optimization techniques in HANA
• 6.10 Best Practices while Creating Information Models
• 6.11 Export & Import

Unit 7 – Reporting

• 7.1 Client connectivity options
• 7.2 SAP BO BI 4.0
• 7.3 MS-Excel
• 7.4 SAP BO Analysis
• 7.5 SAP BO Explorer
• 7.6 Semantic Layer (Universe)
• 7.7 SAP Crystal Reports Enterprise,
• 7.8 Dashboards using SAP HANA
• 7.9 WebI using SAP HANA
• 7.10 Visual intelligence
• 7.11 SAP Crystal Reports 2011

Unit 8 – User Management

• 8.1 Creating Users
• 8.2 Creating Roles
• 8.3 BI/BO 4.0 Integration & SSO
• 8.4 Privileges
• 8.5 Assign privileges to Users/Roles
• 8.6 SQL Statements for user management
• 8.7 Security & Authorization

Unit 9 – SAP HANA Administration

• 9.1 Backup & recovery
• 9.2 SAP HANA Studio Installation and Configuration
• 9.3 Clients installation
• 9.4 Create ODBC Connections
• 9.5 Monitor HDB
• 9.6 Multi Version Concurrency Control – MVCC
• 9.7 IMDB Installation
• 9.8 Distributed System Handling – Cold backup and Hot Backup
• 9.9 Persistency Layer

Unit 10 – SAP BW on HANA

• 10.1 Overview of SAP BW
• 10.2 SAP BW Powered By Hana as database
• 10.3 In Memory Optimised Infocube
• 10.4 In Memory Optimised DSO
• 10.5 Bex Report on SAP HANA Transient Provider
• 10.6 SAP BW Composite provider on HANA models

Unit 11 – Other Topics

• 11.1 COPA Business case
• 11.2 Rapid Deployment Solution

SAP HANA CERTIFICATIONS

• SAP HANA Introduction – HA100
• SAP HANA – Installation and Administration – TZH200
• SAP HANA Implementation and Modeling – HA300
• CO-PA Accelerator with SAP HANA – HA901R
• OKP – SAP HANA – OHA10
• SAP BW on SAP HANA – TZBWHA