Share your recently acquired knowledge across your social and professional networks.

{learning-journey-title}

Record of Achievement

ROA_general_gerneric_Template.png

Pass all the quizzes and receive a digital badge

Record of Achievement

More content coming soon

We are constantly working to bring you content that keeps your knowledge and skills ahead of the game. &nbsp;More content coming soon.

Coming Soon

SAP Learning Group

Smiling coworkers looking at computer while working in office - stock photo

298119_16_9.jpg

Join our&nbsp;SAP Learning Group moderated by an SAP Learning expert. Ask your questions about digital learning journeys,&nbsp;prepare thoroughly for SAP Certification exams, and work together with other learners to reach your learning goals.

SAP Learning Group

SAP Learning Class 

SAP Learning Class | Installing and Administering SAP HANA

SAP Learning Class

Scrolling tab | Installing and Administering SAP HANA

Share feedback

Planned maintenance of Practice Systems

Planned maintenance of Practice Systems

Why create an SAP account?

Enhance your learning experience

SAP Learning

Find the right subscription for you

Check the status of your subscription

Live Sessions

Hands-on Practice

Certification

My Learning

Ready to start learning?

This certification verifies that you possess the required database administration skills in SAP HANA Cloud and SAP HANA for the role of an SAP HANA database administrator. This certification is based on the knowledge gained through the related SAP HANA database administration learning journeys or training courses.

SAP Certified Associate - Database Administrator - SAP HANA

cleanFiles/HA200_ILT_en-US_learning-sap-com_lsc-prod.zip (MMCP-DROPZONE) - 2025-04-09T11:59:38.000Z

Identifying the Need for SAP HANA

Illustrating the Need for In-Memory Technology

Assessment

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

After completing this learning journey, 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.

Join this comprehensive learning journey to master the major database administration tasks for the SAP HANA database system. Learn about installation, configuration, monitoring, security, and more. # This description was auto-generated #

1_h64o3n6c (video-connector) - 2024-01-25T09:48:37.031Z

Installing and Administering SAP HANA

Welcome to this learning journey covering the major database administration tasks for the SAP HANA database system. In this learning journey, you learn how to perform database administration tasks using the administration tools SAP HANA Cockpit, Database Explorer, and the command line tool HDBSQL. You learn about the preparation you need to perform before installing SAP HANA, such as sizing and configuring the operating system. We also cover the post-installation tasks and teach you how to perform an SAP HANA update. With Database Explorer, you learn how to import and export database content, use SQL to display table metadata information, use the Statement Library, and look at SAP HANA traces. SAP HANA Cockpit is used for many database administration tasks. You learn how to monitor memory, CPU, and disk usage, look at database alerts, and investigate SQL statements executed in the SAP HANA database. Database administration tasks, such as starting and stopping the database, changing the configuration, and enabling or disabling database features, is also part of this learning journey and is performed using the SAP HANA cockpit. This learning journey also covers security-related topics like auditing, encryption, users, and authorization roles. I hope you enjoy this SAP HANA Database Administration learning journey.

In this Get Certified live session series, certified expert trainers will deliver knowledge transfer sessions covering all topic areas relevant for the <a href="https://learning.sap.com/certifications/sap-certified-associate-database-administrator-sap-hana">C_DBADM</a> certification: SAP Certified Associate – Database Administrator - SAP HANA. The goal of this Get Certified live session series is for learners to receive expert-guided support to complement their self-study activities and prepare them to attempt the <a href="https://learning.sap.com/certifications/sap-certified-associate-database-administrator-sap-hana">C_DBADM</a> certification exam. To prepare for the certification, you should first work through the Learning Journey (s) linked to the certification, and join the live sessions. Your trainer will review the Learning Journey content and focus on the most important topics relevant to the exam, to give you the best chance of success. The following content will be covered: • &nbsp; &nbsp;Session 1: Kick Off: Outlining the live session series, introducing the certification, explaining the types of questions, providing tips for preparation, working through sample questions in the exam interface. (1 hour) • &nbsp; &nbsp;Session 2: Provisioning and administering databases in SAP HANA Cloud Unit 1 to 3 • &nbsp; &nbsp;Session 3: Provisioning and administering databases in SAP HANA Cloud Unit 4 to 6 • &nbsp; &nbsp;Session 4: Migrating SAP HANA to SAP HANA Cloud – All Units and Installing and Administering SAP HANA – Unit 1 to 2 • &nbsp; &nbsp;Session 5: Installing and Administering SAP HANA – Unit 3 to 5 • &nbsp; &nbsp;Session 6: Installing and Administering SAP HANA – Unit 6 to 8 • &nbsp; &nbsp;Session 7: Installing and Administering SAP HANA – Unit 9 • &nbsp; &nbsp;Session 8: Installing and Administering SAP HANA – Unit 10 to 12 and closing wrap-up before the exam

Get Certified: SAP Certified Associate - Database Administrator - SAP HANA

SF Live events (sf-live-events) - 2025-04-11T14:30:58.495Z

SAP HANA Troubleshooting Essentials: Diagnosing & Fixing Common Issues

This live session provides a practical approach to troubleshooting SAP HANA database issues, covering common failure scenarios such as storage problems, connectivity issues, performance bottlenecks, backup failures, and system crashes. Participants will learn to diagnose problems using SAP HANA tools, analyze logs, and apply effective solutions to restore database functionality and performance. Designed for database administrators, system engineers, and SAP professionals, this live session ensures participants gain the necessary skills to keep SAP HANA environments running smoothly and efficiently.

SF Live events (sf-live-events) - 2025-03-04T06:22:05.437Z

SPS07 - SAP HANA Installing and Administering

SPS07 - SAP HANA Installing and Administering

Prepare for certification

SAP HANA 2.0 SPS07 - Installation and Administration

Discovering SAP HANA

Preparing the Installation

Installing the SAP HANA Database System

Installing the SAP HANA Cockpit

Performing the Post-Installation Tasks

Working with Database Explorer

Monitoring using SAP HANA Cockpit

Administering using SAP HANA Cockpit

Performing Backup and Recovery

Describing SAP HANA Security Features

Performing User and Authorization Maintenance

Describing SAP ABAP Systems on SAP HANA

Related live sessions

Practice your skills in a live SAP environment

Hands-on Practice for SPS07 - SAP HANA Installing and Administering

SAP Learning Group

SAP Learning Class

SAP HANA Installing and administering

Book your certification exam