• Courses
  • > SAP HANA Administration Training

SAP HANA Administration Training

SAP HANA Administration Training
4.5 890

SAP HANA Admin 2.x Training assists the learners' ways to migrate from other traditional databases to HANA Database which is 3500 times faster Analytics and 4500 faster reporting speed.

Date :
21 Apr 2017
Course Duration (Hrs):
Date :
22 Apr 2017
Course Duration (Hrs) :
Date :
23 Apr 2017
Course Duration (Hrs) :
Date :
27 Apr 2017
Course Duration (Hrs):
Date :
28 Apr 2017
Course Duration (Hrs) :
Date :
29 Apr 2017
Course Duration (Hrs) :
Date :
30 Apr 2017
Course Duration (Hrs) :
Contact Us Now!    

SAP HANA is a database from SAP built on in-memory technology. SAP HANA usually needs less administration than other databases, HANA Database is 3500 times faster Analytics and 4500 times faster reporting speed. The SAP HANA Studio is the main GUI tool for SAP HANA Administration Certification Training, so the future would be the HANA database with most of the customers.

SAP HANA Administration Certification Training Overview

Our training covers the full cycle of administration of SAP Hana solutions. The SAP HANA Administration course aims not only imparting theoretical concepts, but also helps students explore and experiment the subject.

Each Training Module builds on top of the preceding Module so that the learning process is progressive. The examples given in this training are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up HANA Platform i.e. pre and post installations, Direct extractor configuration and much more, followed by project. By the end of our training, students can confidently update their profiles with knowledge and Hands on experience.


SAP HANA Administration 2.x Training Curriculum


Getting Started with the Overview of the architecture of SAP HANA systems, Creation of HANA Columnar Store and Differentiate between SAP HANA row store vs Columnar Storage.

Introduction to SAP HANA SAP
In-Memory Strategy
HANA compare to BWA
In-Memory Computing
SAP HANA simplified Architecture
SAP HANA Extended Architecture
Business Intelligence Clients with HANA
HANA Columnar Store
SAP HANA row store vs Columnar Storage

 curriculum_moduleSAP HANA VERSIONS

Learn different versions of SAP HANA in this module..

HANA .0 SPS04—NEW Features
HANA .0 SPS05—NEW Features
HANA .0 SPS06—NEW Features
HANA .0 SPS07—NEW Features
HANA .0 SPS08—NEW Features
HANA .0 SPS09—NEW Features

 curriculum_moduleSAP HANA EDITIONS

This module focus on various SAP HANA editions, like the SAP HANA Platform Edition, SAP HANA Enterprise Edition and SAP HANA Enterprise Extended Edition which bundles additional components for data provisioning.

SAP HANA Platform Edition
SAP HANA Enterprise Edition
SAP HANA Enterprise Extended Edition

 curriculum_moduleSAP HANA SIZING

The critical factor for SAP HANA implementation is the right sizing of the server on the business requirement and this means correct calculation of amount off memory, the CPU processing power. SAP HANA sizing consists of Memory sizing for static data, Memory sizing of objects created during runtime, Disk sizing, CPU sizing.

SAP HANA In-Memory Database Sizing elements
RAM, Disk, CPU
Memory Sizing
CPU Sizing
SAP HANA Scale Out


What are the steps to be configured during PRE, POST installations of SANA HANA and also gives you a brief overview about it.

Preparing SAP HANA Installation
Reviewing SAP HANA Installation
Post-Installation steps

 curriculum_moduleLOOK AND FEEL

Understand about Memory computing studio, Switching between different views and about system monitor in HANA.

In-Memory Computing Studio
Administration view
HANA Navigator View
System Monitor in HANA
Information Modeler

 curriculum_moduleHANA ARCHITECTURE

In this module, we will explain about the architecture of HANA, How to apply Backup and Recovery to the entire database and different storage formats in HANA.

Architecture Overview
IMCE and Surroundings
HANA Row Store
Column Store
Loading data into HANA
Data Modeling in HANA
Persistent Layer in HANA
Backup & Recovery


For SAP HANA several hardware and software requirements need to be fulfilled. In this module, you can find a complete list of all SAP HANA components and the respective SAP HANA hardware and software requirements..

Prepare HANA Installation parameters
Users created during HANA Installation
HANA Required Installation media
Prepare Installer Configuration file

 curriculum_moduleINSTALLING SAP HANA

Learn, How to install SAP HANA from GUI as well as from Command prompt and also learn what are the  components of HANA..

SAP HANA unified Installer, Tool Unified Installer to install the Sap HANA SERVER
HANA Components installed by Installer
Command based Installation
GUI based HANA Installation

curriculum_moduleSAP HANA TOOL OVERVIEW

By the end of this module, you will get an overview on SAP HANA studio, how the DBA Cockpit works with SAP HANA and also how to execute the SQL statements using HDBSQL command line tool.

DBA Cockpit
HDBSQL Command Line Tool

 curriculum_moduleINSTALL HANA STUDIO

Know the system requirements and supported Platforms to install SAP HANA studio..

System Requirements
Supported Platforms
Install SAP HANA Studio


Understand how to monitor HANA Landscape, HANA Security, Start, Stop the HANA system and also know the logging on HANA system.

Starting and Stopping SAP HANA System
Displaying Process List
Logging on to HANA system using HANA studio
HANA User Security
Monitoring HANA Landscape

 curriculum_moduleSAP HANA OPERATION

Here will focus on Start, Stop SAP HANA Database and also to monitor HANA landscape..

Starting & Stopping SAP HANA
Starting SAP HANA Database
Stopping SAP HANA Database
Displaying Process List
Monitoring HANA Landscape
Periodic Manual Tasks


This session presents you about configuring Steps, Set-up and Architecture for SLT replication server and also about positioning, Different types of benefits of SLT.

Positioning and benefit of SLT for SAP HANA
Key benefits of Trigger-Based Approach
Architecture and building Blocks
Architecture for SAP Source Replication
Architecture for NON-SAP Source Replication
Set-up of LT replication server
Installation Aspects
Configuration Steps for SLT replication server
Setup Data Replication
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup


In this module, we will provide you, how to configure, Import HANA Studio for Metadata and to Load Data via Data Services into SAP HANA…

Configuring HANA Studio for importing Metadata
Importing Metadata
Mass Import
Selective Import
Load Data Via Data services into SAP HANA


We’ll give an introduction to SAP HANA Direct Extractor in this module..

Introduction to SAP HANA Direct Extractor

 curriculum_moduleCONNECTION (DXC)

Learn, how to enable the services, setup, configuration, and also to provide connections for SAP HANA.

Limitations of DXC
Setup and Configurations
Enabling Services
HTTP Connection and Test Connection


The identity of database users accessing SAP HANA is verified through a process called authentication. In this module, we’ll provide, how to create users, assign roles- privileges to the users as well as to the roles for SAP HANA Security.

Create Users
User and Role Concept
Creating Roles
Assigning Privileges to Roles
SQL Privileges
System Privileges
Analytic Privileges
Reporting Privileges
Modeling required Privileges


Backup and restore is the process of copying/storing data preemptively for the specific purpose of restoring, that same data can be used for restoration in an event such as loss of data in case hardware failure or accidental deletion or corruption of data.

System Configuration Parameters
Monitoring and system state parameters
Backup & Recovery SAP HANA
Need for Backup
Backup Types
Data Backup
Log Backup
Recovery Options
Recovery in Replication Scenarios
Backup to External Backup Destinations
Recovery Scenarios
Power Failure
Disk Failure


Learn, How to monitor SAP HANA, Checking the availabililty of  setting up, system monitoring, overview of  Services and providing system alerts.

Configuring Remote Support
Solution Manager Integration
Remote Service Connection
Availability Monitoring
Setting up Monitoring
System Monitoring Setup
Status Overview
Services Overview
System Load History
Disk Usage Details
Checking System Configuration

 curriculum_moduleSAP HANA LOGS & TRACES

This module presents, how to troubleshoot performance in SAP HANA and also configuration to manage log file.

Regular administration tasks
Analyzing performance
Auditing SAP HANA
Global Audit Configuration
Manage Audit Policies
Audit Events
Audit Trail


SAP HANA Admin Course FAQs

Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

We record each LIVE class session you undergo through and we will share the recordings of each session/class.

Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

The Training itself is Real-time Project Oriented.

Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

There are some Group discounts available if the participants are more than 2.

As we are one of  the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE and other parts of the world. We are located in USA.

Mindmajix Technologies Inc

14 Pasco Drive
East Windsor, Connecticut, 06088
United States (US)
Phone: 201 378 0518


Job Support

Mindmajix Job support’s aim is to train and support as many young IT professionals as possible in achieving their tasks for attaining quality jobs in the regular workforce.

For a fresher in IT, the actual requirement of programming and development standards could be partially or completely different in the job environment. Job support gives graduates that extra guidance before or after they attempt employment into IT sector by assisting them with the SAP HANA Administration training by highly experienced and real time professionals with full stack technical background in the SAP HANA Administration field. They address your complete issues that you face periodically.

We have wide-spread services across India, USA, Australia and other countries, assisting software employed people to excel in their jobs when they have an onset of a worsening condition.

Our trainers support you solve your technical problem and guide you to the right path in order to obtain a favourable solution. Once we understand your project, the subsequent problems are solved even better and faster.

What we assure?

* Our trainers make it a point to make you capable of understanding the real world scenarios.

* Our trainers will provide exceptional Technical assistance and help you out solve your Technical problems at your jobs in an efficient way.

* We assist the person learn a new job, and ensure extra assistance or a different format for learning the role vividly.

We Specialize in providing most reliable support and you can entirely entrust to us.

Drop Us A Query

Course Reviews


890 ratings
  • 5623
  • 4134
  • 389
  • 236
  • 19
Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.