Home > Courses > Technical > HANA ADMIN
SAP HANA ADMIN TRAINING IN HYDERABAD
Course Duration : 50h
Course Level : Beginner
About the Course
SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data. HANA administration deals with managing SAP HANA system in a single and distributed system environment. Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning. SAP HANA system administrators are responsible for ensuring the efficient and continuous operation of all SAP HANA databases deployed in the corporate environment. As with any business-critical solution, proper management of SAP HANA requires a solid understanding of its internal mechanics to interpret the metrics that are monitored and their impact on system and application performance, as well as its administration and tooling capabilities to plan and execute a suitable database management strategy.
Description
WHAT ARE THE COURSE OBJECTIVES?
- SAP HANA is an in-memory database for performing real-time data analysis, and development of applications on the top of real-time data.
- HANA administration deals with managing SAP HANA system in a single and distributed system environment.
- Each HANA system can contain multi node architecture with each node containing multiple processors for fast speed data analysis and real-time data provisioning.
- You can use Smart data access to get the data from non-SAP systems without importing the data to HANA database, and virtual tables can be used to perform read/write data operations
WHAT ARE THE ROLES AND RESPONSIBILITIES AND METHODOLOGY OF THIS MODULE?
- Integration of SAP HANA into different remote systems. Exposure to different remote access options in HANA system.
- Experience in monitoring, tuning, and troubleshooting of SAP HANA systems.
- HANA system administration using SAP HANA Cockpit and HANA Studio.
- Experience in managing users and roles in SAP HANA system.
- Implementing SAP HANA Table management techniques – data compression, table partition, compression techniques, and load/unload table into memory.
- HANA Installation, Data Provisioning, Admin, Modelling.
- SAP BusinessObjects and HANA integration, Design document, RFPs, and estimation plans.
- Experience with high availability and backup mechanism.
- Implementing SAP HANA Security mechanism, HANA XS Application service, and monitoring of HANA system.
WHO SHOULD GO FOR THIS TRAINING
Those who have good knowledge on SAP Basis and HANA system concepts.
WHAT ARE THE SKILLS THAT YOU WILL BE LEARNING WITH THIS COURSE?
This course is for who have good knowledge on SAP Basis and HANA system concepts. After completing this tutorial, you will find yourself at a moderate level of expertise in administration and management of SAP HANA in multitenant environment.
WHAT ARE THE PREREQUISITES TO LEARN THIS COURSE?
You should have a good exposure to SAP HANA in-memory concepts, HANA Studio, and different options in HANA studio. f you are not aware of these concepts, then we recommend that you first go through SAP HANA and Basis courses.
Key Features
Instructor-Led Sessions
50 Hours of Online Live Instructor-Led Classes. Weekend Classes: 24 sessions of 2 hours each. Weekday Classes: 50 sessions of 1 hour each.
Real-Life Case Studies
Live project based on any of the selected use cases, involving implementation of the various concepts.
Assignments
Each class will be followed by practical assignments.
Lifetime Access
You get lifetime access to LMS where presentations, quizzes, installation guide & class recordings.
24 X 7 Expert Support
We have 24×7 online support team to resolve all your technical queries, through ticket based tracking system, for the lifetime.
Certification
After completing your final course project successfully emax will provide you certificate as a SAP Trainee.
Curriculum
SAP HANA ARCHITECTURE
- Introduction to SAP HANA
- SAP HANA Scenarios
- SAP HANA Database Architecture
- Persistence Layer
- Data Volume
- Log Volume
- SAP HANA Network Zones
- Revision strategy of SAP HANA
- Software Packaging
SAP HANA DEPLOYMENT OPTIONS
- On-Premise
- In the Cloud
- Hybrid
- Technical Deployment Options
- SCOS
- MCOS
- MCOD
SAP HANA USE CASES
- SAP HANA Data Provisioning (SLT)
- As Primary Persistence
- BW powered by HANA
- Business suite powered by HANA
- S/4 HANA
- As Platform
SAP HANA SYSTEM REQUIREMENTS
- Hardware and Software Requirements
- Supported Hardware Platforms
- Supported Operating Systems for SAP HANA
- SAP HANA Memory Management and Persistence
- Recommended File System Layout
- SAP HANA System Concepts
- Host
- System
- Instance (HDB)
- System Database
- Tenant Databases
- SAP HANA System Types
- Single-host system
- Multiple-host (distributed) system
SAP HANA PLATFORM LCM TOOLS
- LCM as a graphical user interface
- LCM as a command-line interface
- LCM as a Web user interface
- LCM Parameters Call Options
SAP HANA INSTALLATION AND UPDATE OVERVIEW
- Preparing an Installation – Sizing of SAP HANA (RAM, CPU, Disk)
- Greenfield / New implementation Sizing
- Brown Field / Migration Sizing
- Platform Software Components
- Software Download Location
- Software Authenticity Verification
Installation Paths
INSTALL & UPDATE AN SAP HANA SYSTEM
- Getting Started with SAP HANA System Installation
- Mandatory Installation Values
- Changeable Default Values for Installation
- Users Created During Installation
- Specifying Passwords using various methods
- Installing a Single-Host HANA System
- Install and Update HANA Studio
- Ports and Connections
- Host Name Resolution
- Update HANA Database
- Update Dependent Components
POST INSTALLATION STEPS
- Getting Started with SAP HANA System Installation
- Mandatory Installation Values
- Changeable Default Values for Installation
- Users Created During Installation
- Specifying Passwords using various methods
- Installing a Single-Host HANA System
- Install and Update HANA Studio
- Ports and Connections
- Host Name Resolution
- Update HANA Database
- Update Dependent Components
TROUBLESHOOTING AN INSTALLATION FAILURE
- Locating all SAP HANA File System Components
- Checking the Log Files
- Repairing a Partially Installed System
- Enabling the Installer Trace
MANAGING THE SAP HANA SYSTEM AFTER INSTALLATION
- Start and Stop the SAP HANA System
- Display the Process List
- Periodic Tasks
- Scheduling of Recurring Administration Tasks
UNINSTALLING THE SAP HANA SYSTEM
- Uninstall the SAP HANA System Using the Graphical User Interface
- Uninstall the SAP HANA System Using the Command-Line Interface
ADMIN TOOLS FOR SAP HANA
- SAP HANA Studio Installation and Update
- Open the SAP HANA Administration Console
- Execute SQL Statements in SAP HANA Studio
- Managing SAP HANA Systems in SAP HANA Studio
- SAP HANA Cockpit Installation and Configuration
- Set up SAP HANA Cockpit for the First Time
- Open SAP HANA Cockpit
- Security Aspects of SAP HANA Cockpit
- DBA Cockpit for SAP HANA
- Authorizations for DBA Cockpit
- Start DBA Cockpit for SAP HANA
- Setting Up Database Connections
- Administration and Monitoring Functions
- HDBSQL Command Line Tool
- SAP HANA HDBSQL Options
- Log On to a Database and Run Commands
SAP HANA TENANT DATABASES
- The System Database
- Server Architecture of Tenant Databases
- Creating and Configuring Tenant Databases
- Converting an SAP HANA System to Support Tenant Databases
- Cross-Database Access
- Database Isolation
- Database-Specific Configuration Parameters
- Administration of Tenant Databases
- Create a Tenant Database
- Start / Stop a Tenant Database
- Rename a Tenant Database
- Delete a Tenant Database
- Disable Features on a Tenant Database
- Add or Remove Services in a Tenant Database
- Configuring Memory and CPU Usage for Tenant Databases
- Cross-Database Access
- Database Isolation
- Database-Specific Configuration Parameters
- Administration of Tenant Databases
- Create a Tenant Database
- Start / Stop a Tenant Database
- Rename a Tenant Database
- Delete a Tenant Database
- Disable Features on a Tenant Database
- Add or Remove Services in a Tenant Database
- Configuring Memory and CPU Usage for Tenant Databases
CONFIGURING SAP HANA SYSTEM PROPERTIES (INI FILES)
- Change, Reset a System Property
- System Properties in Multiple-Container Systems
- Configure System Usage Type
- Reserve Connections for Administrators
SAP HANA DATABASE ADMINISTRATION TASKS AT A GLANCE
- Initial Administration Tasks
- Regular Administration Tasks
- On-Demand Administration Tasks
MANAGING AND MONITORING THE PERFORMANCE OF SAP HANA
- Analysing Generic Symptoms
- Performance and High Resource Utilization
- Slow System-wide Performance
- Slow Individual SQL Statements
- Frequent Out of Memory (OOM)
- Persistent Data Storage in the SAP HANA Database
- Memory Usage in the SAP HANA Database
- Root Causes of Memory Problems
- Workload Management
- Workload in the Context of SAP HANA
- Controlling Parallel Execution of SQL Statements
- Setting a Memory Limit for SQL Statements
- Managing Peak Load (Admission Control)
- Controlling CPU Consumption
- Troubleshooting an Inaccessible or Unresponsive SAP HANA System
- Configuring Traces
- Working with Diagnosis Files
- SQL Console
AVAILABILITY AND SCALABILITY
- SAP HANA Scale Out
- High Availability
- Faulty Recovery
- Disaster Recovery
SAP HANA DATABASE BACKUP AND RECOVERY
- Concept of Backup and Recovery
- Data, Log Area Backup
- Database Copy
- Recovery
- Backup and Recovery using Storage Snapshot
SAP HANA SECURITY / AUTHORIZATION
- Authentication and Authorization in SAP HANA
- Types of Privileges, Roles
- SAP HANA User Management
- Authorization Trace and Auditing
- Integrative Authorization Scenarios
MIGRATION TO SAP HANA USING SUM DMO
- DMO – Conceptional Overview
- The DMO Procedure in Detail
Course Certification
- Upgrade your skills and stay current with the industry by completing these professional courses, which also provide certification upon completion.
- Certificates are generated after the completion of course.
- Certificates are globally recognized & they upgrade your programming profile.
Reviews
Hi Team,
I would like to thank you all sooooo much for help and support.. Would like to thank each any every1 of you from the bottom of my heart starting from the professors, support staff, content writers and every1 else working for HANA ADMIN module in EMAX Technologies.
The reason I’m appreciating is I was able to clear an interview and joined a reputed organization and all credit goes to you guys.
The 10 PDFs and the exercise/solution notes are just perfect and very helpful for a beginner and it gives a load of confidence.
God bless you all!! 🙂
EMAX Technologies is one of the best HANA ADMIN training provoider globally.Really i enjoyed and every session during my course.The instructor is also clears everybody’s doubts very patiently.And the EMAX Technologies support team also helped me alot.Thanks EMAX.
EMAX Technologies is an excellent source to append market demanding skills to the profile.HANA ADMIN course gave a Big picture to jump into the SAP world and had a pleasant journey throughout the course from Instructor to the support team.In-depth/real-time explanation by the instructor helped to have the constant interest in the course. Course and its contents are perhaps well up to the industry- level requirements and highly advisable to opt one.
Previous
Next
FAQ's
WHAT IF I MISS A CLASS?
- You will never miss a lecture at Emax You can choose either of the option: View the recorded session of the class available in your LMS.
WHAT IF I HAVE QUERIES AFTER I COMPLETE THIS COURSE?
Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.
HOW SOON AFTER SIGNING UP WOULD I GET ACCESS TO THE LEARNING CONTENT?
Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover the access to our 24×7 support team will be granted instantly as well. You can start learning right away.
IS THE COURSE MATERIAL ACCESSIBLE TO THE STUDENTS EVEN AFTER THE COURSE TRAINING IS OVER?
Yes, the access to the course material will be available for lifetime once you have enrolled into the course.
