SAP Hana Administration Online Training

SAP Hana Administration Online Training


    Introduction to SAP HANA Landscape:

    • SAP HANA & S4 HANA – Short Introduction
    • SAP HANA Information Sources

    SAP HANA Architecture:

    • SAP HANA Memory Management and Data persistence
    • Software Packaging
    • SAP HANA Roadmap and Scenarios
    • Deployment options

    Preparing Installation:

    • Sizing of the SAP HANA
    • SAP HANA In-Memory Database Sizing elements
    • RAM, Disk, CPU
    • Memory Sizing
    • CPU Sizing
    • SAP HANA Scale Out / Scale UP
    • Directory Structure


    • Introduction SAP HANA Lifecycle Management Tools
    • SAP HANA Studio installation
    • Installation steps (CUI / GUI)
    • Advanced installation options (Batch Mode)
    • Performing a Distributed System Installation / Multi node installations.
    • High-Available installations
    • System Replications (Primary to Secondary)

    Post Installation:

    • Post-Installation Steps
    • SHINE – SAP HANA Interactive Education
    • HANA-Live installations and Schema mapping
    • Updating SAP HANA
    • Revision strategy of SAP HANA

    SAP HANA Tool Overview:

    • SAP HANA studio for administrator
    • DBA Cockpit

    System Administration SAP HANA:

    • This section describes all basic administration and monitoring tasks including:
    • Setting up multitenant database containers
    • System configuration (INI files)
    • Monitoring (for example, performance, memory usage, disk usage, alert situations)
    • Lifecycle management
    • Diagnosing and troubleshooting problems and error situations
    • Backup and Recovery:

    Concept of backup and Recovery:

    • Data area Backup
    • Log area Backup
    • Recovery
    • Data base Copy
    • DR setup and System Replication


    • Security Overview
    • Authentication and Authorization
    • Auditing

    User Management:

    • Type of Privileges
    • Roles
    • Exercise

    SAP HANA Monitoring:

    • Log Configuration
    • Monitoring and Alerting:
    • Error Messages
    • Diagnostic Files
    • Server side traces
    • Client side traces

    Tools for Performance Analysis:

    • Load Diagram
    • Plan Viz

    Scale out Systems and High Availability:

    • Scaling out SAP HANA system
    • High Availability with auto failover
    • Client connect in Distributed systems

    Session and Threads:

    • Introduction to Session and Threads
    • Process and Threads
    • Monitoring sessions and Transactions

    Working with Objects and Repository:

    • Common properties of database objects
    • Properties of HANA Repository
    • Creating and editing objects in HANA studio
    • Deleting development object in HANA studio


    • SQL Overview
    • SAP HANA HDBSQL Commands
    • SAP HANA HDBSQL Command Line Options
    • Log On to a Database

     SAP HANA Admin Tasks:

    • Renaming HANA DB using HDBLCM Tool
    • Multitenant Database Container
    • System Copy – HANA Studio and SWPM tool
    • DATA provisioning using SAP Landscape transformation (SLT)
    • Patch Update on SAP HANA DB
    • Performance tuning
    • Configure data replication with sap data service
    • Managing Multitenant Database Containers.
    • Preparing and Configuring DMO operation


    • On Premise S4 HANA Server (2 count)
    • ECC EHP7 Server (1 count)
    • More than 12 years industry experience on SAP Basis & HANA Technologies
    • Online and Class room facilities available
    • Corporate training available

    Write a Review

    Your email address will not be published. Required fields are marked *

    Course Reviews


    • 5 stars0
    • 4 stars0
    • 3 stars0
    • 2 stars0
    • 1 stars0

    No Reviews found for this course.

    • 4 weeks, 2 days
    Contact Us

    +1 475-212-0075

    Drop us a query

      Your Details

      * Required

      Job Support

        Your Details

        * Required

        Course Features

        Live Instructor-led Classes

        This isn't canned learning. Its dynamic, its interactive, its effective

        Expert Educators

        Only the best or they're out. We are constantly evaluating our trainers

        24&7 Support

        We never sleep. Need something answered at 3 am? No Problem

        Flexible Schedule

        You don't learn as per our calendar. We work according to yours.

        Customized Training's

        The most part self-managed and adaptable to suit a person's particular adapting technology needs

        Priority Based Training's

        Real-time Scenario based Assignments and Case Studies