Key Features

Hands-on projects execution

Expert Assistant

24/7 Server access

Project explanations and placements

Instructor led Training

High Quality e-learning

Resume preparation guidance

SAP HANA Administration

What is this course about?

SAP HANA Admin training from Ripples Info is designed to ensure that you clear the SAP HANA exam in the first attempt. Our hands-on training approach, entrusted by 80,000+ learners, will help you to imbibe the workings SAP HANA.

Prerequisites: None

SAP HANA Technology Overview

  1. SAP HANA Introduction
  2. Understanding the need of In Memory Technologies
  3. Understanding High performance Analytics
  4. In-Memory Computing
  5. Hardware-Innovations
  6. Software –Innovations
  7. HANA Columnar Store
  8. SAP HANA row store vs Columnar store
  9. Understanding Columnar Storage
  10. Finding SAP HANA Information Sources

SAP HANA Versions

  1. HANA 1.0 SPS03…..SPS12
  2. HANA 2.0 SPS00…SPS01

SAP HANA Editions

  1. Software Packaging
  2. SAP HANA Platform Edition
  3. Software components offered
  4. SAP HANA Enterprise Edition
  5. Software components offered

SAP HANA Deployment Scenarios

  1. HANA as DataMart
  2. Non-Native HANA Applications
  3. Native HANA Applications
  4. HANA Accelerator
  5. HANA Big Data Solutions
  6. HANA Edition Applications
  7. Describing SAP HANA Roadmap and Scenarios

SAP HANA Architecture

  1. Simplified Architecture of SAP HANA
  2. SAP HANA Memory Management and Data Persistence

Preparing Installation

  1. Sizing of SAP HANA
  2. Sizing KPI's (Memory, CPU, HDD, Network)
  3. Risks in Sizing
  4. Quick sizer
  5. Sizing Requirements and assumptions
  6. Experiencing HANA Appliance Models
  7. Cloud Options

Operating Systems

  1. Operating Systems Supported (SLES&RHEL)
  2. Linux Operating System Requirements
  3. File System Preparation


  1. Introduction SAP HANA Lifecycle Management Tools
  2. Install a Single-Host SAP HANA System
  3. Advanced installation options

Post Installation

  1. Post-Installation Steps
  2. SAP HANA Studio installation
  3. SAP HANA Client Installation

Admin Tools for SAP HANA

  1. Outlining Administration Tools
  2. SAP HANA Studio and SAP HANA Cockpit
  3. Connect to the SAP HANA Database Using SAP HANA Studio
  4. DBA Cockpit
  5. HDBSQL Command Line Tool

Database Administration Tasks

  1. Starting and Stopping SAP HANA
  2. Use Different Methods to Start and Stop the SAP HANA Database
  3. HANA database services and their significance
  4. Understanding Service Instances
  5. Understanding the Run level parameter
  6. Configuring the SAP HANA Database
  7. Change SAP HANA Configuration Parameters

Backup and Recovery

  1. Concept of Backup and Recovery
  2. Need of Backup
  3. Data Area Backup
  4. Understanding Backup Destinations
  5. Understanding BACKINT
  6. Performing Data backup using HANA Studio, Sql Commands, DBA
  7. Cockpit, HANA Cockpit
  8. Scheduling backups using DBA Cockpit, HANA Cockpit, Backup script
  9. Log Area Backup
  10. Understanding the concept of Log area backup
  11. Handling LOGFULL situations
  12. Additional Backup Topics
  13. Taking backup of Configuration Files
  14. Performing Storage SNAPSHOT backup
  15. Recovery
  16. Performing Database recovery
  17. Recovery options
  18. Resuming Recovery
  19. Recovery using Storage SNAPSHOT
  20. Database Copy / Database refresh
  21. Recovery Using HANA Cockpit 2.0


  1. Security Overview
  2. Understanding levels of security
  3. Understanding security in different scenarios
  4. Authentication and Authorization
  5. Encryption
  6. Auditing and audit policy

Maintaining Users and Authorization

  1. User Management
  2. Creating users using HANA Studio and Web IDE
  3. Types of Privileges
  4. Working with Analytic privileges
  5. Roles
  6. Creating runtime Roles
  7. Creating Repository Roles using Web IDE
  8. Administrative Tasks
  9. Information Sources for Administrators

HANA Application Life Cycle Management

  1. Concept of HANA Development
  2. Understanding Catalog and Content objects
  3. Transporting using Export and Import
  4. Concept of Deliver Unit
  5. Transport using Native HANA Transport
  6. Setting up Transportation landscape
  7. Working with Change List (Create, Approve, Release, Import)
  8. Configuring Transport Routes
  9. Understanding the Import logs
  10. Concept of CTS in SAP HANA

Multi tenant Database Containers

  1. Architecture and Technology
  2. Comparing Deployment options
  3. Installing MDC
  4. Creating and Configuring Tenant Databases
  5. Administration of Multi tenant Database Containers
  6. Backup and Recovery of Multi tenant Database Containers
  7. Convert a Single container to a multi tenant System

Updating SAP HANA

  1. Updating SAP HANA
  2. Using HDBLCM in Media
  3. Using Resident HDBLCM
  4. Using Platform Life Cycle Management
  5. Revision strategy of SAP HANA
  6. Data Centre Service Points
  7. Zero down time Maintenance

High Availability and Disaster Tolerance

  1. Need of Scalability
  2. SAP HANA Scale up and Scale Out
  3. Post scale out activities
  4. Understanding Distributed database
  5. High availability concept
  6. Disaster Recovery
  7. Configuring system replication

Database Operations

  1. SAP HANA Table Administration
  2. Periodic Tasks
  3. Housekeeping activities
  4. Defragmentation and Delta Merge
  5. SQL Console

SAP HANA Migrations

  1. Concept of Migration
  2. Sizing approach in Migration Projects
  3. Migration paths
  4. Migration procedure by using DMO
  5. Information source for Migration

Monitoring and Trouble shooting

  1. Memory Monitoring
  2. Understanding the Processing
  3. Analyzing Queries
  4. Working with Plan Visualizer
  5. Load Monitoring
  6. Alert Configuration
  7. Configuring Traces
  8. Working with Diagnosis Information and Diagnosis Files
  9. Trouble shooting unresponsive system

Monitor and Administration of SAP HANA using SAP HANA Cockpit 2.0

  1. Installing SAP HANA Cockpit 2.0
  2. Working with Cockpit Manager
  3. Creating Resource Groups and adding Resources
  4. Monitoring activities using Cockpit 2.0
  5. Understanding new features of Cockpit 2.0

Additional Topics

Configuring Data Replications using SLT

  1. Positioning and benefits of SLT for SAP HANA
  2. Key benefits of Trigger-Based Approach
  3. Architecture and building Blocks
  4. Set-up of LT replication server
  5. Configuration Steps for SLT replication server
  6. Setup Data Replication
  7. Landscape strategy of SLT replication server
  8. SLT replication server Installation Options
  9. Technical Requirements and system setup Information
  10. Creating RFC Connections
  11. Configuring and Monitoring Dashboard
  12. Monitoring of Replication

SAP HANA Direct Extractor Configuration

  1. Introduction to SAP HANA Direct Extractor Connection (DXC)
  2. Limitations of DXC
  3. Architecture and building Blocks
  4. Set-up of LT replication server
  5. Enabling Services
  6. HTTP connection
  7. Test Connection

Introduction to New Technologies

  1. Introduction to SAP S/4 HANA
  2. Introduction to SAP BW/4 HANA
  3. Future Road Map