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 (121 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,041 students enrolled
Instructed by Junaid Ahmed IT & Software / Other
92% off
Take This Course
  • Lectures 64
  • Length 6.5 hours
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works


Find online courses made by experts from around the world.


Take your courses with you and learn anywhere, anytime.


Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course Description

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.

What are the requirements?

  • Have basic information about SAP HANA, Linux and System Administration

What am I going to get from this course?

  • 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

Who is the target audience?

  • This course is for System Administrators, Architects and Anybody who want to install and operate SAP HANA

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.


Section 1: SAP HANA Introduction

Understand the big data problem.

What is SAP HANA ?

Understand SAP HANA solution proposition.


Understand what is inside SAP HANA.

Understand In-memory concept and other features

Section 2: Setting up VMware and Installing SUSE Linux

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.

Section 3: SAP HANA Installation

Clarify the SAP HANA System concepts and system types


Understand from where and how to download the DB


Understand Software Packaging in SAP HANA.


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


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


Understand the various installation methods


Use HDBLCM GUI to install a SAP HANA DB


Use HDBLCM command prompt to install the DB


Get comfortable with the most used paths


Uninstall SAP HANA DB using HDBLCM command prompt


Understand the use of the configuration file in batch mode


Install SAP HANA studio and Client on Windows Machine.

Understand the connectivity of SAP HANA Studio with the DB.

Understand how to use the host file for ip mapping

SAP HANA Multiple Host Installation
Section 4: Post Installation Checks

Understand Licensing information and how to install it.


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

Section 5: Updating and Patching SAP HANA

Update SAP HANA components using HDBLCM GUI from the OS level


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


Installing and uninstalling separate components

Section 6: Sizing and Scenarios

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


Understand the road map and the different landscape scenarios

Section 7: SAP HANA Multi Container DB Installation

Explain the architecture of multitenant database containers


Install SAP HANA DB in Multi Tenant DB mode.


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


After Installation, create a Tenant Database from the OS level


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

Section 8: SAP HANA Administration tools
  • 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.

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

Section 9: SAP HANA Operations

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


Start and stop SAP HANA using SAP HANA Studio


Know where configuration files are stored.

  • Configure the SAP HANA studio
  • Configure the SAP HANA database
  • Maintain Properties in HANA studio
  • Maintain Preferences in HANA studio

For SAP HANA administrators table administration is an important task.

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


Load and unload column store tables manually

Trigger delta merge operations manually

  • Understand the advantages of table partitioning
  • Know which single-level and Multi Level partitioning in SAP HANA
  • Use the Table Distribution Editor in SAP HANA Studio
  • Partition tables
  • Check partitioning consistency

Use Sql commands to manage the Tables.

Section 10: Monitoring and Troubleshooting
  • how to activate the traces within SAP HANA studio
  • Check the trace files
  • Open diagnosis files for analysis
  • Delete/merge files
  • Download files
  • Collect and download diagnosis information

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

  • Analyze SQL execution with the plan explanation
  • Analyze SQL execution with the Plan Visualizer
  • Analyze SQL execution with the SQL plan cache
Section 11: High Avalabiliy and Disaster Recovery
  • Explain the continuous availability scenarios for SAP HANA
  • Explain the high availability scenarios for SAP HANA
  • Understand high availability scenarios for SAP HANA
  • Understand the basics of SAP HANA scale out

Directly from SAP White paper.

Scale out can not be demonstrated due to obvious reasons of infrastructure.


My take on HANA DR and Q&A from IBM

Section 12: Transporting Changes

Learn how Delivery units are used to transport models


Learn how to Export models to a local or a server location


Learn how to Import SAP HANA Models in between environments


Learn how to import BW models from BW into SAP system


Learn the maintenance features

Section 13: Managing Security, Users and Profiles

Learn the user life cycle and how to maintain Users in SAP HANA


Learn about how to use privileges and roles to build a user securty model


Learn how to give and restrict access to a SAP HANA Cube


Learn how to build the end to end security by mapping a BOBJ use to a SAP HANA user

Section 14: BackUp and Recovery

Explain the concept of backup and recovery


Understand the various modes of Data Back up and Perform the same


Understand the location and how to manage the frequency of Log Back up


Build a new Db with database copy using the recovery options

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Junaid Ahmed, 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 9+ 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 4 years in different products and practices including SAP HANA and now IOT. I have over 2000+ 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!

Ready to start learning?
Take This Course