SAP HANA Administration Training Overview:
It’s a new database design by SAP which saves data in memory. SAP HANA Administration Training 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, Installation 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
| Course Duration: | 35 – 40 hrs |
| Timing | Week Days: 1 hrs per day (OR) 3 Times a week or Weekends: 3 hrs per day |
| Method: | Instructor led, with exercises. |
| Breaks: | As Required, but limited to 2 of 10 min. In weekend batch |
| Email ID | Info@rhsofttech.com |
| Study Material | SAP BASIS ADMINISTRATION Training |
| Phone | +91 9356913849 |
| Fees Structure | 50% After introduction lectures balance After 50% Lecture |
| Server access | Throughout the course 24/7 |
| Timings | Flexible |