The next-generation of our in-memory platform, SAP HANA 2.0, simplifies database and data management – and makes it easier for application developers to deliver smart, insight-driven apps. The platform’s new capabilities are optimized for innovation and can help your business compete more effectively in the digital economy. And because SAP HANA 2.0 is a continuation of the existing platform, you’ll have access to a stable, highly available, and secure data environment for your applications.

Price: $850.00

The SAP HANA 2.0 SPS05 course helps the candidate to possess the required knowledge in the area of the SAP HANA 2.0 (SPS05) for the profile of an SAP HANA technology consultant. This course builds on the basic knowledge gained through related SAP HANA training and preferably refined by practical experience within an SAP HANA project team, whereby the consultant applies the acquired knowledge practically in projects. Furthermore, the "SAP HANA 2.0 SPS05 course the candidate to aquire the knowledge of installing SAP HANA required by the profile of an SAP HANA technology consultant.


After the completion of this course, Trainee:

  • Can load balance read-intensive operations between a primary and secondary instance of SAP HANA with the active enabled mode.
  • Can automate orchestration of HA/DR processes with enhanced SAP Landscape Management integration.
  • Can optimize workload for 3rd party backup tools by consolidating SAP HANA log backups.
  • Can  protect data at rest by using SAP HANA’s comprehensive encryption for data and redo log files.
  • Can reduce TCO by using existing LDAP groups for automatic role assignment.
  • Can simplify monitoring of security alerts and configuration of security and users in the new SAP HANA cockpit.
  • Can manage one instance, multiple tenants or thousands of SAP HANA instances within the SAP HANA Cockpit administration tool.
  • Can prevent run-away queries and manage system thresholds with enhanced workload management.
  • Can reduce time and cost when implementing change by capturing, comparing and analyzing multiple workload replays.


1. Basic knowledge on  relational database and SQL
2. Knowledge of SAP BW
3. Knowledge of any ERP business process

Target Audiance

The SAP HANA 2.0  is suited for the following professionals:
1. BW Application Consultants
2. Business Analysts
3. Developers
4. Technical/Functional Consultants


Please see below the list of topics that may be covered within this course. Its accuracy does not constitute a legitimate claim; SAP reserves the right to update the exam content (topics, items, weighting) at any time.

SAP HANA Installation, Configuration and Upgrade               12%

SAP HANA Database Administration                                         12%

SAP HANA High Availability and Disaster Recovery               12%

SAP HANA Architecture and Deployment Options                 8% – 12%

SAP HANA Backup and Recovery                                                  8% – 12%

SAP HANA Database Security                                                         8% – 12%

SAP HANA Monitoring and Troubleshooting                           8% – 12%

Database Migration Options for SAP HANA                             8% – 12%

Course Contents

  1. Introduction to SAP HANA
  2. SAP In-Memory Strategy
  3. HANA compare to BWA

  1. Architecture Overview
  2. IMCE
  3. Row Store
  4. Column Store
  5. Loading data into HANA
  6. Data Modeling
  7. Reporting
  8. Persistent Layer
  9. Backup & Recovery

Method 1 – Data Provisioning using FLAT FILES

Method 2 – Data Provisioning using BODS 4.0 (BODS 4.0 Architecture in detail

  • Data Stores in BODS
  • Meta Data
  • BODS Objects and components Hierarchy
  • Building Data Flows in Designer (to Load the Data to SAP HANA)
  • Query Transform in the Data Flow
  • Loading the Data from diff files to SAP HANA using SAP BODS (Text files, spread sheets, XML files and COBOL copybooks)
  • Using Merge Transforms, Date Generation Transforms, SQL Transforms, Pivot Transforms, Reverse Pivot, Match Transform, Match Results Transform, Case Transforms, Validation Transforms, KEY Generation Transform, R Generation Transform, Table Comparison Transform, History Preservation Transform, Map operation Transform with Insert, Map Operation transform with Updates in BODS Data Flow to load the data to SAP HANA
  • Creating Repository Users
  • Creating a Local Repository
  • Setup Central Management Server (CMC)
  • Setup of Data Service Job Server
  • Creating Central repository and using it
  • Loading the Data from different SAP ERPS (like ECC, CRM) using SAP BODS to DSAP HANA for COPA Scenarios,FI Scenarios, Sales Scenarios, Purchasing Scenarios, Marketing Scenarios and Opportunity Scenarios and Service Scenarios.
  • Loading the Data from SAP BW 7.3 to SAP HANA using SAP BODS (Open Hub Tables, DSO tables etc)
  • Loading the Data from Non-SAP Source Systems to SAP HANA using SAP BODS

Method 3 – Data Provisioning using SLT

  • Positioning and Key Concepts
  • Overview on Configuration Aspects
  • Selective Data replication

Method 4 – Data Provisioning using Direct Extractor Connection (DCX)

  • Using SAP provided Business Content Extractor
  • ABAP Data Flows for Table and Pool clusters

  1. Purpose of Information Modeler
  2. Levels of Modeling in SAP HANA
  3. Attribute Views
  4. Analytic Views
  5. Calculation Views
  6. Creating Advanced Calculation Views using GUI and SCRIPT methods
  7. Creating Attribute Views, Analytical Views, Calculation Views for FI scenarios, COPA scenarios, Sales Scenarios, Purchasing Scenarios and Marketing Scenarios
  8. Export & Import – Server and Client sides
  9. Using Hierarchies (Level Based and Parent-Child Hierarchies)
  10. Creating Restricted and Calculated Measures
  11. Using Filter Operations
  12. Using Variables, input parameters
  13. SAP HANA SQL Introduction
  14. SQL Script and Procedures
  15. Using Currency Conversions, Create hyperlinks
  16. Persistency Considerations
  17. SAP HANA Engine Overview
  18. Choosing Views For Information
  19. Using SAP HANA Information Composer for Modeling
  20. Procession Information Models
  • Validating Models
  • Comparing Versions of Information Objects
  • Checking Model References
  • Generate Auto Documentation
  1. Connecting Tables.
  • Joins (Inner, Left Outer, Right Outer, Full Outer, Text, Referential and Union)
  1. Managing Modeling Content.
  • Manage Schemas
  • Import and Export data Models
  • Copy Information Objects

  1. HANA, Reporting Layer
  2. Connectivity options
  3. SAP Business Objects BI 4.1
  4. Designing Complex Universes in IDT based on HANA Tables and HANA Views
  5. WEBi 4.0 on HANA
  6. Crystal Report for Enterprise with HANA
  7. Designing the Dashboards using Query Browser on HANA Universes using Dashboard Design 4.0
  8. SAP Business Objects BI 4.1 Explorer
  9. Designing Information Space based on SAP HANA Information Model using BO Explorer 4.1
  10. Exploring the Data using BO 4.1 explorer based on Information Spaces created on HANA
  11. Creating Analysis Views using Analysis edition for OLAP (HANA OLAP connection)
  12. Analysis edition for Microsoft Excel, Microsoft Powerpoint
  13. SAP Visual Intelligence on HANA
  14. Crystal Reports via ODBC/JDBC Connections
  15. Others & MS Excel 2010

  1. Creation of Users
  2. Creation of Roles
  3. Creation of Role Hierarchy
  4. Assignment of Users to Roles
  5. Authentication
  6. IMCE Authorizations

  1. User Management and Security
  2. Types of Privileges
  3. Template Roles
  4. Administrative

  1. BW 7.3 powered by SAP HANA
  2. In-memory optimized Info cubes
  3. In-memory optimized DSO’s
  4. Migration concepts of BW 7.4 on traditional Database to BW 7.0 on SAP HANA
  5. Migrating standard Info cubes to In memory optimized Infocubes using migration Tool
  6. Migrating standard DSO’s to In-memory optimized DSO’s using migration Tool
  7. Customer Testimonials

  1. Sample questions and documentation for HANA certification provided (C_HANAIMP_10)

Course Assignments

News forum

SAP HANA - Support Forum

SAP HANA - Chat Room

Session PDF and PPT



SAP HANA Session 3


Activity 2



Quiz 2

Quiz 3

Quiz 4


CDC Change Data Capture Activity

CDC- Change Data Capture Activity Script


SAP COPA Project


Introduction to Data Warehouse

Product FAQ