Skip to content

Bundle Course - SAP HANA and SAP HANA Admin

Self-paced Videos, Full course with each topic covered in depth, SAP Certification prep, Course Completion Certificate



Save 90%
£20 inc VAT (was £200)
Offer ends 30 September 2021
Study method
Online, self-paced
30 hours
Access to content
Lifetime access
No formal qualification
Additional info
  • Certificate of completion available and is included in the price

4 students purchased this course

Add to basket or enquire


SAP HANA is an in-memory database technology encompassing various components which makes it a complete package or suite for a centralized ERP system and business application development. The multi-core processing engines process data parallels within different columns of the same database and return data to the clients in no time. SAP HANA is the first technology which use for both OLTP and OLAP application processing.

In-memory technology promises the extremely fast analysis and aggregation of huge amounts of data. It removes the limits known from traditional databases. The software has been optimized to take advantage of modern hardware architectures and heavily uses parallel processing. SAP Hana is an in-memory, column-oriented RDBMS. It serves as a database server that stores and retrieves huge volumes of data I real-time.

HANA administration deals with managing SAP HANA system in a single and distributed system environment. SAP Hana Administration includes the following activities

  • SAP HANA Administration Tools
  • SAP HANA Lifecycle Mangement
  • SAP HANA Backup and Recovery Mangement
  • SAP HANA Security and User Management
  • SAP Hana Multiple host system management

The roles and responsibilities of Hana Basis Administrator

  • Create and configure connection SLT to HANA
  • Create and configure connection SLT TO ECC
  • Initial Configuration of SLT Replication Server
  • Configure alerts in DS, ST to monitor load failures
  • Hana Database security
  • Expertise in Hana studio
  • Integration of ECC with HANA Database using the SLT Replication Servers or services
  • Starting and stopping of Sap Hana systems

Uplatz provides a complete end-to-end course covering all topics of SAP HANA and SAP HANA Admin in detail.

Course media


  • Bundle Course - SAP HANA and SAP HANA Admin - Course Syllabus - download


Bundle Course - SAP HANA and SAP HANA Admin - Course Syllabus



Lesson 1: SAP HANA Foundation

Lesson 2: Deployment Strategies

· On-Premise
· On-Cloud
· Side-Car

Lesson 3: Architecture of SAP HANA

Lesson 4: Replicating Data to SAP HANA

· Business Objects Data Services (BODS)
· SAP Landscape Transformation (SLT)

Lesson 5: SAP HANA Studio Interface

· Attribute View
· Analytic View
· Calculation View
· Catalog - Schemas, HANA Live Package
· SAP HANA - SQL Overview
· SAP HANA Transports Options

Lesson 6: SAP HANA Reporting Overview (BOBJ)

· BO Crystal Reports Enterprise
· BO CMC (Admin-SSO)
· BO AO (Analysis Office)
· BO Design Studio
· SAP Lumira & Smart Business Client
· SAP Fiori& SAP NetWeaver Business Client7

Lesson 7: SAP HANA System Monitoring & Administration

· DBA Cockpit
· Database Migration Option (DMO)

Lesson 8: SAP HANA Security & Authorization

· User Management
· Role Management

Lesson 9: Advanced Features Overview

· SAP Predictive Analytics on HANA
· SAP BW-BPC embedded on HANA
· Rapid Deployment Solutions (RDS) for HANA
· SAP Activate Solution Manager for SAP HANA



Lesson 01 - SAP HANA Architecture

- 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 store
- Understanding Columnar Storage

Lesson 02 - SAP HANA Edition

- SAP HANA Enterprise Edition
- SAP HANA Enterprise Extended Edition (As of SPS03)
- SAP HANA Platform Edition

Lesson 03 - SAP HANA Sizing

- SAP HANA In-Memory Database Sizing elements
- RAM, Disk, CPU
- Memory Sizing
- Disk Sizing
- CPU sizing

Lesson 04 - SAP HANA Versions

- HANA 1.0 SPS03
- HANA 1.0 SPS04—New Features
- HANA 1.0 SPS05—New Features
- HANA 1.0 SPS06—New Features


Lesson 06 - SAP HANA Hardware and Software Requirements

- Certified Hardware
- SLES 11 Sp1
- Preparing file system & directories
- Prepare Installation parameters
- Users created during Installation
- Required Installation media
- Prepare Installer configuration file

Lesson 07 - Installing SAP HANA

- SAP HANA unified Installer Tool
- Running Unified Installer to install the SAP HANA SERVER
- Components installed by Installer

Lesson 08 - Install HANA Client

- Available Clients on Linux
- Available Clients on windows
- Install SAP HANA Client on LINUX Host
- Install SAP HANA Client on Windows Host

Lesson 09 - Install HANA Studio

- System Requirements
- Supported Platforms
- Install SAP HANA Studio on LINUX Host
- Install SAP HANA Studio on Windows Host

Lesson 10 - Post – Installation Steps

- Starting and Stopping SAP HANA System
- Displaying Process List
- Logging on to HANA system using HANA studio
- User Security
- Configuring SUM for HANA
- Automatic Start of HANA
- Applying Support packages and Updates
- Monitoring HANA Landscape

Lesson 11 - Enabling High availability of SAP HANA

- Concept of HANA high- availability
- Disaster Tolerance
- Redundant Hardware
- Distributed System
- Standby Host
- Installation Planning for Distributed System
- Install HANA distributed system
- Monitoring and Configuring Standby Hosts


Lesson 13 - Configuring Data Replication with SLT

Positioning and benefits 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 SAP LT replication server
Installation Aspects
Configuration Steps for SLT replication server
Setup Data Replication
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup Information
DMIS2010 and relevant Support packs
SAP Kernel and DBSL Installation
Creating RFC Connections
Creating DB Connections
Configuring and Monitoring Dashboard
Creating New Configuration for SAP source
- Creating New Configuration for NON-SAP source
- Monitoring of Replication
- Mass Transfer IDS
- IUUC Synchronisation Cockpit
- Data Transfer Monitor
- Backup and Recovery Strategy
- Data Volume Management

Lesson 14 - SAP HANA Direct Extractor Configuration Overview

- Introduction to SAP HANA Direct Extractor Connection (DXC)
- Limitations of DXC
- Setup and Configurations
- Enabling Services
- HTTP connection
- Test Connection

Lesson 15 - Configuring Data Replication with SAP BODS

- SAP BODS 4.0 Architecture
- Configuring BO Data services
- Installing HANA ODBC Driver
- Creating SAP HANA Data store in Data Services
- Creating SAP ERP Data store in Data Services
- Configuring HANA Studio for Importing Metadata
- Import Metadata
- Mass Import
- Selective Import
- Load Data via Data services into SAP HANA


Lesson 17 - Operate SAP HANA

- Starting & Stopping SAP HANA
- Starting SAP HANA Database
- Stopping SAP HANA Database
- Displaying Process List
- Monitoring HANA landscape

Lesson 18 - Configuring SAP HANA DB

- System Configuration Parameters
- Monitoring and system state Parameters

Lesson 19 - 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
- High Availability for SAP HANA

Lesson 20 - SAP HANA Security

- Create Users
- User and Role Concept
- Creating Roles
- Assigning Privileges to Roles
- Privileges
- SQL privileges
- System Privileges
- Analytic Privileges
- Reporting and Privileges
- Modeling required privileges

Lesson 21 - SAP HANA Monitoring & Troubleshooting

- Configuring Remote Support
- Solution Manage Integration
- Remote Service Connection
- EWA for HANA
- Availability Monitoring
- Setting up Monitoring
- System Monitoring Setup
- Status Overview
- Services Overview
- System Load History
- Disk usage Details
- Checking System Configuration Alerts

Lesson 22 - Analyzing logs & traces

- Regular administration tasks
- Troubleshooting
- Analyzing performance

Lesson 23 - Software Life cycle Management

- Transporting Changes
- SAP HANA with CTS+
- Exporting and Importing
- Developer Mode
- Delivery Unit
- SAP support Mode
- Exporting Tables
- Updating SAP HANA
- SAP HANA Update and Patching
- SP stack Update


- SAP HANA Native Applications
- Non-Native SAP HANA Applications

Lesson 25 - SAP HANA in Cloud overview

- Access to HANA systems in cloud
- SAP HANA Developer Edition Environment


Lesson 27 - SAP BW Powered by HANA

Lesson 28 - SAP ERP on HANA

Lesson 29 - SAP CRM on HANA

Lesson 30 - SAP HANA Rapid Deployment Solutions (RDS)

Who is this course for?

  • System Administrators
  • Sap Basics
  • Sap Security


Passion and determination to achieve your goals!

Career path

  • SAP HANA Engineer
  • SAP HANA Architect
  • SAP HANA Administrator
  • SAP HANA Business Analyst
  • SAP HANA Data Modeler
  • SAP HANA Project Manager
  • SAP BW/HANA Developer

Questions and answers

Currently there are no Q&As for this course. Be the first to ask a question.


Currently there are no reviews for this course. Be the first to leave a review.


What does study method mean?

Study method describes the format in which the course will be delivered. At courses are delivered in a number of ways, including online courses, where the course content can be accessed online remotely, and classroom courses, where courses are delivered in person at a classroom venue.

What are CPD hours/points?

CPD stands for Continuing Professional Development. If you work in certain professions or for certain companies, your employer may require you to complete a number of CPD hours or points, per year. You can find a range of CPD courses on, many of which can be completed online.

What is a ‘regulated qualification’?

A regulated qualification is delivered by a learning institution which is regulated by a government body. In England, the government body which regulates courses is Ofqual. Ofqual regulated qualifications sit on the Regulated Qualifications Framework (RQF), which can help students understand how different qualifications in different fields compare to each other. The framework also helps students to understand what qualifications they need to progress towards a higher learning goal, such as a university degree or equivalent higher education award.

What is an ‘endorsed’ course?

An endorsed course is a skills based course which has been checked over and approved by an independent awarding body. Endorsed courses are not regulated so do not result in a qualification - however, the student can usually purchase a certificate showing the awarding body’s logo if they wish. Certain awarding bodies - such as Quality Licence Scheme and TQUK - have developed endorsement schemes as a way to help students select the best skills based courses for them.