Home > Courses > Technical > HANA ADMIN

SAP HANA ADMIN TRAINING IN HYDERABAD

178 Ratings

Course Duration : 50h

Course Level : Beginner

About the Course

SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data. HANA administration deals with managing SAP HANA system in a single and distributed system environment. Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning. SAP HANA system administrators are responsible for ensuring the efficient and continuous operation of all SAP HANA databases deployed in the corporate environment. As with any business-critical solution, proper management of SAP HANA requires a solid understanding of its internal mechanics to interpret the metrics that are monitored and their impact on system and application performance, as well as its administration and tooling capabilities to plan and execute a suitable database management strategy.

Description

  • SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data.
  • HANA administration deals with managing SAP HANA system in a single and distributed system environment.
  • Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning.
  • You can use Smart data access to get the data from non-SAP systems without importing the data to HANA database, and virtual tables can be used to perform read/write data operations
  • Integration of SAP HANA into different remote systems. Exposure to different remote access options in HANA system.
  • Experience in monitoring, tuning, and troubleshooting of SAP HANA systems.
  • HANA system administration using SAP HANA Cockpit and HANA Studio.
  • Experience in managing users and roles in SAP HANA system.
  • Implementing SAP HANA Table management techniques – data compression, table partition, compression techniques, and load/unload table into memory.
  • HANA Installation, Data Provisioning, Admin, Modelling.
  • SAP BusinessObjects and HANA integration, Design document, RFPs, and estimation plans.
  • Experience with high availability and backup mechanism.
  • Implementing SAP HANA Security mechanism, HANA XS Application service, and monitoring of HANA system.

Those who have good knowledge on SAP Basis and HANA system concepts.

This  course is for who have good knowledge on SAP Basis and HANA system concepts. After completing this tutorial, you will find yourself at a moderate level of expertise in administration and management of SAP HANA in multitenant environment.

You should have a good exposure to SAP HANA in-memory concepts, HANA Studio, and different options in HANA studio. f you are not aware of these concepts, then we recommend that you first go through  SAP HANA and Basis courses.

Key Features

Instructor-Led Sessions

50 Hours of Online Live Instructor-Led Classes. Weekend Classes: 24 sessions of 2 hours each. Weekday Classes: 50 sessions of 1 hour each.

Real-Life Case Studies

Live project based on any of the selected use cases, involving implementation of the various concepts.

Assignments

Each class will be followed by practical assignments.

Lifetime Access

You get lifetime access to LMS where presentations, quizzes, installation guide & class recordings.

24 X 7 Expert Support

We have 24×7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.

Certification

After completing your final course project successfully emax will provide you certificate as a SAP Trainee.

Curriculum

  • Introduction to SAP HANA
  • SAP HANA Scenarios
  • SAP HANA Database Architecture
  • Persistence Layer
    • Data Volume
    • Log Volume
  • SAP HANA Network Zones
  • Revision strategy of SAP HANA
  • Software Packaging
  • On-Premise
  • In the Cloud
  • Hybrid
  • Technical Deployment Options
    • SCOS
    • MCOS
    • MCOD
  • SAP HANA Data Provisioning (SLT)
  • As Primary Persistence
    • BW powered by HANA
    • Business suite powered by HANA
    • S/4 HANA
  • As Platform
  • Hardware and Software Requirements
    • Supported Hardware Platforms
    • Supported Operating Systems for SAP HANA
  • SAP HANA Memory Management and Persistence
  • Recommended File System Layout
  • SAP HANA System Concepts
  • Host
  • System
  • Instance (HDB)
  • System Database
  • Tenant Databases
  • SAP HANA System Types
  • Single-host system
  • Multiple-host (distributed) system
  • LCM as a graphical user interface
  • LCM as a command-line interface
  • LCM as a Web user interface
  • LCM Parameters Call Options
  • Preparing an Installation – Sizing of SAP HANA (RAM, CPU, Disk)
  • Greenfield / New implementation Sizing
  • Brown Field / Migration Sizing
  • Platform Software Components
  • Software Download Location
  • Software Authenticity Verification

Installation Paths

  • Getting Started with SAP HANA System Installation
    • Mandatory Installation Values
    • Changeable Default Values for Installation
    • Users Created During Installation
    • Specifying Passwords using various methods
  • Installing a Single-Host HANA System
  • Install and Update HANA Studio
  • Ports and Connections
  • Host Name Resolution
  • Update HANA Database
  • Update Dependent Components
  • Getting Started with SAP HANA System Installation
    • Mandatory Installation Values
    • Changeable Default Values for Installation
    • Users Created During Installation
    • Specifying Passwords using various methods
  • Installing a Single-Host HANA System
  • Install and Update HANA Studio
  • Ports and Connections
  • Host Name Resolution
  • Update HANA Database
  • Update Dependent Components
  • Locating all SAP HANA File System Components
  • Checking the Log Files
  • Repairing a Partially Installed System
  • Enabling the Installer Trace
  • Start and Stop the SAP HANA System
  • Display the Process List
  • Periodic Tasks
  • Scheduling of Recurring Administration Tasks
  • Uninstall the SAP HANA System Using the Graphical User Interface
  • Uninstall the SAP HANA System Using the Command-Line Interface
  • SAP HANA Studio Installation and Update
    • Open the SAP HANA Administration Console
    • Execute SQL Statements in SAP HANA Studio
    • Managing SAP HANA Systems in SAP HANA Studio
  • SAP HANA Cockpit Installation and Configuration
    • Set up SAP HANA Cockpit for the First Time
    • Open SAP HANA Cockpit
    • Security Aspects of SAP HANA Cockpit
  • DBA Cockpit for SAP HANA
  • Authorizations for DBA Cockpit
  • Start DBA Cockpit for SAP HANA
  • Setting Up Database Connections
  • Administration and Monitoring Functions
  • HDBSQL Command Line Tool
    • SAP HANA HDBSQL Options
    • Log On to a Database and Run Commands
  • The System Database
  • Server Architecture of Tenant Databases
  • Creating and Configuring Tenant Databases
  • Converting an SAP HANA System to Support Tenant Databases
  • Cross-Database Access
  • Database Isolation
  • Database-Specific Configuration Parameters
  • Administration of Tenant Databases
  • Create a Tenant Database
  • Start / Stop a Tenant Database
  • Rename a Tenant Database
  • Delete a Tenant Database
  • Disable Features on a Tenant Database
  • Add or Remove Services in a Tenant Database
  • Configuring Memory and CPU Usage for Tenant Databases
  • Cross-Database Access
  • Database Isolation
  • Database-Specific Configuration Parameters
  • Administration of Tenant Databases
  • Create a Tenant Database
  • Start / Stop a Tenant Database
  • Rename a Tenant Database
  • Delete a Tenant Database
  • Disable Features on a Tenant Database
  • Add or Remove Services in a Tenant Database
  • Configuring Memory and CPU Usage for Tenant Databases
  • Change, Reset a System Property
  • System Properties in Multiple-Container Systems
  • Configure System Usage Type
  • Reserve Connections for Administrators
  • Initial Administration Tasks
  • Regular Administration Tasks
  • On-Demand Administration Tasks
  • Analysing Generic Symptoms
  • Performance and High Resource Utilization
  • Slow System-wide Performance
  • Slow Individual SQL Statements
  • Frequent Out of Memory (OOM)
  • Persistent Data Storage in the SAP HANA Database
  • Memory Usage in the SAP HANA Database
    • Root Causes of Memory Problems
  • Workload Management
    • Workload in the Context of SAP HANA
    • Controlling Parallel Execution of SQL Statements
    • Setting a Memory Limit for SQL Statements
    • Managing Peak Load (Admission Control)
    • Controlling CPU Consumption
  • Troubleshooting an Inaccessible or Unresponsive SAP HANA System
  • Configuring Traces
  • Working with Diagnosis Files
  • SQL Console
  • SAP HANA Scale Out
  • High Availability
  • Faulty Recovery
  • Disaster Recovery
  • Concept of Backup and Recovery
  • Data, Log Area Backup
  • Database Copy
  • Recovery
  • Backup and Recovery using Storage Snapshot
  • Authentication and Authorization in SAP HANA
  • Types of Privileges, Roles
  • SAP HANA User Management
  • Authorization Trace and Auditing
  • Integrative Authorization Scenarios
  • DMO – Conceptional Overview
  • The DMO Procedure in Detail

Course Certification

Reviews

FAQ's

  • You will never miss a lecture at Emax You can choose either of the option: View the recorded session of the class available in your LMS.

     

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

 

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24×7 support team will be granted instantly as well. You can start learning right away.

 

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

SRINIVAS

Sr. SAP HANA ADMIN Consultant
16+ Years of Experience

Upcoming Batches

Scroll to Top