SAP HANA Database Administration Training
SAP HANA database administration training teaches you to run HANA as a production database.
- 45 hours
- Intermediate
- Live online
- C_DBADM_2404
What is SAP HANA Database Administration Training?
SAP HANA database administration training teaches you to run HANA as a production database. You cover the architecture and processes, installation and system layout, multitenant database containers, users, roles and privileges, backup and recovery including point in time recovery, system replication for high availability and disaster recovery, memory management and data ageing, performance monitoring with HANA Cockpit and Studio, workload management, security hardening and auditing, and revision upgrades. It maps to the C_DBADM_2404 associate exam.
What you get
- Explain HANA architecture, processes and persistence accurately
- Install HANA and validate the system layout
- Administer tenant databases in an MDC system
- Design and test a backup and recovery strategy
Who this course is for
New to the field
- Basis administrators adding HANA depth
- DBAs from Oracle or SQL Server moving to HANA
- Infrastructure engineers supporting SAP
Working professionals
- Teams running HANA in production
- Consultants sizing and installing HANA
- Anyone targeting the HANA DBA associate exam
Prerequisites
- Linux fundamentals and general database or SAP Basis experience.
- This is an infrastructure course, not a modelling course.
What you will be able to do
- Explain HANA architecture, processes and persistence accurately
- Install HANA and validate the system layout
- Administer tenant databases in an MDC system
- Design and test a backup and recovery strategy
- Configure system replication and perform a takeover
- Diagnose performance problems with cockpit and traces
- Manage memory, partitioning and workload classes
- Plan and execute a revision upgrade
Salary range
- India
- 8-28 LPA
- United States
- 110k-160k
Market ranges for SAP HANA Database Administrator, not a guarantee. Actual pay depends on experience, location and employer.
Curriculum
HANA architecture and installation
Know the processes and lay the system out correctly.
- In-memory architecture and column store
- HANA processes: nameserver, indexserver, others
- Persistence: data volumes and log volumes
- Delta merge and how it affects everything
- Sizing: memory, disk and CPU
- Installation with hdblcm
- File system layout and mount points
- Post-installation checks and parameters
Multitenant database containers
Run several databases in one system without them fighting.
- System database and tenant databases
- Creating, starting and stopping tenants
- Cross-tenant access and restrictions
- Resource allocation between tenants
- Tenant copy and move
- Tenant specific parameters
- Backup implications of MDC
- When to use separate tenants versus separate systems
Users, roles and security
Control access properly and prove it to an auditor.
- User types and authentication methods
- Roles: catalog and repository roles
- System and object privileges
- Analytic privileges overview
- Password policy and lifecycle
- Encryption: data, log and backup
- Auditing configuration and audit trail
- Security hardening checklist
Backup and recovery
Be able to get the database back, provably.
- Backup types: complete, delta, incremental
- Backup destinations: file and Backint
- Log backup configuration and retention
- Backup catalog management
- Recovery scenarios and their sequences
- Point in time recovery
- Recovery to a different system
- Testing recovery, not assuming it works
High availability and system replication
Survive failure without losing data.
- Host auto-failover and standby hosts
- System replication concepts
- Replication modes: sync, syncmem, async
- Operation modes: delta datashipping, logreplay
- Takeover and failback procedures
- Active/active read enabled setups
- HA cluster integration overview
- Testing a takeover safely
Performance monitoring and troubleshooting
Find the real cause instead of restarting the database.
- HANA Cockpit and its monitoring views
- Threads, sessions and blocked transactions
- Expensive statements trace
- SQL plan cache analysis
- Plan visualizer for query plans
- Load monitoring and history
- Alerts and their configuration
- A structured troubleshooting method
Memory, workload and lifecycle
Manage capacity and keep the system current.
- Memory allocation and the global allocation limit
- Column store loading and unloading
- Table partitioning strategies
- Data ageing and data tiering options
- Native Storage Extension overview
- Workload classes and admission control
- Revision and SPS upgrade process
- Housekeeping: traces, dumps and log volumes
Projects you will build
Backup and recovery drill
Configure backups and log retention, then recover the database to a point in time and prove the result, including a recovery into a different system.
System replication setup
Configure system replication between two systems, monitor it, perform a controlled takeover and then fail back.
Performance investigation
Given a system with a deliberate performance problem, use expensive statements, plan cache and plan visualizer to find the cause and fix it.
Tools you will use
- SAP HANA Cockpit
- The primary administration and monitoring tool for current HANA releases.
- hdbsql and hdblcm
- Command line administration and lifecycle management, needed for real work.
- Backup and recovery tooling
- Backup configuration, catalog and recovery execution.
- System replication monitoring
- Replication status, shipping delays and takeover control.
- Expensive statements and plan visualizer
- The tools that actually explain slow queries.
- Monitoring views (M_ views)
- The system views behind every dashboard, which you will query directly.
Certification
- Exam
- SAP Certified Associate, Database Administrator, SAP HANA
- Code
- C_DBADM_2404
- Level
- Associate
- Exam fee
- US$560 (single exam)
What learners say
The recovery drill is the exercise every DBA course should have and almost none do. I found two gaps in our own runbook.
System replication takeover and failback, done hands-on, is what got me the HA responsibility on my team.
I came from Oracle. The architecture and delta merge sections explained why HANA behaves differently rather than just listing commands.
Fees and training modes
Choose how you want to learn. No-cost EMI is available on the live and 1-to-1 modes.
Most popular
Live Online Training
Talk to us
Contact for current batch fee
Interactive live batches, weekday or weekend, with the full cohort and lifetime recordings.
Fastest
1-to-1 Training
₹49,000
Fixed for every course, no-cost EMI
Private one-on-one coaching at a pace and schedule you set.
Affordable
Self-paced Training
₹9,000
One-time fee, lowest-cost option
Learn on your own time with recorded sessions and the same materials.
Refunds and cancellations are covered in our refund policy.
What a day looks like
- Morning checks
- Alerts, backup success, replication lag and memory headroom, in that order.
- Performance calls
- A slow report or a blocked transaction, usually traced to a statement, a lock or a missing partition.
- Space management
- Log volumes filling and column store memory pressure, which are the two classic HANA incidents.
- Change work
- Parameter changes, revision upgrades and tenant provisioning, all scheduled carefully.
- Recovery assurance
- Periodic restore tests, because a backup nobody has restored is not a backup.
Training a team?
We run this course as private corporate training, tailored to your systems and scheduled around your team. Tell us your group size and what you need to cover.
Request a corporate quoteFrequently asked questions
Is this different from the SAP HANA course?
How much Linux do I need?
Does this overlap with Basis?
Which certification does this map to?
Do we cover cloud deployments?
Is there hands-on access?
Ready to start?
Talk to us about batch dates, the syllabus or anything else.