SAP HANA Online Training2020-03-20T08:49:10+00:00

Project Description

SAP HANA Online Training

DURATION MODE OF TRAINING LEVEL
6 Weeks Online Advanced

Overview

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.

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.

SAP HANA Course Curriculum

  • 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
  • On-Premise
  • In the Cloud
  • Hybrid
  • Technical Deployment Options
    • SCOS
    • MCOS
    • MCOD
  • SAP HANA Data Provisioning (SLT)
  • As Primary Persistence
    • BW powered by HANA
    • Business suite powered by HANA
    • S/4 HANA
  • As Platform
  • 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
  • LCM as a graphical user interface
  • LCM as a command-line interface
  • LCM as a Web user interface
  • LCM Parameters Call Options
  • 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

  • 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
  • Install / Check HANA Licenses
  • Configure the Connection to SAP Service Marketplace
  • Users created during installation
  • Creating a DB User for Update and Rename
  • Enable Automatic Start
  • Locating all SAP HANA File System Components
  • Checking the Log Files
  • Repairing a Partially Installed System
  • Enabling the Installer Trace
  • Start and Stop the SAP HANA System
  • Display the Process List
  • Periodic Tasks
  • Scheduling of Recurring Administration Tasks
  • Uninstall the SAP HANA System Using the Graphical User Interface
  • Uninstall the SAP HANA System Using the Command-Line Interface
  • 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
  • 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
  • Change, Reset a System Property
  • System Properties in Multiple-Container Systems
  • Configure System Usage Type
  • Reserve Connections for Administrators
  • Initial Administration Tasks
  • Regular Administration Tasks
  • On-Demand Administration Tasks
  • 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
  • SAP HANA Scale Out
  • High Availability
  • Faulty Recovery
  • Disaster Recovery
  • Concept of Backup and Recovery
  • Data, Log Area Backup
  • Database Copy
  • Recovery
  • Backup and Recovery using Storage Snapshot
  • Authentication and Authorization in SAP HANA
  • Types of Privileges, Roles
  • SAP HANA User Management
  • Authorization Trace and Auditing
  • Integrative Authorization Scenarios
  • DMO – Conceptional Overview
  • The DMO Procedure in Detail



Other Courses

SAP FICO Online Training
SAP SD Online Training
SAP HR Online Training
SAP MM Online Training
SAP ABAP Online Training
SAP BASIS Online Training
SAP SUCCESS FACTORS Online Training
SAP SIMPLE FINANCE Online Training
Python Online Training
Azure Online Training
LINUX Online Training
AWS Online Training
DIGITAL MARKETING Online Training
Data Science Online Course
DEVOPS Online Training
TABLEAU Online Training
IOT Online Training
Blockchain Online Course