Courses

SAP Hana Administration

About SAP HANA Administration
Course Syllabus

SAP HANA Administration Training in Bangalore

Why Learn SAP HANA Administration?

High-Performance In-Memory Database: SAP HANA is a powerful in-memory platform used for real-time analytics and data management. Learn how to manage its features for optimal performance.
Growing Industry Demand: With more businesses adopting SAP HANA, skilled administrators are in high demand across the tech landscape.
Robust Career Advancement: Gain expertise in monitoring, security, backup, and performance tuning to stand out in your career.

Key Skills You’ll Learn

Installation & Configuration of SAP HANA systems and landscape management.
Security implementation with role-based access and encryption.
System performance monitoring and tuning.
Backup and disaster recovery strategies.
Regular maintenance, patching, and updates.
Data provisioning, replication, and integration.
Troubleshooting and resolving performance issues.
Lifecycle management including upgrades and migrations.
Compliance, auditing, and system reporting.

Course Objectives

Understand and configure SAP HANA environments efficiently.
Implement robust security and user management strategies.
Monitor and optimize SAP HANA system performance.
Develop and execute reliable backup and recovery procedures.
Handle data provisioning and integration tasks.
Ensure system scalability and high availability.
Manage compliance through auditing and documentation.

Prerequisites

Basic understanding of system and database administration.
Familiarity with the SAP ecosystem is beneficial.

Who Should Attend?

System Administrators
SAP Basis Consultants
Database Administrators
IT Professionals looking to specialize in SAP HANA
Technical Architects

Why Choose Skill Forge Academy?

Expert trainers with real-time SAP HANA experience.
Industry-aligned course structure with practical exposure.
Real-world labs, exercises, and best practices.
Career and interview preparation support.

Enroll Now and Get a 10% Discount!

Name
Phone Number
Email
Courses
Message for me *

Introduction to HANA DB In-memory database and its evolutions

Introduction to SAP HANA
SAP HANA components
SAP HANA Revision Strategy
SAP HANA Versions
SAP HANA Editions

PREPARING SAP HANA Installation

Sizing of SAP HANA:

CPU sizing
Memory Sizing (Static RAM and Dynamic RAM)
Disk Sizing

Requirements:

Hardware Requirements
Software Requirements
Directories required for SAP HANA
System Types
SAP HANA Main Components

Requirements:

SAP HANA Platform Lifecycle Management
SAP HANA Application Lifecycle Management

Pre-Installation of HANA DB

Load VMware ESXi (VMware vSphere)
Load SUSE Linux 11 O/S
Sizing the Hardware for HANA 2.0 DB installation

SAP HANA Installation

Perquisites for a SAP HANA installation
SAP HANA Server Installation
SAP HANA Studio Installation

SAP HANA Client Installation

Installation of S/4 HANA 2023

Installation NW 7.5 ABAP stack on HANA 2.0 SPS02

Post installation of S/4 HANA

Creation of Admin user
Apply SAP license
Configure TMS system
Schedule housekeeping jobs
Set profile parameters
Create a client/create logical system
Perform local client copy
Apply patches/addons
Printer configuration
Security & Roles
Working with DBA cockpit (DB13)
Schedule backups
Perform DB health checks
Perform stats on HANA DB

Auto post configuration procedure

Installation HANA 2.0SPS 2.0 DB

SAP HANA Post Installation

Managing SAP HANA Licenses
License Keys
Check the Current License Key
Install a Permanent License
Delete an Existing Permanent License Key
SAP HANA lifecycle Management Function Options

SAP HANA DATABASE ARCHITECTURE

Persistence Layer
Memory Usage
Memory Management in column store

SAP HANA Fault Tolerance

Explaining SAP HANA Scale-out
Installing High Available SAP HANA
Reconfiguring a Scale-out SAP HANA System
Understanding Failure of a SAP HANA Slave Node
Understanding Failure of the SAP HANA Master Node
Removing a Host from a Scale-out System
Adding a Host to a Scale-out System

Installation of HANA Studio (Interactive with HANA)

Configuration of DBA Cockpit
Connecting SAP HANADB via HANA studio c. Perform DB backup
Perform DB restore
Working with HANA DB queries
Monitoring HANA DB performance

Table redistribution with SAP HANA Studio

Load and unload column store tables manually
Load tables to the memory of the HANA server
Check the size of the memory consumption of main storage and delta storage
Types of Delta Merges
Trigger Delta Merge Operation Manually
Data Compression in the Column Store
Converted Row Store Tables to Column Store tables
Viewing Options for Tables and Views
Export Tables and Other Catalog Objects
Import Tables and Other Catalog Objects

Backup & Recovery

Concept of Backup and Recovery
Configure backup settings
Data area Backup
Log area Backup
Backup of configuration files
Different Types of HANA DATABASE Backups
Backup of Tenant database
Different types of Recovery methods of HANA DATABASE
Recovery of Tenant database

Configuring Multitenant Database Containers

Architecture of Multi-Tenant Database Containers
Migrated Statistics Server into Embedded Statistics Server
Convert an SAP HANA System to Multitenant Database containers (MDC)
Create a Tenant Database
Adding Single and Multitenant Databases to HANA Studio
Drop a Tenant Database
Stop and Start a Tenant Database
Monitoring multiple database container systems
Managing Resources in Multiple-Container systems
System Views in Multiple-Container Systems
Cross Database Access
Enable and configure Cross Database Access

Maintaining Users and Authorizations

Users’ management
Types of privileges

Roles

Assigning Role to User
Assigning Privileges to Roles
System privileges
SQL privileges
Package privileges
Granted role privileges
Object privileges
Explaining Encryption
Configure Data Volume Encryption

Monitoring and Troubleshooting

Monitoring with SAP HANA Studio
Monitoring With SAP HANA Cockpit
Monitoring with DBACOKPIT
Status Overview
Services Overview
Diagnosis files
Memory Usage details
System Load History
Disk Usage Details
Checking System Configuration

Alerts

Check the alerts and error logs
Performance Overview
Volume configuration
Check diagnosis files

SAP HANA Transport Management:

Different types of Options for Transporting SAP HANA Content:

Native SAP HANA Content:

Transport of Native SAP HANA Content with SAP HANA Application Lifecycle Manager (HALM)

SAP HANA Content Exclusively Used by ABAP:

Use of SAP HANA Transport Containers for ABAP for SAP HANA Content

SAP HANA STRENGTHEN

SAP HANA Database Copy
Pre-requisites of Updating SAP HANA
SAP HANA Support Pack revision and Maintenance revision Update
Upgrade SAP HANA Database from SAP HANA 1.0 SPS12 to SAP HANA 2.0 SPS04

SAP HANA System Replication

SAP HANA System replication Concept
Replication Modes for SAP HANA System Replication
Operation Modes for SAP HANA System Replication
Types of Data Packages transferred to the Secondary System
Types of SAP HANA System replication Configuration
Pre-requisites for configuring SAP HANA System Replication
Procedure to configure SAP HANA system replication
SAP HANA System Replication Data Flow from primary to secondary system
SAP HANA System replication Configuration Parameters
SAP HANA System replication Details
Types of Monitoring SAP HANA System replication
Data retention and log retention
Types of SAP HANA system replication takeover
Types of SAP HANA system replication failback
Takeover decision based on SAP HANA python script
SAP HANA System replication commands and options
SAP HANA Multi-tier System Replication
Setting up Multi-tier System Replication
Supported Replication Modes Between Sites
Concept of multi target system replication
Disaster recovery scenarios for multi target system replication
Updating SAP HANA Systems with SAP HANA System replication with NZDU
Use multi target system replication for NZDU

SAP HANA Cockpit 2.0

Introducing SAP HANA Cockpit 2.0
Installing SAP HANA Cockpit 2.0
Configure SAP HANA Cockpit 2.0
Setup and Administration with the Cockpit Manager
Managing Cockpit Users
Working with Resources and Resource Groups
Determine Ports for SAP HANA Cockpit and Cockpit Manager
Open SAP HANA Cockpit
Configure SSO Access to a Resource.
Authorizations Needed for Monitoring and Administration
SAP HANA Cockpit User Authentication
Open the SAP HANA Database Explorer (SAP HANA Cockpit)

SAP BW on HANA 2.0 SPS02

Apply BW Content via saint/spam
Post installation of BW

Phase:2

Login to HANA DB WITH ADMIN USER take via HANA Studio
Rows and columns Storage (In memory DB)
Indexing servers of HANA
SQL Commends on HANA
Users and Authorization of HANA DB
Backups of HANA DB (MS SQL Imp. for this)
Data base Restore and Recovery
SLT Concept (System Landscape Transformation)
Migration to HANA DB from Oracle/Sybase
Health Check and Monitoring of HANA DB and Logs
Log reclaim
Password reset
Schema name change
Patch upgrade
Revision upgrade

Introduction to HANA DB In-memory database and its evolutions Architecture of HANA DB and its usage of all components Working on S/4 HANA 2023 Post installation of S/4 HANA

Creation of Admin user
Apply SAP license
Configure TMS system
Schedule housekeeping jobs
Set profile parameters
Create a client/create logical system
Perform local client copy
Apply patches/addons
Printer configuration
Security & Roles
Working with DBA cockpit (DB13)
Schedule backups
Perform DB health checks and stats on HANA DB

Auto post configuration procedure Pre-Installation of HANA DB

Load VMware ESXi (VMware vSphere)
Load SUSE Linux 15 O/S
Sizing the Hardware for HANA 2.0 DB installation

Installation HANA 2.0SPS 2.0 DB Post installation of HANA DB

Start/Stop HANADB
Connecting SAP HANADB via HANA studio
Perform DB backup
Perform DB restore
Working with HANA DB queries
Monitoring HANA DB performance

Installation of HANA Studio (Interactive with HANA)

Configuration of DBA Cockpit
Connecting SAP HANADB via HANA studio
Perform DB backup & Perform DB restore
Working with HANA DB queries
Monitoring HANA DB performance

Installation of S/4 HANA 1709 Installation NW 7.5 ABAP stack on HANA 2.0 SPS02 SAP BW on HANA 2.0 SPS02

Apply BW Content via saint/spam
Post installation of BW
Login to HANA DB WITH ADMIN USER take via HANA Studio
Rows and columns Storage (In memory DB)
Indexing servers of HANA
SQL Commends on HANA
Users and Authorization of HANA DB
Backups of HANA DB (MS SQL Imp. for this)
Data base Restore and Recovery
SLT Concept (System Landscape Transformation)
Migration to HANA DB from Oracle/Sybase
Health Check and Monitoring of HANA DB and Logs
Log reclaim
Password reset
Schema name change
Patch upgrade
Revision upgrade