SAP HANA Introduction
  • Get introduced to SAP HANA
  • Main SAP HANA Features
Setting up VMware and Installing SUSE Linux
  • Creating and Configure a new Virtual Machine with SUSE Linux operating system
SAP HANA Installation
  • Installation Landscape Overview
  • Software Components
  • Pre-Requisites before Installing SAP HANA
  • Understand paths,required parameters and users
  • Understand Installation Options
  • Install SAP HANA DB using HDBLCM GUI
  • Install SAP HANA DB Using HDBLCM
  • Important: Often used Paths
  • Uninstalling the SAP HANA DB with HDBLCM
  • Advanced : Installing SAP HANA in batch mode using HDBLCM
  • Installing client and studio in Windows
  • Connecting SAP HANA Studio with the DB
  • SAP HANA Multiple Host Installation
Post Installation Checks
  • Manage Licenses
  • Check Installation Health and Components
Updating and Patching SAP HANA
  • Update using HDBLCM GUI
  • More Options: Update Using HDBLCMWEBGUI and Studio LCM
  • Removing and Adding additional components like AFL
Sizing and Scenarios
  • Sizing the DB
  • Installation/Landscape Scenarios
SAP HANA Multi Container DB Installation
  • Understand Multi Container/ tenent DB Concept
  • Installing SAP HANA as a Multi Container
  • Connecting to a Multi container from SAP HANA Studio
  • Create a Tenant Database
  • Multi Container DB Management ( Start/Stop/Cross Tenant Query)
SAP HANA Administration tools
  • SAP HANA Studio
  • SAP HANA Studio - Fiori and Web tools
  • DBA Cockpit
  • DBSQL
SAP HANA Operations
  • Starting and Stopping SAP HANA Part 1 -Server Side
  • Starting and Stopping SAP HANA Part 2 - Studio Side
  • Configuring SAP HANA Part 1 - Server Side
  • Configuring SAP HANA Part 2 - Studio Side
  • SAP HANA Table Administration - Basics
  • SAP HANA Table Administration - Load, Unload, Delta-Merge
  • SAP HANA Table Administration - Table Partitioning Theory
  • SAP HANA Table Administration - Hash and Range Partition
  • SAP HANA Table Administration - Sql Syntax to manage Tables
Monitoring and Troubleshooting
  • Configuring Traces
  • Working with Diagnose files
  • Standard System Tables - SQL Console - Running standard Admin Queries
  • How to analyze a Query
High Avalabiliy and Disaster Recovery
  • High Availability
  • SAP HANA Scale Out
  • Disaster Recovery
Transporting Changes
  • Delivery Units
  • Exporting SAP HANA Models
  • Importing SAP HANA Models
  • Importing BW Models and SAP ERP meta data into HANA
  • Useful Supplementary features
Managing Security, Users and Profiles
  • Create Users
  • Privileges and Roles
  • Analytic Privileges
  • End to End security: Mapping HANA and BOBJ User
BackUp and Recovery
  • Concept of Backup and Recovery
  • Taking a Data Back-Up
  • Log Area Backup
  • Recover a Data base and Data Base copy