SAP HANA Administration Training

  • (4.5)
  • 1259 Ratings
  • Learners : 1284
Try Live Demo

Trusted By Companies Worldwide & 32,052+ Learners

  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo
  • Client Logo

SAP HANA Administration Course Overview

SAP HANA Administration training Provided by Tekslate enables you to learn and implement various configuration works for operating and monitoring the SAP HANA database. In this training, you will study about HANA Studio to develop an SAP HANA database in the format of a GUI tool. Through this training, you will learn concepts like SAP HANA simplified and extended architecture, Hardware and Software Innovations, HANA Compare to BWA, etc. 
Course Duration 30 hrs
Live Projects 2
Next Batch 30 May, 2020

SAP HANA Administration Course Curriculum

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.
Introduction to SAP HANA SAP
In-Memory Strategy
HANA compare to BWA
In-Memory Computing
Hardware-Innovations
Software-Innovations
SAP HANA simplified Architecture
SAP HANA Extended Architecture
Business Intelligence Clients with HANA
HANA Columnar Store
SAP HANA row store vs Columnar Storage

Learn different versions of SAP HANA in this module..
HANA .0 SPS03
HANA .0 SPS04—NEW Features
HANA .0 SPS05—NEW Features
HANA .0 SPS06—NEW Features
HANA .0 SPS07—NEW Features
HANA .0 SPS08—NEW Features
HANA .0 SPS09—NEW Features

This module focus 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.
SAP HANA Platform Edition
SAP HANA Enterprise Edition
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.
SAP HANA In-Memory Database Sizing elements
RAM, Disk, CPU
Memory Sizing
CPU Sizing
SAP HANA Scale Out

What are the steps to be configured during PRE, POST installations of SANA HANA and also gives you a brief overview about it.
Preparing SAP HANA Installation
Reviewing SAP HANA Installation
Post-Installation steps

Understand about Memory computing studio, Switching between different views and about system monitor in HANA.
In-Memory Computing Studio
Administration view
HANA Navigator View
System Monitor in HANA
Information Modeler

In this module, we will explain about the architecture of HANA, How to apply Backup and Recovery to the entire database and different storage formats in HANA.
Architecture Overview
IMCE and Surroundings
HANA Row Store
Column Store
Loading data into HANA
Data Modeling in HANA
Persistent Layer in HANA
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..
Prepare HANA Installation parameters
Users created during HANA Installation
HANA Required Installation media
Prepare Installer Configuration file

Learn, How to install SAP HANA from GUI as well as from Command prompt and also learn what are the  components of HANA..
SAP HANA unified Installer, Tool Unified Installer to install the Sap HANA SERVER
HANA Components installed by Installer
Command based Installation
GUI based HANA Installation

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

Know the system requirements and supported Platforms to install SAP HANA studio..
System Requirements
Supported Platforms
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.
Starting and Stopping SAP HANA System
Displaying Process List
Logging on to HANA system using HANA studio
HANA User Security
Monitoring HANA Landscape

Here will focus on Start, Stop SAP HANA Database and also to monitor HANA landscape..
Starting & Stopping SAP HANA
Starting SAP HANA Database
Stopping SAP HANA Database
Displaying Process List
Monitoring HANA Landscape
Periodic Manual Tasks

This session presents you about configuring Steps, Set-up and Architecture for SLT replication server and also about positioning, Different types of benefits of SLT.
Positioning and benefit of SLT for SAP HANA
Key benefits of Trigger-Based Approach
Architecture and building Blocks
Architecture for SAP Source Replication
Architecture for NON-SAP Source Replication
Set-up of LT replication server
Installation Aspects
Configuration Steps for SLT replication server
Setup Data Replication
Database-Supportability
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup

In this module, we will provide you, how to configure, Import HANA Studio for Metadata and to Load Data via Data Services into SAP HANA…
Configuring HANA Studio for importing Metadata
Importing Metadata
Mass Import
Selective Import
Load Data Via Data services into SAP HANA

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

CONNECTION (DXC)
Learn, how to enable the services, setup, configuration, and also to provide connections for SAP HANA.
Limitations of DXC
Setup and Configurations
Enabling Services
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.
Create Users
User and Role Concept
Creating Roles
Assigning Privileges to Roles
Privileges
SQL Privileges
System Privileges
Analytic Privileges
Reporting Privileges
Modeling required Privileges

Backup and restore is the process of copying/storing data preemptively for the specific purpose of restoring, that same data can be used for restoration in an event such as loss of data in case hardware failure or accidental deletion or corruption of data.
System Configuration Parameters
Monitoring and system state parameters
Backup & Recovery SAP HANA
Need for Backup
Backup Types
Data Backup
Log Backup
Recovery Options
Recovery in Replication Scenarios
Backup to External Backup Destinations
Recovery Scenarios
Power Failure
Disk Failure

Learn, How to monitor SAP HANA, Checking the availabililty of  setting up, system monitoring, overview of  Services and providing system alerts.
Configuring Remote Support
Solution Manager Integration
Remote Service Connection
Availability Monitoring
Setting up Monitoring
System Monitoring Setup
Status Overview
Services Overview
System Load History
Disk Usage Details
Checking System Configuration
Alerts

This module presents, how to troubleshoot performance in SAP HANA and also configuration to manage log file.
Regular administration tasks
Troubleshooting
Analyzing performance
Auditing SAP HANA
Global Audit Configuration
Manage Audit Policies
Audit Events
Audit Trail

HANA DB Software and Hardware Technology Innovations
HANA DB Editions
HANA DB Modules
HANA DB Architecture
HANA DB Phases
HANA Admin -High Availability
HANA DB , H/W,Sizing,Editions. IMCE, IC
Suse Linux OS Installation with respect to HANA (Planning,S/W Requirements,Issues)
HANA DB Server Installation (Planning,S/W Requirements,Issues,Testing)
HANA Admin -Backup
HANA Admin -Recovery
HANA Admin -User Management
HANA Admin -Privelages
HANA Admin -Alerts
HANA Admin -Memory Management
HANA Admin -Admin Performance
HANA Admin -Admin Configurations
HANA Admin -Traces
HANA Admin -Security
HANA Admin -Starting and Stoping
HANA Admin - HD Studio configuration
HANA Admin -Deployment
HANA Admin -Upgrading Service Pack/revision
HANA Admin -Scaling
HANA Admin - License Keys
HANA Admin - Monitoring
HANA DB Replication Technology_SAP LT  Installation - THEORY
HANA DB Replication Technology_SAP DS Installation - THEORY
HANA DB Replication Technology_SAP DXC  Installation - THEORY
HANA DB  ERP  Installation - THEORY
BW HANA  Installation - THEORY
For Individuals
For Corporates

SAP HANA Administration Upcoming Batches

  • Weekend

    30 May - 29 Jun

    7:00 PM IST
  • Weekend

    6 Jun - 06 Jul

    7:00 PM IST
  • Weekday

    11 Jun - 11 Jul

    7:00 PM IST
  • Weekend

    21 Jun - 21 Jul

    7:00 PM IST
  • Weekday

    30 Jun - 30 Jul

    7:00 PM IST
  • Weekday

    7 Jul - 06 Aug

    7:00 PM IST
  • Schedules Doesn't Suit You ?

    Our Team can set up a batch at your convinient time.

    Let us know

    SAP HANA Administration Course Objectives

    Tekslate’s SAP HANA Training gives you enough skills for the enhancement of your career. Our industry experts training makes you gain proficiency on the essential concepts of the SAP HANA Administration at your planned timings. With the help of this training, your proficiency in SAP HANA Administration attains new level.
    You can earn real-time Knowledge on SAP HANA Versions, SAP HANA Enterprise and Platform Edition, Memory and CPU Sizing, SAP HANA Scale-out, HANA Navigator and administration view, HANA Architecture, Install HANA Studio, Starting and Stopping SAP HANA Database, etc. Our Perpetual live support clears your doubts instantly. Live projects deployed by our industry experts provide you the required experience with real-world environment.

    SAP HANA Administration is crucial for implementing SAP HANA in any industry environment. So, many companies are recruiting SAP HANA Administrators to work with SAP HANA Database.

    System administrators, Database Administrators and SAP BASIS Administrators are suitable for this training.
     

    Good understanding of Database concepts is sufficient for this training.

    During this training, you will gain the ability to:

    • Work with SAP HANA Database.
    • Understand SAP HANA Technology.
    • Learn about HANA Studio for administration purpose.
       

    Have More Questions

    Contact us

    SAP HANA Administration Course FAQ's

    Have questions? We’ve got the answers. Get the details on how you can grow in this course.

    We have a strong team of professions who are experts in their fields. Our trainers are highly supportive and render a friendly working environment to the students positively stimulating their growth.
     

    We will share you the missed session from our recordings. We at Tekslate maintains a recorded copy of each live course you undergo.
     

    Our Trainers will provide the student with the Server Access ensuring practical real-time experience and training with all the utilities required for the in-depth understanding of the course.
     

    We provide all the training sessions LIVE using either GoToMeeting or WebEx, thus promoting one-on-one trainer student Interaction.
     

    Live training uncovers distinct benefits as they are mighty to reach your desired audience converting your prospects into customers in less time. Pre-recorded videos offer plenty of advantages for entrepreneurs to educate entertain and inspire your audience as long as you want.
     

    Yes. We provide the course materials available after course completion.

    There exist some discounts for weekend batches and group participants if the joiners are more than 2.
     

    If you are enrolled in classes and have paid fees but want to cancel the registration for any reason, we will attain you in 48 hours will be processed within 30 days of prior request.
     

    You can contact our Tekslate support team, or you can send an email to info@tekslate.com for your queries.
     

    Have More Questions. Reach our Support Team

    Contact us

    Join a Free SAP HANA Administration Demo Session

    See if this course is a fit for you by joining us for an online info session. You’ll meet our team, get an overview of the curriculum and course objectives, and learn about the benefits of being a student at Tekslate

    Attend a Demo Session | Meet the Expert Who Can Kickstart Your Career in SAP HANA Administration

    By providing us with your details, We wont spam your inbox.