Description

Objective of this course is to enable students understanding and applying the different configuration tasks required to operate and administer the SAP HANA database.

Maxtech IT Course Services

• Flexible Timings
• Lifetime Access to Course Materials
• Session Recordings
• Software Installation Assistance
• 24x7 Training Team Support
• Course Certificate
• Resume Preparation and Interview Assistance

Reviews

Course Content

Course Description

Objective of this course is to enable students understanding and applying the different configuration tasks required to operate and administer the SAP HANA database.

What you will learn

Participants will gain the knowledge to participate in administering, and managing data integration projects.

Who Should Attend

This course is for technical consultants and administrators, who are going to plan, size and configure the SAP HANA database, as well as configure the different components for data provisioning and reporting clients.

This course also covers monitoring and troubleshooting of SAP HANA as well as tools, high availability, backup strategies, user maintenance and lifecycle management.

Duration: 25 Hours

Prerequisite Education or Experience

Someone who is working as a BASIS consultant or System or Network Administrator and wants to learn SAP HANA skills.

Familiarity with network security and administration concepts

Some of the Highlights of SAP HANA Admin Course are as follows

• You will be provided with the latest training course material on SAP HANA Admin covering real-time examples
• The Trainer for SAP HANA Admin has 16 years of real-time experience and as well has executed a number of real-time HANA based projects
• Interview questions, SAP HAHA certification guidance
• You will be provided with the latest interview questions by way of which you can easily crack an interview.
• We provide best SAP HANA ADMIN online/class room training in Mumbai/Thane by experienced and real time expert faculty.

For Demo session / Registration and enquiry call on +91-09833302301

Course Content

Day-1

1. Introduction of SAP HANA
   • What is SAP HANA
   • What is In Memory Database
   • SAP HANA Database Architecture
   • Single Host / Multi Node cluster configuration
   • SAP HANA Persistence Layer
2. Preparing Installation
   • Sizing of SAP HANA
   • T-Shirt Size
   • Main Memory Sizing
   • SAP HANA sizing using the QuickSizer tool
   • Conclusion

Day-2

1. Installation
   • Introduction SAP HANA Lifecycle Management Tools
   • Platform lifecycle Management
   • Application lifecycle Management
   • SAP HANA Database Installation
   • SAP HANA Installation using hdblcm
   • SAP HANA Studio installation
2. Post Installation
   • Post Installation Steps
   • SAP HANA license management
   • SAP HANA Support Package strategy
   • Updating SAP HANA
   • SAP HANA Support Package (Revision)upgrade

Day-3

1. Admin tools for SAP HANA
   • SAP HANA Studio
   • SAP HANA Cockpit
   • SAP DBA Cockpit
   • Monitoring with SAP HANA Studio
   • Monitoring and Troubleshooting.

2. Day-4

3. SAP HANA Operation
   • Starting and Stopping SAP HANA
   • Tools for Starting and Stopping the SAP HANA Database
   • Stopping & Starting HANA DB with SAP HANA Studio
   • SAP HANA Database stop options
   • Starting and Stopping the SAP HANA Database Using OS Commands
   • Stopping and Starting Individual Database Services
   • Restarting SAP HANA Database
   • Configuring SAP HANA Database
   • SAP HANA Database *.ini files
   • Periodic Manual Tasks
   • Renaming HANA database
   • SLD configuration
   • Installing HANA content/Delivery Unit

4. Day-5

5. SAP HANA Memory Management and Data Persistence
   • SAP HANA Core Processes
   • SAP HANA Database Startup Sequence
   • SAP HANA Database Server Process Port list
   • Start of SAP HANA Database – Start – Up Process
   • SAP HANA Memory Usages.
6. SAP HANA Technical Deployment Options
   • Single Component on One System (SCOS)
   • Multiple Components on one System (MCOS)
   • Multiple Components on one Database (MCOD)
   • SAP HANA Multitenant Database Containers (MDC)

7. Day-6

8. Backup and Recovery
   • In Memory data and persistent Storage
   • Why Backup
   • Memory à Diskà Backup
   • Options for backups
   • Overviews of Configuration options
   • Log Mode (Overwrite and Normal mode)
   • Log Backup Parameters
   • Backup Catalog
   • SAP HANA Database Backup using HANA Studio
   • SAP HANA Database Recovery
   • Recovery types
   • Recovery Steps
   • Recovery Phases
   • SAP HANA Database Recovery using HANA Studio

9. Day-7

10. Data Provisioning Technologies
    • Overview of Data Provisioning in SAP HANA
    • Overview SAP LT (SLT) Replication Server
    • SLT Architecture - between SAP System and SAP HANA
    • Configure SAP SLT Server for SAP Source System
    • Direct Extractor Connection (DXC)
    • Overview SAP Data Services.
11. SAP HANA Content Management
    • What is SAP HANA Content?
    • HANA Repository
    • The Package concepts
    • The Delivery Unit
    • Transport of changes
    • Exporting and Importing SAP HANA Content Manually

12. Day-8

13. Maintaining Users and Authorizations
    • User Management
14. Creations of User
15. Creation of Roles
16. Assignment of Users to roles
    • Types of Privileges
    • Standard Roles
    • Administrative Tasks
    • Managing Password Policy

17. Day-9

18. SAP HANA Multitenant Database Containers (MDC)
    • What is Multitenant Database Containers
    • Administration of Multitenant Database Containers
    • Starting / Stopping tenant database
    • Creating tenant database
    • Dropping Tenant database.
19. HANA Scalability Concepts
    • Scale Up (Vertically Scaling)
    • Scale Out (Horizontal Scaling)
20. High availability and Disaster Recovery
    • Continuous Availability
    • High Availability
    • High Availability for Scale up and Scale out
    • SAP HANA System Replication
    • SAP HANA Host Auto Failover
    • High Availability - Overview
    • HA / DR - KPI
    • RPO & RTO of Disaster Recovery Features

21. Day-10

22. SAP HANA System Replication
    • SAP HANA System Replication - Overview
    • Replication Modes
    • Operation Modes
    • Data transferred to the secondary
    • Operation mode - delta_datashipping
    • Operation mode - logreplay
    • Prerequisites
    • Setup and Configuration Overview
    • Configuration HANA System Replication overview
    • Disable HANA System Replication overview
    • Hana DB Single Node HA – DR
23. SAP HANA Host Auto Failover
    • What is SAP HANA Host Auto Failover?
    • How Host Auto Failover logically works
    • Slave Host Failover to a Standby Host
    • Master Host Failover to a Standby Host
    • Configuring Apps Server for failover
24. SAP HANA Cockpit 2.0 Installation and Configuration
    • Overview of HANA Cockpit 2.0
    • Installation of HANA Cockpit 2.0
    • Configuration of HANA cockpit 2.0
    • Registration of remote database (Resources) in HANA Cockpit
    • Create Resource group
    • Create Cockpit User
    • Overview of Monitoring remote database through HANA Cockpit