HANA Admin Online Training

HANA Admin Training


The SAP HANA Admin Online Training and Operations training course allows you to learn and apply different configuration tasks for operating and administrating SAP HANA database. we offer the simplest online classes for mastering SAP HANA Studio, DBA Cockpit, data provisioning, data replication, monitoring and troubleshooting of SAP HANA.

what is the Hana administration-
SAP HANA is an in-memory database for performing constant information examination, and improvement of utilizations on the highest point of ongoing information. HANA organization manages to oversee the SAP HANA framework in a solitary and conveyed framework condition. Each HANA framework can contain a multi-hub design with every hub containing different processors for quick speed information investigation and ongoing information provisioning. You can utilize Smart information access to urge the knowledge from non-SAP frameworks without bringing within the information to the HANA database, and virtual tables are often utilized to perform read/compose information activities

SAP HANA Administration incorporates the accompanying exercises −

• SAP HANA various host framework the board
• SAP HANA Administration Tools
• SAP HANA System Management and Availability
• SAP HANA Lifecycle Management
• SAP HANA Security and User Management
• SAP HANA Backup and Recovery Management
• SAP HANA Data Provisioning & Integration with non-SAP frameworks

Each SAP framework contains various servers and it tends to be checked in HANA Studio under the Administration tab. SAP HANA Studio contains Administration Perspective (default) to deal with all administrator assignments in HANA frameworks.
To check the scene of the HANA framework, explore to Landscape tab in the HANA studio. Administrations show every one of the administrations running on the HANA framework.
What is SAP HANA administration-

An SAP HANA framework involves all the server segments of an establishment of SAP HANA
An SAP HANA framework comprises of a few servers, the most significant of which is the recording server. The recording server contains the real information stores and the motors for preparing the information.
A numerous host or conveyed SAP HANA framework is a framework that is introduced on more than one host. Else, it is a solitary host framework. A host is a machine (involved CPU, memory, stockpiling, arrange, and working framework) that runs portions of the SAP HANA framework.
An SAP HANA example is the arrangement of server parts of a circulated framework that are introduced on one host. The accompanying figure shows a dispersed framework with three hosts, which each run a name server, file server, etc.
SAP HANA underpins numerous separated databases in a solitary SAP HANA framework. These are alluded to as multitenant database holders.
An SAP HANA framework introduced on numerous hosts is distinguished by a solitary framework ID (SID). It is seen as one unit from the point of view of the director, who can introduce, update, fire up, shut down, or reinforce the framework in general. The distinctive server segments of the framework share similar metadata and solicitations from customer applications are often straightforwardly dispatched to varied servers within the framework.

Does SAP Hana use SQL-

SQL Stands for Structured Query Language. It is a Standard Language for speaking with Relational databases like Oracle, MySQL and so forth. SQL is utilized to store, recover and change the information in the database.

By utilizing SQL in SAP HANA, we can perform the following occupation

• Mapping definition and use (CREATE SCHEMA).
• DDL Statement ( CREATE, ALTER, DROP )
• DCL Statement ( GRANT, REVOKE)
• Framework Management
• Session Management
• Exchange Management

Is SAP Hana a database-

SAP HANA Database – SAP HANA Database is a half and a half in-memory database. SAP HANA Database is the core of SAP in-memory innovation.

In SAP HANA, Database table are of two sorts –

• Line Store
• Segment Store

SAP HANA Platform – SAP HANA Platform is an improvement stage with an in-memory information store which enables the clients to investigate an enormous volume of information progressively. SAP HANA Platform fills in as an advanced stage, which gives framework and instruments to building a superior application dependent on SAP HANA Extended Application Services (SAP HANA XS).


  • What is SAP HANA?
  • SAP HANA Components
  • SAP HANA Scenarios- SAP Hana Administration Training
  • Rapid Deployment Solutions RDS
  • SAP HANA information Sources
  • SAP HANA Persistence
  • Sizing SAP HANA
  • SAP HANA Scale Out
  • SAP HANA Studio
  • DBA Cockpit
  • HDBSQL Command Line Tool
  • Preparing SAP HANA Installation
  • Review SAP HANA Installation
  • Post Installation Steps
  • Starting and Stopping SAP HANA
  • Configuring SAP HANA
  • Periodic Manual Tasks- SAP Hana Administration Training
  • Concept of Backup and Recovery
  • Data Area Backup
  • Log Area Backup
  • Backup of Configuration Files and Backup Catalog
  • Recovery- SAP Hana Administration Training
  • Database Copy
  • High Availability
  • User Management
  • Types of Privileges
  • Standard Roles
  • Administrative Tasks
  • Authentication Methods
  • Information Sources for Administrators and Auditing
  • Positioning and Key Concepts
  • Landscape Strategy and Sizing Aspects
  • Installation Procedure
  • Configuration Aspects- SAP Hana Admin Online Course
  • Data Replication at a glance
  • Monitoring of Replication
  • Other Operation Aspects
  • SAP Data services and SAP HANA
  • Configure SAP Data Services
  • Configure SAP HANA Studio
  • Load Data into SAP HANA- SAP Hana Administration Training
  • Introduction to SAP HANA Direct Extractor connection (DXC)
  • SAP HANA Direct Extractor Connection Setup & Configuration- SAP Hana Administration Training
  • Monitoring with SAP HANA Studio
  • Monitoring with DBACOCKPIT
  • Monitoring with SOLMAN ( In theory)
  • Remote Support- SAP Hana Administration Training
  • SAP Early Watch Alert
  • Transport Changes
  • Updating SAP HANA
  • Configure System Replication for System
  • Enable System Replication
  • Registering Secondary System
  • Unregistering Secondary System

1 Review

Mounika A

It was good experience with trainer. The teaching skills are good and interact and answering every questions asked by me. Trainer had good knowledge and explained the most of the concepts with real time scenarios.

Write a Review

WhatsApp chat

Schedule a demo

We will schedule the demo with an expert trainer as per your time convenience.

Have a query?

we'd love to assist and help you on anything related to IT courses.