SAP HANA Admin Overview:

its an new database design by SAP which saves data in memory it has got many advance capabilities like In memory database , massive parallel Processing , it can read  and save data in row as well as column storage it has massive data compression ratio like 7:1 it uses all features of SLT’s like SLT,BODS, it is capable for getting data from Non – SAP system with help of Smart data integration (SDI)

Target student: The main Prerequisites for ‘HANA Administrator’ he  should actively participate in system administration tasks such as managing the database, Insatllation of Operating System monitoring Servers Knowledge, installing and upgrading the software on the servers, and system security policy user policy license managements and memory management

1) Introduction to SAP HANA

• What is HANA?
• Introduction to HANA
• Roles and Responsibilities of HANA Consultants
• Introduction to OS Concepts
• Introduction to SAP HANA  Hardware Concepts : The CPU
• Introduction to SAP HANA  Hardware Concepts : Storage
• SAP HANA Networking issues

2) SAP HANA Architecture

• SAP HANA Architecture
•  Architecture of HANA Application
• Detailed study of Index server , Name Server , Preprocessor
• Working with various parameters for fine tuning
• Configuration of HANA DB

3) Backup & Recovery of SAP HANA DB

• Backup & Recovery of HANA DB
• Log Backup
• DB Backup
• Profile Backup
• Recovery of SAP HANA DB

4) HANA SIZING

• SAP HANA sizing for standalone instance(side by side scenario)
• SAP HANA sizing for BW on HANA

5) HANA INSTALLATION

• Download the media  / Guides from SMP
• Pre – Installation
• Installation (various types of installations)
• Post Installation steps

6) SAP HANA START & STOP

• How to START HANA DB
• How to STOP HANA DB
• Through HANA COCKPIT and OS also

7) OVERVIEW OF SLT SERVER

• Installation of SLT server
• Configuration of SLT with the HANA DB and Backend ECC or NON SAP Systems
• Replication Weekly , Monthly

8) HANA ADMIN DAILY ACTIVITIES

• Monitoring and performance

• System administration
• Transport requests
• Manage HANA STUDIO
• Manage HANA COCKPIT
• Running daily backups

9) Licensing, Certificates & AUDIT

• Managing License Keys
• Managing Certificates
• Configuring Audit policy

10) User and Authorizations

• Creation of new users
• Creation of New roles
• Assign roles to users

11) Installation of HANA STUDIO & HANA Client

• Software Lifecycle management
• Updating SAP Hana
• Updating Hana Studio

12) HANA DB Migration

• Overview of Migration
• Pre activities of migration
• Post activities of migration

13) Installation & Upgradation

• HANA installation SP10 & SP11
• Upgrade from SP10 to SP11
• Install HANA 2.0
• Install HANA Cockpit & configuration
• Upgrade studio to latest level
• Revision upgrade

13) HANA Security

14) Smart data integration

15) Delta merge

16) Performance tunning

• Overview of Migration
• Table Partition
• Create Index Synonym
• Identify expensive SQL statement and how to fine tune the statement