SAP HANA Administration Online Training

Skill Forge Academy offers the most comprehensive and industry-focused SAP HANA Administration Online Training in Bangalore

Our program is designed to equip you with the skills and knowledge needed to excel in this high-demand field.

Overview

Our SAP HANA administration online training program is designed to cater to both beginners and experienced professionals. Whether you are new to SAP HANA or looking to enhance your existing skills, our course offers a comprehensive curriculum that covers all aspects of SAP HANA administration.

Key Features of Our Training Program

• Expert Instructors: Learn from industry experts with extensive experience in SAP HANA administration.
• Comprehensive Curriculum: Our course covers all essential topics, including installation, configuration, monitoring, and troubleshooting.
• Hands-On Labs: Gain practical experience through hands-on labs and real-world scenarios.
• Flexible Learning: Access the training materials online, allowing you to learn at your own pace.
• Certification Preparation: Our training prepares you for SAP HANA administration certification exams, increasing your employability.

Why Choose SAP HANA Administration?

SAP HANA, an in-memory database technology, has revolutionized the way businesses handle data. As enterprises increasingly rely on real-time data processing and analytics, the demand for skilled SAP HANA administrators continues to grow. By mastering SAP HANA administration, you open doors to lucrative career opportunities and become a valuable asset to any organization.

Skill Forge Academy is a leading provider of IT training in Bangalore, renowned for delivering high-quality education and training solutions. With a team of experienced instructors and a commitment to excellence, we have helped thousands of students achieve their career goals. Our SAP HANA administration online training in Bangalore is meticulously crafted to ensure you gain practical skills and in-depth knowledge.

With the SAP HANA administration online training in Bangalore from Skill Forge Academy, you can invest in your future. Our thorough curriculum, knowledgeable instructors, and practical approach guarantee that you acquire the abilities and know-how required to thrive in the competitive IT sector. Don’t miss this chance to advance your career and earn your certification as a SAP HANA administrator. Enrol now to get started on the path to success!

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