Prerequisites
To apply for the SAP HANA Administration Training, you need to either:
- Fundamental knowledge of SAP concepts, Database skills, SQL, OS (Windows/Linux), etc., will be an added benefit to learning SAP HANA Admin.
Course Curriculum
Topic – 1 Overview of SAP HANA
- SAP HANA Introduction
- Understand High-Performance Analytics
- Need for In-Memory Techs
- Concepts of In-Memory Computing
- Difference between SAP HANA Row & Columnar Store
Topic – 2 Editions of SAP HANA & Deployment
- Software Packaging
- SAP HANA Editions – Platform & Enterprise
- HANA as DataMart
- Native and Non-Native HANA Apps
Topic – 3 Architecture
- Architecture Overview
- Data Persistence & Memory Management
Topic – 4 Post Installation Actions
- Steps related to Post-Installation
- Installing – SAP HANA Studio & Client
Topic – 5 Admin Tools
- SAP HANA Studio & Cockpit
- Connecting to Database
- Lifecycle manager
- DBA Cockpit
- Database Explorer
- HDBSQL – Command Line Tool
- Disaster Recovery
Topic – 6 Requirement of Operating Systems
- Supported OS (SLES & RHEL)
- Requirements of Linux OS
- File System Preparation
Topic – 7 Database Administration
- Start & Stop SAP HANA
- Service Instances
- Run level Parameter
- Configure SAP HANA Database
Topic – 8 Installing SAP HANA
- Install SAP HANA
- Activities of HANA Post-Installation
- Lifecycle Management Tools – HANA
- Advanced Options of HANA Installation
- Installing Single-Host
- Understand KPIs
- Concepts of Quick Sizer and Appliance Models
Topic – 9 Recovery & Backup
- Concepts of Backup and Recovery
- Data and Log Area Backup
- Methods of Backup (HANA Studio – SQL Commands – DBA Cockpit)
- Scheduling Backups
- Managing Log Area Backup and LOGFULL Conditions
- Topics of Additional Backup
- Database Recovery and Recovery Options
- Recovery Methods (Database Copy & Storage Snapshot)
- Recovery Through HANA Cockpit 2.0
Topic – 10 Concepts of Security
- Overview of Security scenarios
- Authentication & Authorization
- Encryption & Auditing Concepts
Topic – 11 User Management and Authorization
- User Creation
- Privileges and Roles
- Analytic Privileges
- Admin Tasks
Topic – 12 HANA Application Lifecycle Management
- HANA Development Concepts
- Transporting Objects
- Transportation Landscape Setup
- Concept of CTS
Topic – 13 Multi-Tenant Database Containers
- Architecture and Technology
- Install and Configure MDC
- Administration
- Backup and Recovery
Topic – 14 High Availability and Disaster Tolerance
- Concepts of Scalability and Distributed Database
- Understand High Availability
- Concepts of Disaster Recovery
- Configure System Replication
Topic – 15 Database Operations
- Understand Table Administration & Periodic Tasks
- Housekeeping Operations
- About Delta Merge and SQL Console
Topic – 16 SAP HANA Cockpit 2.0
- Install Cockpit 2.0
- Understand Cockpit Manager
- Concepts of Resource Groups & Monitoring Activities
