Share feedback

<p>We are aware of intermittent issues in accessing the learning content</p>

We are aware of intermittent issues in accessing the learning content

Why create an SAP account?

Enhance your learning experience

SAP Learning

Choose your subscription

Manage your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

Please try again later

Sorry, we encountered an error

Try again or reset results to continue browsing

We didn’t find what you’re looking for

To continue, please log in

Your session has timed out

Explore {title} at SAP Learning. Find out more!

Badges you can earn

Use Google Notebook for AI chat, briefing guides, and audio summaries.

Learn with AI guidance

Join scheduled live courses led by experienced SAP trainers.

Learn with an instructor

Other ways to learn

This certification is no longer offered. To check your certitication details click on Go to My Learning.

This certification is retired

Visit My Learning to check your status and schedule your assessment. You can also watch <link>Certification Support videos</link> to guide you through the process.

Ready to renew? It’s time to take your Stay Certified assessment

This certification has expired and cannot be renewed. You can explore recommended alternatives in the <link>SAP Certification portfolio</link> or visit My Learning for status updates.

This certification has been retired and is no longer active

Visit My Learning to see if you have attempts left to retake. For more details, see our guide: <link>How to Get Certified with SAP Certification</link>.

Unfortunately, you didn't pass the assessment this time

You certification is current. View details anytime in My Learning.

Your certification is up to date

What you'll learn

Quiz

Congratulations on completing this {objType}

Certification Exam

Theoretical Exam

Practical Exercise

Practical Test

External Hands-On

Practice System

Assessment

Subscription

Course Completion

Knowledge Badge

External Course

External Resource

Learning Journey

Learning Journey Assessment

Lesson

Live Session

Course

Stay Certified

Test Out

Unit

Video

Video Playlist

Week

Appears in

Goals

Learning outcome

Toggle full description

Overview

Prerequisites

Products and Roles

cleanFiles/HA200_ILT_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-10-26T16:56:22.000Z

Identifying the Need for SAP HANA

Illustrating the Need for In-Memory Technology

Discovering SAP HANA

Performing SAP HANA Sizing

Identifying Supported SAP HANA Hardware

Identifying the Linux Operating System Requirements

Outlining how to use the Hardware Measurement Tool

Preparing the Installation

Installing SAP HANA 2.0

Describing Advanced Installation Options

Illustrating Deployment Options

Installing the SAP HANA Database System

Illustrating SAP HANA Administration Tools

Installing SAP HANA Cockpit

Describing the SAP HANA Cockpit Architecture

Configuring SAP HANA Cockpit

Updating SAP HANA Cockpit

Installing the SAP HANA Cockpit

Illustrating Post-Installation Steps

Updating SAP HANA

Illustrating the Resident HDBLCM

Creating, Renaming, and Deleting a Tenant Database

Explaining the Revision Strategy of SAP HANA

Using the SAP HANA HDBSQL Command-Line Tool

Performing the Post-Installation Tasks

Using Database Explorer

Importing and Exporting Database Content

Displaying Table Information

Using the SQL Console

Using the SAP HANA Statement Library

Working with Database Explorer

Locating Databases in SAP HANA Cockpit

Checking the SAP HANA Services

Checking the Memory Usage

Checking the SAP HANA Persistence Storage

Checking for SAP HANA Alerts

Checking the SQL Statements

Monitoring using SAP HANA Cockpit

Starting and Stopping SAP HANA

Changing Database Configuration Parameters

Describing Further Configuration Functions

Describing the Concept of Delta Merge

Working with SAP HANA Traces

Administering using SAP HANA Cockpit

Describing Backup and Recovery

Performing Data Backups

Scheduling Data Backups

Configuring Log Backups

Performing Database Recovery

Describing Additional Backup Topics

Illustrating Advanced Backup and Recovery Techniques

Creating a Fallback Snapshot

Identifying Database Copy Scenarios

Performing Backup and Recovery

Illustrating the SAP HANA Security Functions

Describing Encryption

Setting Up Auditing

Describing SAP HANA Security Features

Describing SAP HANA Authentication and Authorization

Describing SAP HANA Privileges and Roles

Managing Users

Managing Groups

Describing Information Sources for Administrators

Performing User and Authorization Maintenance

Illustrating SAP ABAP Systems on SAP HANA

Describing SAP ABAP Systems on SAP HANA

SAP HANA 2.0 SPS07 - Installation and Administration

<p>After completing this course, you as an SAP HANA database administrators will be able to install, upgrade, configure, monitor, and operate an SAP HANA database system. You will be able to use the SAP HANA administration tools like SAP HANA cockpit, database explorer, and hdbsql to perform the daily system administration tasks on the SAP HANA database system.</p>