Quick Contact

SAP HANA ADMIN Training In Hyderabad

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.

Upcoming Batches
Mar-21th SAT & SUN (12 WEEKS)
Weekend Batch
Timings – 08:30 AM to 11:30 AM (IST)
Mar-19th MON – FRI (75 DAYS)
Weekdays Batch
Timings – 07:00 AM to 09:00 AM (IST)
Upcoming Batches
Mar 21th SAT & SUN (12 WEEKS)
Weekend Batch
Timings – 08:30 AM to 11:30 PM (IST)
Mar 19th MON – FRI (75 DAYS)
Weekdays Batch
Timings – 07:00 AM to 09:00 AM (IST)
Description

What are the course objectives?

  • 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

What are the roles and responsibilities and methodology of this module?

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

Who should go for this training?

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

What are the skills that you will be learning with this course?

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.

What are the prerequisites to learn this course?

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.

Forum

We have a community forum for all our learners that further facilitates learning through peer interaction and knowledge.
Preview

SAP HANA Architecture

  • 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

SAP HANA Deployment Options

  • On-Premise
  • In the Cloud
  • Hybrid
  • Technical Deployment Options
    • SCOS
    • MCOS
    • MCOD

SAP HANA Use Cases

  • SAP HANA Data Provisioning (SLT)
  • As Primary Persistence
    • BW powered by HANA
    • Business suite powered by HANA
    • S/4 HANA
  • As Platform

SAP HANA System Requirements

  • 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

SAP HANA Platform LCM Tools

  • LCM as a graphical user interface
  • LCM as a command-line interface
  • LCM as a Web user interface
  • LCM Parameters Call Options

SAP HANA Installation and Update Overview

  • 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

Install & Update an SAP HANA System

  • 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

Post Installation Steps

  • Install / Check HANA Licenses
  • Configure the Connection to SAP Service Marketplace
  • Users created during installation
  • Creating a DB User for Update and Rename
  • Enable Automatic Start

Troubleshooting an installation failure

  • Locating all SAP HANA File System Components
  • Checking the Log Files
  • Repairing a Partially Installed System
  • Enabling the Installer Trace

Managing the SAP HANA System After Installation

  • Start and Stop the SAP HANA System
  • Display the Process List
  • Periodic Tasks
  • Scheduling of Recurring Administration Tasks

Uninstalling the SAP HANA System

  • Uninstall the SAP HANA System Using the Graphical User Interface
  • Uninstall the SAP HANA System Using the Command-Line Interface

Admin Tools for SAP HANA

  • 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

SAP HANA Tenant Databases

  • 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

Configuring SAP HANA System Properties (INI Files)

  • Change, Reset a System Property
  • System Properties in Multiple-Container Systems
  • Configure System Usage Type
  • Reserve Connections for Administrators

SAP HANA Database Administration Tasks at a Glance

  • Initial Administration Tasks
  • Regular Administration Tasks
  • On-Demand Administration Tasks

Managing and Monitoring the Performance of SAP HANA

  • 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

Availability and Scalability

  • SAP HANA Scale Out
  • High Availability
  • Faulty Recovery
  • Disaster Recovery

SAP HANA Database Backup and Recovery

  • Concept of Backup and Recovery
  • Data, Log Area Backup
  • Database Copy
  • Recovery
  • Backup and Recovery using Storage Snapshot

SAP HANA Security / Authorization

  • Authentication and Authorization in SAP HANA
  • Types of Privileges, Roles
  • SAP HANA User Management
  • Authorization Trace and Auditing
  • Integrative Authorization Scenarios

Migration to SAP HANA Using SUM DMO

  • DMO – Conceptional Overview
  • The DMO Procedure in Detail

Reviews
FAQs

WHAT IF I MISS A CLASS?

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.

WHAT IF I HAVE QUERIES AFTER I COMPLETE THIS COURSE?

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.

HOW SOON AFTER SIGNING UP WOULD I GET ACCESS TO THE LEARNING CONTENT?

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.

IS THE COURSE MATERIAL ACCESSIBLE TO THE STUDENTS EVEN AFTER THE COURSE TRAINING IS OVER?

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
Find SAP ABAP Certification Training in other cities
Delivered By

Srinivas

Sr. SAP HANA ADMIN Consultant

16+ Years of Experience

Contact Us

040 6666 6768

Comments are closed.