For individuals

Recorded Video Learning

  • Access to high quality Videos
  • Self-paced learning content designed by Experts

Instructor Led Live Online Training

  • Live Interactive training
  • Certified & industry expert Trainers
  • On Demand Dedicated Cloud lab access
  • 24x7 Support & Assistance
  • Fast-track / Regular / Weekend

  • Start training at your convenient time
  • For business

    Corporate training

    • Self-paced e-learning and/or instructor-led options)
    • Course, category, and all-access pricing
    • Enterprise-class learning management system (LMS)
    • Enhanced reporting for individuals and teams
    • 24x7 assistance and support

    Course Details

    SAP HANA is a database from SAP built on in-memory technology. SAP HANA usually needs less administration than other databases, HANA Database is 3500 times faster Analytics and 4500 times faster reporting speed. The SAP HANA Studio is the main GUI tool for SAP HANA Administration Certification Training, so the future would be the HANA database with most of the customers.

    SAP HANA Administration Certification Training Overview

    Our training covers the full cycle of administration of SAP Hana solutions. The SAP HANA Administration course aims not only imparting theoretical concepts, but also helps students explore and experiment the subject.

    Each Training Module builds on top of the preceding Module so that the learning process is progressive. The examples given in this training are practical, and you will be able to see the immediate result of your efforts. We will first cover setting up HANA Platform i.e. pre and post installations, Direct extractor configuration and much more, followed by project. By the end of our training, students can confidently update their profiles with knowledge and Hands on experience.

    SAP HANA Administration 2.x Training 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
    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
    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


    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
    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

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

    Regular administration tasks
    Analyzing performance
    Auditing SAP HANA
    Global Audit Configuration
    Manage Audit Policies
    Audit Events
    Audit Trail


    Our trainers have relevant experience in implementing real-time solutions on different queries related to different topics. Mindmajix verifies their technical background and expertise.

    We record each LIVE class session you undergo through and we will share the recordings of each session/class.

    Trainer will provide the Environment/Server Access to the students and we ensure practical real-time experience and training by providing all the utilities required for the in-depth understanding of the course.

    If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within 48 hours of initial registration. Please make a note that refunds will be processed within 30 days of prior request.

    The Training itself is Real-time Project Oriented.

    Yes. All the training sessions are LIVE Online Streaming using either through WebEx or GoToMeeting, thus promoting one-on-one trainer student Interaction.

    There are some Group discounts available if the participants are more than 2.

    As we are one of the leading providers of Online training, We have customers from USA, UK, Canada, Australia, UAE, Qatar, NZ, Singapore, Malaysia, India and other parts of the world. We are located in USA. Offering Online Training in Cities like

    Minneapolis, Melbourne, Jacksonville, Davidson, Murfreesboro, Auckland, Carlsbad,  San Marcos, Tacoma, Bellevue, Garland, Raleigh-Cary, Fort Lauderdale, Miami, Toronto, Wellington, Gilbert, Tempe, Alexandria, Chandler, Scottsdale, Peoria, Honolulu, Raleigh, Nashville, Plano, Montreal, Calgary, Edmonton, Saint John, Vancouver, Richmond, Mississauga, Saskatoon, Kingston, Kelowna, Hyderabad, Bangalore, Pune, Mumbai, Delhi, Dubai, Doha, Brisbane, Perth etc…

    • SAP HANA Administration Training Washington, DC
    • SAP HANA Administration Training Virginia
    • SAP HANA Administration Training New Jersey
    • SAP HANA Administration Training Illinois
    • SAP HANA Administration Training North Carolina
    • SAP HANA Administration Training California
    • SAP HANA Administration Training Maryland
    • SAP HANA Administration Training Georgia
    • SAP HANA Administration Training Texas
    • SAP HANA Administration Training New York
    • SAP HANA Administration Training San Francisco
    • SAP HANA Administration Training Oregon
    • SAP HANA Administration Training Ohio
    • SAP HANA Administration Training Florida
    • SAP HANA Administration Training Seattle
    • SAP HANA Administration Training Chicago
    • SAP HANA Administration Training Dallas
    • SAP HANA Administration Training Los Angeles
    • SAP HANA Administration Training Baltimore
    • SAP HANA Administration Training Houston
    • SAP HANA Administration Training San Diego
    • SAP HANA Administration Training Santa Clara
    • SAP HANA Administration Training Columbus
    • SAP HANA Administration Training Towson
    • SAP HANA Administration Training Salt Lake City
    • SAP HANA Administration Training Austin
    • SAP HANA Administration Training Sunnyvale
    • SAP HANA Administration Training Franklin
    • SAP HANA Administration Training Orlando
    • SAP HANA Administration Training Boston
    • SAP HANA Administration Training San Jose
    • SAP HANA Administration Training St. Louis


    Course Reviews


    890 ratings
    • 5623
    • 4134
    • 389
    • 236
    • 19

    Drop Us A Query

    Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
    Course Adviser

    Fill your details, course adviser will reach you.