web statistics

SAP HANA Online Training

SAP HANA-1.0 ONLINE TRAINING COURSE

Duration: 5 – 6 Weeks

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

 

Back to SAP Technologies