Introduction

This Course by Xcelerate Training Institutes focuses on mastering SAP HANA SPS11 administration. Participants will acquire essential skills for daily SAP HANA system administration tasks, including installation, operation, configuration, troubleshooting, and high availability management.

Learning Objectives

Upon completion, participants will be able to install and update SAP HANA SPS11, perform daily administrative tasks, manage system startup/shutdown, configuration, backup, troubleshooting, and database backup/recovery.

Training Methodology

This Course by Xcelerate Training Institutes should cover installation, configuration, and management of SAP HANA systems. It should include topics like system architecture, data modeling, security, performance tuning, backup and recovery, and troubleshooting. The training should be a mix of theoretical knowledge and hands-on exercises using SAP HANA Studio and Cockpit. It should also cover best practices and real-world scenarios to prepare trainees for real-world challenges.

Benefits for Your Organization

This Course empowers your organization to optimize SAP HANA system performance, ensuring data security, minimizing downtime, and streamlining administrative tasks. This leads to improved operational efficiency, cost reduction, and enhanced decision-making capabilities through real-time insights.

Benefits for you

With SAP HANA Operations and Administration training, you’ll gain the skills to efficiently manage and optimize your SAP HANA systems, ensuring optimal performance, security, and availability. You’ll learn to perform essential tasks like system configuration, monitoring, troubleshooting, and backup/recovery. This expertise will empower you to proactively identify and resolve issues, improve system responsiveness, and safeguard your critical data.

Target Audience

This course is designed for technology consultants, system administrators, database administrators, and help desk or CoE support personnel.

Course Outline

 Installation and Setup

• Preparation: Define installation prerequisites and introduce SAP HANA lifecycle management tools.
• Installation: Explore advanced installation options, SAP HANA Studio setup, distributed system installation, and post-installation procedures.
• Updates and Planning: Learn about SAP HANA updates, revision strategies, and system sizing.

Architecture and Administration Tools

• Fundamentals: Understand SAP HANA architecture, memory management, data persistence, and future development roadmap.
• Deployment: Explore deployment options and essential administration tools.
• Tool Overview:

1. Gain hands-on experience with SAP HANA Studio
2. SAP HANA Cockpit
3. SHINE
4. DBA Cockpit
5. HDBSQL

 Operations and Troubleshooting

• Daily Tasks:

1. Master starting
2. Stopping
3. Configuring SAP HANA systems

• Data Management:

• Learn table administration
• Periodic tasks
• Troubleshooting techniques

• Diagnostics:

1. Effectively use traces
2. Diagnosis information
3. Diagnosis files

• Data Handling:

1. Explore SQL console usage
2. Transport management
3. Backup and recovery strategies
4. Data area and log area backup

 Security

• Security Overview:

1. Understand SAP HANA security fundamentals
2. Including authentication
3. Authorization
4. Encryption
5. Auditing

• User Management:

• Learn user management,
• Privilege types
• Roles
• Administrative tasks

• Information Sources: Utilize SAP HANA Live Authorization Assistant for efficient administration.

 High Availability and Disaster Tolerance

• High Availability: Explore SAP HANA scale-out for high availability.
• Disaster Recovery: Learn disaster recovery strategies.
• Multitenant Database Containers:

1. Understand architecture
2. Technology
3. Administration
4. Backup/recovery for multitenant database containers