SAP Hana Administration
Course Syllabus

Version IT offers SAP HANA Administration Training in Hyderabad. In the world of enterprise technology, SAP HANA stands out as one of the most advanced and powerful in-memory databases. Effective administration of SAP HANA is essential for businesses seeking high performance, reliability, and efficiency in their data management systems. At Version IT, we provide comprehensive SAP HANA Admin Training in Hyderabad that helps you with the knowledge and skills needed to excel in managing SAP HANA databases. Our training program is designed to cater to both beginners and experienced professionals, providing a learning experience that is both engaging and practical.

Introduction

SAP HANA is a cutting-edge in-memory data platform that combines advanced database and data management capabilities. As more companies adopt SAP HANA for their enterprise needs, there is a growing demand for skilled professionals who can manage and maintain these databases effectively. Our SAP HANA Admin Course in Hyderabad covers the key aspects of SAP HANA administration, from installation and configuration to performance tuning and security.

SAP HANA administration's key aspects

  • Installation and Configuration: Proper installation and configuration of SAP HANA environments, including managing instances, servers, and landscapes.
  • Security and User Management: Implementing strong security measures such as authentication, authorization, and encryption to safeguard data and manage user access.
  • Performance Monitoring and Tuning: Continuously monitoring system performance and optimizing settings to ensure the database operates at its peak efficiency.
  • Backup and Recovery: Creating robust backup and recovery strategies to protect data from loss and facilitate quick system recovery.
  • System Monitoring and Maintenance: Regularly monitoring system health, maintaining database integrity, and applying necessary patches and updates.
  • Data Management: Handling data provisioning, migration, replication, and integration tasks within the SAP HANA environment.
  • Troubleshooting and Issue Resolution: Diagnosing and resolving system issues, such as performance bottlenecks, data corruption, and error handling.
  • High Availability and Disaster Recovery: Implementing high availability and disaster recovery solutions to ensure continuous system availability and data resiliency.
  • SAP HANA Lifecycle Management: Managing the entire lifecycle of SAP HANA systems, including version upgrades, system migrations, and retirement planning.
  • Documentation and Reporting: Keeping comprehensive documentation of system configurations, policies, and procedures, and generating reports on system performance and usage.
  • Compliance and Auditing: Ensuring compliance with industry regulations and internal policies, as well as conducting audits to verify data integrity and security.
  • Capacity Planning and Scalability: Planning for future growth and ensuring the system can scale according to the evolving needs of the business.
  • Advanced Features: Understanding advanced features such as dynamic tiering, extended storage, and smart data access to optimize data storage and processing.

It's important to remember that SAP HANA administration requires a strong foundation in system administration, database theory, and SAP HANA-specific tools and technologies. Effective SAP HANA administration requires constant learning and adherence to the most recent best practices, just like with any complex system.

Join Version IT for SAP HANA Administration Course in Hyderabad to start down the path to a prosperous career in SAP HANA administration. You will receive excellent training in Version IT to prepare you for the opportunities and challenges of efficiently administering SAP HANA databases.

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

Fill the form and get 10% discount