
SAP HANA Administration Training (Online Live session)
HANA ADMINISTRATION
βΉ34999.00βΉ29999.00
SAP HANA Administration Training β Comprehensive Overview
The SAP HANA Administration Training comprising 16β18 sessions, aimed to be completed in 30β45 days. This course equips participants with thorough theoretical knowledge and hands-on practical skills necessary for effectively managing SAP HANA systems.
Participants will gain insights into the installation, configuration, monitoring, backup and recovery, system replication, performance tuning, and troubleshooting of SAP HANA environments. The training emphasizes practical exercises and real-world scenarios, empowering participants to confidently oversee enterprise-level HANA landscapes.
By the conclusion of this course, participants will be capable of:
Installing, configuring, and upgrading SAP HANA systems
Managing users, memory, storage, and table partitioning efficiently
Implementing backup strategies, snapshots, and database refreshes
Setting up and monitoring system replication (multi-target and multi-tier)
Troubleshooting HANA issues and optimizing system performance
Making informed decisions on HANA sizing and architecture
Course Content β Detailed Modules
Session 1: HANA Architecture
Objective:
Understand the architecture and components of the SAP HANA database
Explore the index server, name server, preprocessor server, and XS engine
Hands-On:
Review the HANA system landscape
Examine HANA architecture diagrams and processes
Key Takeaways:
Comprehend HANAβs in-memory architecture
Understand how HANA handles transactions and queries
Session 2: HANA File System
Objective:
Learn about various HANA file types and directory structures
Understand the locations of data, log, trace, and backup files
Hands-On:
Explore the HANA file system using OS commands
Identify critical HANA directories
Key Takeaways:
Gain the ability to efficiently manage HANA storage
Grasp the file system requirements for optimal performance
Session 3: HANA Memory Management
Objective:
Understand HANA's memory architecture, allocation, and usage
Learn about column store and row store memory management
Hands-On:
Monitor memory usage via HANA Studio and Cockpit
Identify memory bottlenecks and optimize utilization
Key Takeaways:
Efficient memory monitoring and adjustments
Avoid performance challenges stemming from memory saturation
Session 4: HANA Persistence & Savepoint
Objective:
Understand the HANA persistence layer and savepoint mechanism
Learn about redo logs and the data recovery process
Hands-On:
Monitor savepoints within HANA Cockpit
Simulate database shutdown and restoration
Key Takeaways:
Ensure data durability and recovery readiness
Understand HANAβs persistence system
Session 5: HANA Installation & Upgrade
Objective:
Understand the step-by-step installation process of SAP HANA
Comprehend the upgrade procedure and patching
Hands-On:
Install HANA SPS on a Linux server
Conduct a system upgrade within a sandbox environment
Key Takeaways:
Be equipped to confidently install and upgrade HANA systems
Effectively apply support packages and service packs
Session 6: HANA Sizing
Objective:
Learn about sizing concepts and tools for HANA
Calculate memory, CPU, and storage needs for various landscapes
Hands-On:
Utilize SAP QuickSizer and HANA sizing reports
Evaluate system specifications for hypothetical projects
Key Takeaways:
Optimize HANA resources based on project demands
Prepare for future growth and scalability
Session 7: HANA User Administration
Objective:
Manage users, roles, and permissions in HANA
Adopt security best practices
Hands-On:
Create users, assign roles, and set privileges
Track user activities in HANA Cockpit
Key Takeaways:
Maintain a secure HANA environment
Effectively manage access and permissions
Session 8: HANA Cockpit Sizing & Installation
Objective:
Deploy HANA Cockpit for monitoring and administrative tasks
Establish sizing needs for Cockpit deployment
Hands-On:
Install HANA Cockpit on a server
Connect multiple HANA systems to the Cockpit
Key Takeaways:
Monitor and manage HANA systems centrally
Familiarize with Cockpit architecture and resource requirements
Session 9: HANA Backup Strategy & Snapshots
Objective:
Understand various backup strategies (full, incremental, differential)
Learn about snapshots and data recovery scenarios
Hands-On:
Set up automated backups in HANA Cockpit
Execute restores using snapshots and confirm data integrity
Key Takeaways:
Ensure data security and readiness for disaster recovery
Implement effective backup techniques
Session 10: HANA DB Refresh
Objective:
Understand database refresh scenarios from production to QA/DEV
Learn methods for consistent refresh
Hands-On:
Carry out database refresh from backup or system replication
Validate data and user access post-refresh
Key Takeaways:
Confidently refresh HANA databases
Prevent data inconsistencies during refresh procedures
Session 11: HANA System Replication (Multi-Target & Multi-Tier)
Objective:
Learn about synchronous and asynchronous replication methods
Understand multi-target and multi-tier replication configurations
Hands-On:
Set up system replication from primary to secondary HANA instance
Test failover and recovery methods
Key Takeaways:
Ensure high availability and disaster recovery
Implement a dependable replication framework
Session 12: HANA Table Partitioning
Objective:
Understand partitioning concepts for large datasets
Learn how to optimize performance through partitioning
Hands-On:
Set up table partitions for a sample database
Monitor improvements in query performance
Key Takeaways:
Enhance access to large tables and improve query efficiency
Boost system performance with proper partitioning techniques
Session 13: HANA Delta Merge
Objective:
Understand the delta merge process in columnar tables
Learn about the effects on performance and storage
Hands-On:
Monitor delta merges in HANA Studio
Initiate manual merges and observe system response
Key Takeaways:
Ensure optimal query performance
Avoid unnecessary resource usage
Session 14: HANA Monitoring & Performance Tuning
Objective:
Learn main monitoring tools and metrics (Cockpit, Studio, SQL)
Optimize CPU, memory, and disk usage
Hands-On:
Monitor real-time system performance
Identify bottlenecks and adjust settings
Key Takeaways:
Engage in proactive monitoring and performance improvements
Ensure smooth functioning of HANA systems
Session 15: HANA Troubleshooting
Objective:
Learn systematic troubleshooting strategies
Address performance, connectivity, and replication challenges
Hands-On:
Solve common HANA errors
Utilize diagnostic tools and logs for root cause examination
Key Takeaways:
Effectively resolve HANA-related issues
Minimize system downtime and incidents
Session 16: Real-World Scenarios & Best Practices
Objective:
Apply learned concepts to enterprise-level scenarios
Grasp best practices for administration and system health
Hands-On:
Conduct an end-to-end case study: installation β configuration β replication β backup
Implement optimization and monitoring
Key Takeaways:
Real-world experience in managing HANA landscapes
Preparation for advanced HANA administration positions
Optional Sessions (17-18)
Doubt Clearing Sessions
β Training Highlights
Duration: 30β45 days (16β18 sessions)
Session Duration: 1.5β2 hours per session
Hands-On Focus: Installation, configuration, monitoring, replication, backup, troubleshooting
Outcome: Participants acquire expert-level knowledge in HANA administration, preparing them for enterprise deployment and complex troubleshooting