Data, Analytics & AI Category Banner Image

SAP HANA - Installation and Administration (HA200)

  • Length 5 days
  • Price  $5368 inc GST
  • Version HANA 2.0 SPS05
Course overview
View dates &
book now

Why study this course

This course covers in detail all key capabilities of SAP HANA database system administration. Through the lectures and exercises you will learn how to install, update and operate an SAP HANA 2.0 SPS05 database using SAP HANA Cockpit 2.0 SP12. The course covers the most important database administration tasks of an SAP HANA system administrator. You will learn details about starting and stopping, changing the configuration parameters, monitoring the database, backup and recovery, and troubleshooting of a multi-tenant SAP HANA 2.0 SPS05 database system.

This course is the best starting point to learn about SAP HANA installation, update, configuration and system administration. The course is independent from the SAP NetWeaver administration world, as it teaches how to perform system administration on the SAP HANA platform. The system administration tools used are native to the SAP HANA platform.

Throughout the course, you will learn about the following SAP HANA tools for installation, update, configuration and system administration:

  • SAP HANA Database Lifecycle Manager (HDBLCM)

  • SAP HANA Cockpit 2.0 SP12

  • SAP HANA HDBSQL command line

At the end, you will be able to perform all the required daily system administration tasks on the SAP HANA database platform.

This course is based on software release:

  • SAP HANA 2.0 SPS05

If you wish to “deep-dive” on specific subjects, this course can be combined with other courses in the SAP HANA Curriculum, for example High Availability and Disaster Tolerance Administration (HA201), Using Monitoring and Performance Tools (HA215), Authorizations, Scenarios and Security Requirements (HA240) and Database Migration using DMO (HA250).

Request Course Information

What you’ll learn

This course will prepare you to:

  • Install, update, and configure an SAP HANA 2.0 SPS05 database

  • Install, update, and configure SAP HANA cockpit 2.0 SP12

  • Perform the SAP HANA system administration tasks using SAP HANA cockpit 2.0 SP12 in a multi-tenant database environment

  • Start and stop, change the configuration, backup, and troubleshoot an SAP HANA 2.0 SPS05 database

  • Backup and recover a multi-tenant SAP HANA 2.0 SPS05 database


SAP at Lumify Work

Develop your SAP empowered employees with Lumify Work. Getting the right skills in place maximises the chance of project success and removes risk. Lumify Work provides a select range of SAP training courses for SAP S/4HANA, SAP HANA, SAP BusinessObjects and more. Lumify Work can work with you to navigate the curriculum and help you create a learning plan that will ultimately boost technology proficiency across your organisation.

Who is the course for?

  • Database Administrator

  • Help Desk / CoE Support

  • System Administrator

  • Technology Consultant

Course subjects

  • SAP HANA introduction

  • Installation sizing and OS preparations

  • SAP HANA installation and upgrade of a multi-tenant database

  • SAP HANA architecture and deployment options

  • SAP HANA cockpit 2.0 installation and configuration

  • SAP HANA Administration tools

  • Post installation steps

  • Database administration tasks using SAP HANA cockpit 2.0

  • Backup and recovery using SAP HANA cockpit 2.0

  • SAP HANA Security

  • Users and authorisations




  • Some experience with the Linux operating system

  • Some experience in database administration


Lumify Work offers certification and training through our partnership with SAP Inc. This arrangement requires Lumify Work to provide your details to SAP Inc for course and/or exam registration purposes.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Personalise your schedule with Lumify USchedule

Interested in a course that we have not yet scheduled? Get in touch, and ask for your preferred date and time. We can work together to make it happen.