Online | Self-Paced | Corporate

SAP HANA Administration Training

SAP HANA Administration training Provided by Tekslate enables you to learn and implement various configuration works for operating and monitoring the SAP HANA database. In this training, you will study about HANA Studio to develop an SAP HANA database in the format of a GUI tool. Through this training, you will learn concepts like SAP HANA simplified and extended architecture, Hardware and Software Innovations, HANA Compare to BWA, etc. 

1284 Learners

Key  Highlights

contact us
+1 930 200 4823
Key Highlights tekslate courses
30 Hrs Instructor Led Training
Key Highlights tekslate courses
Self-paced Videos
Key Highlights tekslate courses
5 Hrs Project & Exercises
Key Highlights tekslate courses
Key Highlights tekslate courses
Job Assistance
Key Highlights tekslate courses
Flexible Schedule
Key Highlights tekslate courses
Lifetime Free Upgrade
Key Highlights tekslate courses
Mentor Support


A complete index of
job-ready skills curated
to meet the industrial need.


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

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

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

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

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

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

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

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

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

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

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

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

HANA DB Software and Hardware Technology Innovations
HANA DB Editions
HANA DB Modules
HANA DB Architecture
HANA DB Phases
HANA Admin -High Availability
HANA DB , H/W,Sizing,Editions. IMCE, IC
Suse Linux OS Installation with respect to HANA (Planning,S/W Requirements,Issues)
HANA DB Server Installation (Planning,S/W Requirements,Issues,Testing)
HANA Admin -Backup
HANA Admin -Recovery
HANA Admin -User Management
HANA Admin -Privelages
HANA Admin -Alerts
HANA Admin -Memory Management
HANA Admin -Admin Performance
HANA Admin -Admin Configurations
HANA Admin -Traces
HANA Admin -Security
HANA Admin -Starting and Stoping
HANA Admin - HD Studio configuration
HANA Admin -Deployment
HANA Admin -Upgrading Service Pack/revision
HANA Admin -Scaling
HANA Admin - License Keys
HANA Admin - Monitoring
HANA DB Replication Technology_SAP LT  Installation - THEORY
HANA DB Replication Technology_SAP DS Installation - THEORY
HANA DB Replication Technology_SAP DXC  Installation - THEORY
HANA DB  ERP  Installation - THEORY
BW HANA  Installation - THEORY

We have made a tailored curriculum covering the latest industry-ready concepts to serve every individual’s learning desires.

SAP HANA Administration Training  Objectives

Tekslate’s SAP HANA Training gives you enough skills for the enhancement of your career. Our industry experts training makes you gain proficiency on the essential concepts of the SAP HANA Administration at your planned timings. With the help of this training, your proficiency in SAP HANA Administration attains new level.
You can earn real-time Knowledge on SAP HANA Versions, SAP HANA Enterprise and Platform Edition, Memory and CPU Sizing, SAP HANA Scale-out, HANA Navigator and administration view, HANA Architecture, Install HANA Studio, Starting and Stopping SAP HANA Database, etc. Our Perpetual live support clears your doubts instantly. Live projects deployed by our industry experts provide you the required experience with real-world environment.

SAP HANA Administration is crucial for implementing SAP HANA in any industry environment. So, many companies are recruiting SAP HANA Administrators to work with SAP HANA Database.

System administrators, Database Administrators and SAP BASIS Administrators are suitable for this training.

Good understanding of Database concepts is sufficient for this training.

During this training, you will gain the ability to:

  • Work with SAP HANA Database.
  • Understand SAP HANA Technology.
  • Learn about HANA Studio for administration purpose.
contact us
+1 930 200 4823

Training  Options

Different individuals. Different upgrade goals. Different modes of learning.

We got solutions for everyone looking for an AWS Architect course. Opt in for your convenient upgrade option, and we will guide you through.

One-on-one Session

Live Online.

30 Hours
Additional tips from the trainer

24 Jan 2022, 07:00 AM IST

31 Jan 2022, 07:00 AM IST



30 Hours
Weekdays & Working Hours
Accessible through LMS
At your convenience

SAP HANA Administration Training Upcoming Batches

24 Jan, 2022 - 24 Feb, 2022
01:30 AM IST
31 Jan, 2022 - 03 Mar, 2022
01:30 AM IST
29 Jan, 2022 - 01 Mar, 2022
02:30 AM IST
22 Jan, 2022 - 22 Feb, 2022
02:30 AM IST
calendar tekslate

Schedules Doesn't Suit You ?

Our Team can set up a batch at your convinient time.

Corporates  Training

Experience and witness the express transformation of your workforce from the world-class tech upgrade platform.

Customized training options

Tailored curriculum to fit your project needs.

Practical exposure is assured.

We have got everything covered for any IT upgrade for your organization. We are one click away.

Success Stories from Future Digital Leaders

SAP HANA Administration Training  FAQ'S

Have questions? We’ve got the answers. Get the details on how you can grow in this course.

We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth.

We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.

Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.

Join a Free SAP HANA Administration Training  Demo Session

See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

By providing us with your details, We wont spam your inbox.

Related  Courses

related courses

ETL Testing Training

related courses

IBM BigFix Training

related courses

Cassandra Training

related courses

IBM BPM Training