HANA Database Administration

Become a Certified SAP HANA Professional


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 too for installation, update, configuration and system administration.
  • SAP HANA database lifecycle manager (HDBLCM)
  • SAP HANA cockpit 2.0
  • SAP HANA studio
  • 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.


SAP HANA Introduction

  • Lesson: SAP HANA Introduction
  • Lesson: SAP HANA Information Sources

Installation Preparations

  • Lesson: SAP HANA Sizing
  • Lesson: Linux Operating System Requirements

SAP HANA Installation

  • LLesson: Introducing SAP HANA Lifecycle Management Tools
  • Lesson: Describing Advanced Installation Options
  • Lesson: Explaining a Distributed System

SAP HANA Architecture

  • Lesson: SAP HANA Architecture and Technology
  • 7 Lesson: SAP HANA Memory Management and Data Persistence

SAP HANA Cockpit 2.0

  • Lesson: Introducing SAP HANA Cockpit 2.0
  • Lesson: Installing SAP HANA Cockpit 2.0
  • Lesson: Configuring SAP HANA Cockpit 2.0
  • Lesson: Updating SAP HANA Cockpit 2.0

SAP HANA Scenarios and Deployment Options

  • Lesson: Describing SAP HANA Roadmap and Scenarios
  • Lesson: Identifying Deployment Options

Post Installation Tasks

  • Lesson: Performing Post-Installation Steps
  • Lesson: Updating SAP HANA
  • Lesson: Using the Resident SAP HANA Database Lifecycle Manager (HDBLCM) Tool
  • Lesson: Using SAP HANA Interactive Education (SHINE)
  • Lesson: Explaining the Revision Strategy of SAP HANA

Administration Tools

  • Lesson: Explaining the Administration Tools
  • Lesson: Using the HDBSQL Command Line Tool
  • Lesson: Working with the DBA Cockpit
  • Lesson: Managing SAP Landscapes
  • Lesson: Using SAP HANA Studio

Database Administration Tasks

  • Lesson: Starting and Stopping SAP HANA
  • Lesson: Configuring the SAP HANA Database
  • Lesson: Performing Regular Database Administration Tasks
  • Lesson: SAP HANA Mini Checks
  • Lesson: Configuring Traces
  • Lesson: Working with Diagnosis Information and Diagnosis Files
  • Lesson: Using the SQL Console
  • Lesson: Performing SAP HANA Table Administration
  • Lesson: Transporting Changes

Backup and Recovery

  • Lesson: Explaining Backup and Recovery
  • Lesson: Performing Data Area Backup
  • Lesson: Configuring a Log Area Backup
  • Lesson: Describing Additional Backup Topics
  • Lesson: Performing Database Recovery
  • Lesson: Explaining Backup and Recovery Using Data Snapshots
  • Lesson: Creating a Fallback Snapshot
  • Lesson: Explaining Database Copy


  • Lesson: Describing Security Functions
  • Lesson: Explaining Encryption
  • Lesson: Describing Auditing

Maintaining Users and Authorization

  • Lesson: SAP HANA Authentication and Authorization
  • Lesson: Types of Privileges
  • Lesson: SAP HANA Roles
  • Lesson: Administrative Tasks
  • Lesson: Information Sources for Administrators

Course Features


Live and interactive online sessions with an industry expert instructor.


Expert technical team available for query resolution.


We provide lifetime Learning Management System (LMS) access, which you can access from across the globe.


The best price, aligning with the quality of our course deliverables


After completing the course, you will appear for an assessment from Cognatrix. Once you pass, you will be awarded a course completion certificate.



Yes, you will get lifetime access to the LMS portal.