SAP HANA Installation, Operation and Administration
4.1 (1,009 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,167 students enrolled

SAP HANA Installation, Operation and Administration

Learn how to setup a SAP HANA environment from scratch to operate, administer, manage a distributed landscape.
4.1 (1,009 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
5,167 students enrolled
Created by Junaid Ahmed
Last updated 9/2019
Current price: $139.99 Original price: $199.99 Discount: 30% off
5 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 6.5 hours on-demand video
  • 2 articles
  • 2 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • Setup up an SAP HANA Environment
  • Install SAP HANA in different modes and Configurations
  • Configure SAP HANA DB post installation
  • Operate and Administer SAP HANA Lanscape
  • Monitor SAP HANA with different Monitoring Tools
  • Setup end to end Security
  • Backup an Recover SAP HANA DB
  • Understand High Availability and Disaster Recovery
  • Have basic information about SAP HANA, Linux and System Administration

SAP HANA is a game changing and best selling product in the history of SAP. Helping companies solve data,reporting,latency challenges and unleash their potential with a real time platform. Learn it by implementing real time use cases, get started with the new and exciting world of real time reporting, analytic's and big data.

  • In this course you will learn how to install, configure, operate and administer a SAP HANA Landscape.

  • We start with the Introduction and then move to installation and update, we see different options and modes.

  • Then we get to know the administration tools ,we also see how to configure the db *

  • Later we see how to administer, perform standard administrator tasks, setup end to end security and understand how to setup HA and DR.

  • Towards the end we see back-up and recovery.

Engaging Teaching:

  1. Expressive and immersive teaching with demonstrations and learning tools

  2. Small, purposeful videos, packed with information, designed specifically for a virtual self paced audience.

Credits:I have used SAP Guides, Manuals, Slides, SCN blogs as reference. Credits are due to the corresponding parties.

* SAP HANA express edition can be used for your learning purposes

Who this course is for:
  • This course is for System Administrators, Architects and Anybody who want to install and operate SAP HANA
Course content
Expand all 61 lectures 06:33:09
+ SAP HANA Introduction
2 lectures 12:53

Understand the big data problem.

What is SAP HANA ?

Understand SAP HANA solution proposition.

Preview 05:39

Understand what is inside SAP HANA.

Understand In-memory concept and other features

Preview 07:14
+ Setting up VMware and Installing SUSE Linux
1 lecture 07:58

You will be able to configure a VM and install SUSE Linux.

Creating and Configure a new Virtual Machine with SUSE Linux operating system
+ SAP HANA Installation
13 lectures 01:15:22

Clarify the SAP HANA System concepts and system types

Installation Landscape Overview

Understand Software Packaging in SAP HANA.

Software Components

Understand what needs to be installed and configurations required on SUSE linux

Pre-Requisites before Installing SAP HANA

Understand the SAP HANA file structure. Parameters and the users created during installation.

Understand paths,required parameters and users

Understand the various installation methods

Understand Installation Options

Use HDBLCM GUI to install a SAP HANA DB


Use HDBLCM command prompt to install the DB


Get comfortable with the most used paths

Important: Often used Paths

Uninstall SAP HANA DB using HDBLCM command prompt

Uninstalling the SAP HANA DB with HDBLCM

Understand the use of the configuration file in batch mode

Advanced : Installing SAP HANA in batch mode using HDBLCM

Install SAP HANA studio and Client on Windows Machine.

Installing client and studio in Windows
Understand the connectivity of SAP HANA Studio with the DB.

Understand how to use the host file for ip mapping

Connecting SAP HANA Studio with the DB
SAP HANA Multiple Host Installation
+ Post Installation Checks
2 lectures 11:41

Understand Licensing information and how to install it.

Manage Licenses

Take a tour on the OS to check the functioning of the installed components

Check Installation Health and Components
+ Updating and Patching SAP HANA
3 lectures 20:31

Update SAP HANA components using HDBLCM GUI from the OS level

Update using HDBLCM GUI

Update SAP HANA components using HDBLCM from the client using SAP HANA Studio

More Options: Update Using HDBLCMWEBGUI and Studio LCM

Installing and uninstalling separate components

Removing and Adding additional components like AFL
+ Sizing and Scenarios
2 lectures 13:43

What needs to be taken into consideration when sizing an SAP HANA system

Sizing the DB

Understand the road map and the different landscape scenarios

Installation/Landscape Scenarios
+ SAP HANA Multi Container DB Installation
5 lectures 38:00

Explain the architecture of multitenant database containers

Understand Multi Container/ tenent DB Concept

Install SAP HANA DB in Multi Tenant DB mode.

Installing SAP HANA as a Multi Container

connect to the DB from the Client using SAP HANA studio in Multi Container Mode

Connecting to a Multi container from SAP HANA Studio

After Installation, create a Tenant Database from the OS level

Create a Tenant Database

Manage multi container DB's from the Studio, understand the difference.

Multi Container DB Management ( Start/Stop/Cross Tenant Query)
+ SAP HANA Administration tools
4 lectures 26:00
  • Understand the basic functions of the SAP HANA studio
  • Explain the concept of perspectives
  • Add an SAP HANA system to an SAP HANA Studio installation
  • Obtain an initial system overview in the Administration Console of the SAP HANA studio

Understand the basic functions of the SAP HANA Cockpit and Monitoring dashboard.

Use Tile based Fiori admin console.

SAP HANA Studio - Fiori and Web tools
  • Understand the basic functions of the DBA Cockpit.
  • Connect to SAP HANA DB
  • Monitor SAP HANA using DBACOCKPIT
DBA Cockpit
  • Know about the capabilities of HDBSQL
  • Establish a connection to SAP HANA using HDBSQL and execute commands

+ SAP HANA Operations
9 lectures 01:12:07

Start and stop Single and Muliti Host SAP HANA using command line

Starting and Stopping SAP HANA Part 1 -Server Side

Start and stop SAP HANA using SAP HANA Studio

Starting and Stopping SAP HANA Part 2 - Studio Side

Know where configuration files are stored.

Configuring SAP HANA Part 1 - Server Side
  • Configure the SAP HANA studio
  • Configure the SAP HANA database
  • Maintain Properties in HANA studio
  • Maintain Preferences in HANA studio
Configuring SAP HANA Part 2 - Studio Side

For SAP HANA administrators table administration is an important task.

In this lesson details on table definition and partitioning are covered.

SAP HANA Table Administration - Basics

Load and unload column store tables manually

Trigger delta merge operations manually

SAP HANA Table Administration - Load, Unload, Delta-Merge
  • Understand the advantages of table partitioning
  • Know which single-level and Multi Level partitioning in SAP HANA
SAP HANA Table Administration - Table Partitioning Theory
  • Use the Table Distribution Editor in SAP HANA Studio
  • Partition tables
  • Check partitioning consistency
SAP HANA Table Administration - Hash and Range Partition

Use Sql commands to manage the Tables.

SAP HANA Table Administration - Sql Syntax to manage Tables
+ Monitoring and Troubleshooting
4 lectures 27:01
  • how to activate the traces within SAP HANA studio
  • Check the trace files
Configuring Traces
  • Open diagnosis files for analysis
  • Delete/merge files
  • Download files
  • Collect and download diagnosis information
Working with Diagnose files

Understand the Standard system schemas and tables, Run pre-built admin queries.

Standard System Tables - SQL Console - Running standard Admin Queries
  • Analyze SQL execution with the plan explanation
  • Analyze SQL execution with the Plan Visualizer
  • Analyze SQL execution with the SQL plan cache
How to analyze a Query