SAP Hana Admin

1 Courses 2 Projects 25 Hours


In this training, you will study HANA Studio to develop an SAP HANA database in the format of a GUI tool. Through this course, you will learn concepts like SAP HANA Editors, SAP HANA Architecture, SAP HANA Tools, SAP HANA Operations and etc. To know more about the course enrol now!

Course Fee

Can’t find a batch you were looking for?

Let us know

Key Features

  • Flexible Schedule
  • 24 x 7 Lifetime Support
  • Certification
  • Instructor Led Training


Download Curriculum

  • Introduction to SAP HANA SAP
  • In-Memory Strategy
  • In-Memory Computing
  • Hardware-Innovations
  • Software-Innovations
  • SAP HANA simplified Architecture
  • SAP HANA Extended Architecture
  • Business Intelligence Clients with HANA
  • HANA Columnar Store
  • SAP HANA row store vs Columnar Storage
  • HANA 1.0 SPS1
  • HANA 2.0 SPS 2 – New Features
  • SAP HANA Platform Edition
  • SAP HANA Enterprise Edition
  • SAP HANA Enterprise Extended Edition
  • RAM, Disk, CPU
  • Memory Sizing CPU Sizing
  • SAP HANA Scale Out
  • 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 Modeller
  • Architecture Overview
  • IMCE and Surroundings
  • HANA Row Store
  • Column Store
  • Loading data into HANA
  • Data Modeling in HANA
  • Persistent Layer in HANA
  • Backup & Recovery
  • Prepare HANA Installation parameters
  • Users created during HANA Installation
  • HANA Required Installation media
  • Prepare Installer Configuration file
  • HANA Components installed by Installer
  • Command based Installation
  • GUI based HANA Installation
  • 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
  • Starting and Stopping SAP HANA System
  • Displaying Process List
  • Logging on to HANA system using HANA studio
  • HANA User Security
  • Monitoring HANA Landscape
  • Starting & Stopping SAP HANA
  • Starting SAP HANA Database
  • Stopping SAP HANA Database
  • Displaying Process List
  • Monitoring HANA Landscape
  • Periodic Manual Tasks
  • 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
  • Database-Supportability
  • Landscape strategy of SLT replication server
  • SLT replication server Installation Options
  • Technical Requirements and system setup
  • Creating Data sources
  • 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
  • Create Users
  • User and Role Concept
  • Creating Roles
  • Assigning Privileges to Roles
  • Privileges
  • SQL Privileges
  • System Privileges
  • Analytic Privileges
  • Reporting and Privileges
  • Modelling required Privileges
  • System Configuration Parameters
  • Monitoring and system state parameters
  • Backup & Recovery SAP HANA
  • Need of Backup
  • Backup Types
  • Data Backup
  • Log Backup
  • Recovery Options
  • Recovery in Replication Scenarios
  • Backup to External Backup Destinations
  • Recovery Scenarios
  • Power Failure
  • Disk Failure
  • 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, Alerts
  • Regular administration tasks
  • Troubleshooting
  • Analyzing performance
  • Configure System Replication for System
  • Enable System Replication
  • Registering Secondary System
  • Unregistering Secondary System
  • Perform Takeover
  • Table partitioning (Hash/Range)
  • Single System DB to MDC
  • Creating Tenant DB
  • Dropping Tenant DB
  • Cross Tenant DB access
  • Introducing SAP HANA Cockpit 2.0
  • Installing SAP HANA Cockpit 2.0
  • Install SAP HANA Cockpit 2.0
  • Configuring SAP HANA Cockpit 2.0
  • Configure and Open SAP HANA Cockpit 2.0

Need customized curriculum?

Talk to Us


SAP Hana Admin Certification

SLearn certification is awarded, after successful completion of the project work which shows that trainee have learned, achieved skills and experiences from the project. All the acknowledged trainees are therefore eligible for challenging projects and better job opportunities in MNC's like TCS, IBM, Cisco, Cognizant, Wipro, Dell etc.

Get Sample Certificate


Free Career Counselling

We are happy to help you