SAP HANA Installation, Operation and Administration
3.9 (214 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,501 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP HANA Installation, Operation and Administration to your Wishlist.

Add to Wishlist

SAP HANA Installation, Operation and Administration

Learn how to setup a SAP HANA environment from scratch to operate, administer, manage and distributed a landscape.
3.9 (214 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,501 students enrolled
Created by Junaid Ahmed
Last updated 7/2017
Curiosity Sale
Current price: $10 Original price: $200 Discount: 95% off
30-Day Money-Back Guarantee
  • 6.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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
View Curriculum
  • 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.

* Suser ID with sufficient privileges is required for downloading the software directly from SAP.

Who is the target audience?
  • This course is for System Administrators, Architects and Anybody who want to install and operate SAP HANA
Students Who Viewed This Course Also Viewed
Curriculum For This Course
64 Lectures
SAP HANA Introduction
3 Lectures 14:15

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
2 Lectures 09:50

Get to know from where to and how to download the SAP HANA.


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
14 Lectures 01:18:46

Clarify the SAP HANA System concepts and system types

Installation Landscape Overview

Understand from where and how to download the DB

Download SAP HANA and sub components

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 Oprtions: 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
4 More Sections
About the Instructor
Junaid Ahmed
4.2 Average rating
1,152 Reviews
7,832 Students
7 Courses
Entrepreneur, Product Designer, Architect and Trainer

Hello there! I am Junaid Ahmed. I have a bachelors in electrical and electronics engineering and a masters in software engineering . I would like to call my self a technologist, I am excited to learn new technologies, working and teaching on them.

I come from a background of enterprise software, and I am currently also focusing on Internet of things(IOT) and building products. I have worked for over 10+ years with enterprise applications, reporting and security products from SAP and Oracle. I have consulted with large organizations in Government, Telecom, Power, FMCG sectors and start-ups.I manage projects using agile methods and tools. I hold certifications in SAP HANA and scrum master . As far as training goes I have been involved in on site and online Training for the last 6 years in different products and practices including SAP HANA, BODS, BOBJ Suite, soft skills and IOT. I have over 6000+ students enrolled in my courses on Udemy. My clients include Consulting Companies, Implementation partners and Consultants. Currently, I have also started working with firms to provide solution in the IOT space.

Happy Learning!