Course Overview
SAP HANA is the world's leading in-memory database platform — the foundation of SAP S/4HANA and virtually every modern SAP solution. This comprehensive SAP HANA Administration course covers both on-premise deployment and cloud-based HANA deployments on AWS, Microsoft Azure, and SAP HANA Cloud.
You will begin with a thorough understanding of SAP HANA's in-memory architecture, then progress through hands-on installation and configuration, database administration using SAP HANA Cockpit and HANA Studio, advanced performance tuning, and comprehensive backup and recovery strategies. High availability (HSR) and disaster recovery configurations are covered in detail, as these are critical skills for HANA DBAs in enterprise environments.
The cloud portion of the course covers SAP HANA Cloud — the fully managed cloud-native version of HANA — and hybrid landscapes where on-premise and cloud HANA coexist. By the end of this course, you will have the expertise to administer, optimise, and protect enterprise SAP HANA landscapes and will be well prepared for SAP HANA certification.
Key Features
Live HANA System
Full access to on-premise SAP HANA and SAP HANA Cloud for hands-on labs.
Expert HANA DBA Trainer
Trainer with 12+ years of SAP HANA DBA experience across large-scale deployments.
Cert. Preparation
Prepare for SAP Certified Technology Associate – SAP HANA 2.0 exam.
Cloud Deployment Labs
Hands-on HANA deployment on AWS EC2 and SAP HANA Cloud service.
HA & DR Scenarios
Real-world HSR, system replication, and disaster recovery configuration labs.
Placement Support
100% placement support with 200+ hiring partners across India and globally.
Course Curriculum
- SAP HANA in-memory computing principles and column-store engine
- HANA system architecture: index server, name server, statistics server
- Row store vs. column store: when to use each
- HANA hardware requirements and sizing guidelines
- HANA 2.0 editions: Platform, Enterprise, and Cloud editions
- Pre-installation OS and hardware checks (Linux RHEL / SLES)
- HANA Database Lifecycle Manager (HDBLCM) — installation walkthrough
- Single-host and multi-host (scale-out) HANA installation
- SAP HANA Cockpit and HANA Studio setup and configuration
- Post-installation validation and system checks
- HANA software update and patch management (SUM/HDBLCM)
- Starting, stopping, and monitoring HANA services
- Managing tenants in multi-tenant database containers (MDC)
- Schema and table space management
- HANA SQL console — key DBA queries
- Log and data volume management
- Housekeeping tasks: delta merge, statistics refresh, log truncation
- HANA user management: database users and technical users
- HANA roles, privileges, and privilege management
- Authentication: password policy, LDAP, Kerberos, SAML
- Data encryption: data-at-rest and data-in-transit
- HANA Audit policy configuration and log analysis
- HANA performance analysis using HANA Cockpit and SQL
- Expensive SQL statement trace and plan analysis
- Memory management: HANA memory areas and OOM analysis
- CPU and thread utilisation monitoring
- Table merges, partitioning, and table distribution in scale-out
- Performance-critical HANA configuration parameters
- HANA backup types: complete, incremental, differential
- HANA Backup Catalog and backup monitoring
- Point-in-time recovery and tenant database recovery
- Backint integration with third-party backup tools
- HANA persistence layer and log mode configuration
- Disaster recovery testing and runbook creation
- HANA System Replication (HSR) concepts and modes
- Synchronous vs. asynchronous vs. full-sync replication
- HSR configuration: primary and secondary setup
- Takeover operations — planned and unplanned
- Multi-tier HSR for HA and DR
- HANA with Pacemaker cluster for automated failover
- SAP HANA Cloud architecture and managed service model
- Provisioning SAP HANA Cloud instances via BTP Cockpit
- Connecting on-premise HANA to SAP HANA Cloud (federation)
- HANA on AWS EC2 and Azure — IaaS deployment patterns
- Monitoring and administration of cloud HANA instances
- Certification exam prep and mock assessment
Tools & Technologies
SAP HANA 2.0
SAP HANA Cockpit
HANA Studio (Eclipse)
HDBLCM / hdbsql
SAP HANA Cloud
AWS EC2
Azure VMs
Pacemaker / STONITH
Backint / Commvault
RHEL / SLES Linux
Duration & Mode
Delivery Mode
Online & Classroom
Session Hours
3 hrs/day · Weekdays & Weekends
Career Opportunities
SAP HANA Database Administrator
SAP HANA Cloud Administrator
SAP HANA Performance Engineer
SAP HANA Technical Consultant
SAP Basis & HANA Engineer
SAP HANA Solution Architect
Who Should Enroll
Oracle/DB2/MS SQL DBAs transitioning to SAP HANA
SAP BASIS Administrators adding HANA skills
Linux system administrators interested in SAP DBA
SAP consultants working on HANA-based solutions
Cloud engineers deploying SAP on AWS/Azure
Candidates preparing for SAP HANA 2.0 certification
Frequently Asked Questions
Do I need Linux knowledge for this course?
Basic Linux command-line knowledge is strongly recommended, as SAP HANA runs exclusively on Linux (RHEL or SLES). We provide a Linux refresher module at the start for students who need it.
Will the course cover both on-premise and cloud HANA?
Yes — this course covers both. Modules 1–7 focus on on-premise HANA installation and administration, and Module 8 covers SAP HANA Cloud and IaaS (AWS/Azure) deployment. Both environments are available for hands-on labs.
What certification does this course prepare me for?
The course prepares you for SAP Certified Technology Associate – SAP HANA 2.0 (C_HANATEC). Our students achieve a 94%+ first-attempt pass rate. We provide mock exams, study guides, and one-on-one certification coaching.
Are HA and DR topics covered in practical labs?
Yes — HANA System Replication (HSR) and takeover operations are fully covered with hands-on exercises on our lab environment. Students configure primary/secondary replication and perform planned and unplanned failover scenarios.