SAP HANA Administrator

SAP HANA Administration

Getting started with the Overview of the architecture of SAP HANA systems, Creation of HANA Columnar Store, and Differentiate between SAP HANA row store vs Columnar Storage.

 

SAP HANA Admin Online Training Course Content

  1. Introduction to SAP HANA SAP

  2. In-Memory Strategy

  3. HANA compare to BWA

  4. In-Memory Computing

  5. Hardware-Innovations

  6. Software-Innovations

  7. SAP HANA simplified Architecture

  8. SAP HANA Extended Architecture

  9. Business Intelligence Clients with HANA

  10. HANA Columnar Store

  11. SAP HANA row store vs Columnar Storage

 

Learn different versions of SAP HANA in this module..

  • HANA .0 SPS10—New Features

  • HANA .0 SPS11 – New Feature

 

This module focuses on various SAP HANA editions, like the SAP HANA Platform Edition, SAP HANA Enterprise Edition, and SAP HANA Enterprise Extended Edition which bundles additional components for data provisioning.

 

  1. SAP HANA Platform Edition

  2. SAP HANA Enterprise Edition

  3. SAP HANA Enterprise Extended Edition

 

The critical factor for SAP HANA implementation is the right sizing of the server on the business requirement and this means correct calculation of amount off memory, the CPU processing power, SAP HANA sizing consists of Memory sizing for static data, Memory sizing of objects created during runtime, Disk sizing, CPU sizing.

 

  1. SAP HANA In-Memory Database Sizing elements

  2. RAM, Disk, CPU

  3. Memory Sizing

  4. CPU Sizing

  5. SAP HANA Scale-Out

 

What are the steps to be configured during PRE, POST installations of SANA HANA and also give you a brief review about it?

 

  1. Preparing SAP HANA Installation

  2. Reviewing SAP HANA Installation

  3. Post-Installation steps

Understand about Memory computing studio, Switching between different views, and system monitor in HANA.

 

  1. In-Memory Computing Studio

  2. Administration view

  3. HANA Navigator View

  4. System Monitor in HANA

  5. Information Modeller

 

In this module, we will explain the architecture of HANA, How to apply Backup and Recovery to the entire database, and different storage formats in HANA.

 

  1. Architecture Overview

  2. IMCE and Surroundings

  3. HANA Row Store

  4. Column Store

  5. Loading data into HANA

  6. Data Modeling in HANA

  7. Persistent Layer in HANA

  8. Backup & Recovery

 

For SAP HANA several hardware and software requirements need to be fulfilled. In this module, you can find a complete list of all SAP HANA components and the respective SAP HANA hardware and software requirements.

 

  1. Prepare HANA Installation parameters

  2. Users created during HANA Installation

  3. HANA Required Installation media

  4. Prepare Installer Configuration file

 

Learn, How to install SAP HANA from GUI as well as from Command prompt and also know what are the components of HANA

  1. SAP HANA unified Installer Tool Unified Installer to install the Sap HANA SERVER

  2. HANA Components installed by Installer

  3. Command based Installation

  4. GUI based HANA Installation

By the end of this module, you will get an overview of SAP HANA studio, how the DBA Cockpit works with SAP HANA, and also how to execute the SQL statements using the HDBSQL command-line tool.

  1. SAP HANA Studio

  2. DBA Cockpit

  3. HDBSQL Command

  4. Line Tool

Know the system requirements and supported Platforms to install SAP HANA studio.

  1. System Requirements

  2. Supported Platforms

  3. Install SAP HANA Studio

 

Understand how to monitor HANA Landscape, HANA Security, Start, Stop the HANA system, and also know the logging on HANA system.

  1. Starting and Stopping SAP HANA System

  2. Displaying Process List

  3. Logging on to HANA system using HANA studio

  4. HANA User Security

  5. Monitoring HANA Landscape

 

Here will focus on Start, Stop SAP HANA Database and also to monitor the HANA landscape.

  1. Starting & Stopping SAP HANA

  2. Starting SAP HANA Database

  3. Stopping SAP HANA Database

  4. Displaying Process List

  5. Monitoring HANA Landscape

  6. Periodic Manual Tasks

 

This session presents you with configuring Steps, Set-up and Architecture for the SLT replication server, and also about positioning, Different types of benefits of SLT.

  1. Positioning and benefit of SLT for SAP HANA

  2. Key benefits of Trigger-Based Approach

  3. Architecture and Building Blocks

  4. Architecture for SAP Source Replication

  5. Architecture for NON-SAP Source Replication

  6. Set-up of LT replication server

  7. Installation Aspects

  8. Configuration Steps for SLT replication server

  9. Setup Data Replication

  10. Database-Supportability

  11. Landscape strategy of SLT replication server

  12. SLT replication server Installation Options

  13. Technical Requirements and system setup

 

By this module, we will provide you, how to configure, Import HANA Studio for Metadata, and to Load Data via Data Services into SAP HANA.

 

  1. Configuring HANA Studio for importing Metadata

  2. Importing Metadata

  3. Mass Import

  4. Selective Import

  5. Load Data Via Data services into SAP HANA

We’ll give an introduction of SAP HANA Direct Extractor in this module.

  • Introduction to SAP HANA Direct Extractor

Learn, how to enable the services, setup, configuration, and also to provide connections for SAP HANA.

  1. Limitations of DXC

  2. Setup and Configurations

  3. Enabling Services

  4. HTTP Connection and Test Connection

The identity of database users accessing SAP HANA is verified through a process called authentication. In this module we’ll provide, how to create users, assign roles- privileges to the users as well as to the roles for SAP HANA Security.

  1. Create Users

  2. User and Role Concept

  3. Creating Roles

  4. Assigning Privileges to Roles

  5. Privileges

  6. SQL Privileges

  7. System Privileges

  8. Analytic Privileges

  9. Reporting and Privileges

  10. Modeling required Privileges

 

Backup and restore is the process of copying/storing data preemptively for the specific purpose of restoring, that same data in an event such as loss of data in case hardware failure or accidental deletion or corruption of data can be used for restoration.

 

  1. System Configuration Parameters

  2. Monitoring and system state parameters

  3. Backup & Recovery SAP HANA

  4. Need of Backup

  5. Backup Types

  6. Data Backup

  7. Log Backup

  8. Recovery Options

  9. Recovery in Replication Scenarios

  10. Backup to External Backup Destinations

  11. Recovery Scenarios

  12. Power Failure

  13. Disk Failure

Learn, How to monitor SAP HANA, Checking the availability of setting up, system monitoring, an overview of Services, and providing system alerts.

  1. Configuring Remote Support

  2. Solution Manager Integration

  3. Remote Service Connection

  4. Availability Monitoring

  5. Setting up Monitoring

  6. System Monitoring Setup

  7. Status Overview

  8. Services Overview

  9. System Load History

  10. Disk Usage Details

  11. Checking System Configuration

  12. Alerts

This module presents, how to troubleshooting performance in SAP HANA and also configuration to manage log file.

  1. Regular administration tasks

  2. Troubleshooting

  3. Analyzing performance

CASE STUDY COVERING ALL THE ABOVE TOPICS

 

 

SAP HANA is an in-memory database for performing real-time data analysis and the development of applications on top of real-time data.

HANA administration deals with managing the SAP HANA system in a single and distributed system environment.

Target Audience:

  1. Looking forward to establishing a career in the HANA database

  2. Willing to improve their HANA skills  

  3. Involved in the implementation of HANA

Overview SAP S4 HANA Admin

SAP HANA is an in-memory database for performing real-time data analysis and the development of applications on top of real-time data.

HANA administration deals with managing the SAP HANA system in a single and distributed system environment.

Target Audience:

  1. Looking forward to establishing a career in HANA database

  2. Willing to improve their HANA skills  

  3. Involved in the implementation of HANA