SAP HANA Administration Training
SAP HANA Admin Training assists the learners’ ways to migrate from other traditional databases to HANA Database which is 3500 times faster Analytics and 4500 faster reporting speed.
SAP HANA Administration Training Curriculum
SAP HANA TECHNOLOGY OVERVIEW
Getting Started with the Overview of the architecture of SAP HANA systems, Creation of HANA Columnar Store and Differentiate between SAP HANA row store vs Columnar Storage.
Introduction to SAP HANA SAP
HANA compare to BWA
SAP HANA simplified Architecture
SAP HANA Extended Architecture
Business Intelligence Clients with HANA
HANA Columnar Store
SAP HANA row store vs Columnar Storage
SAP HANA VERSIONS
Learn different versions of SAP HANA in this module..
HANA .0 SPS03
HANA .0 SPS04—NEW Features
HANA .0 SPS05—NEW Features
HANA .0 SPS06—NEW Features
HANA .0 SPS07—NEW Features
HANA .0 SPS08—NEW Features
HANA .0 SPS09—NEW Features
SAP HANA EDITIONS
This module focus on various SAP HANA editions, like the SAP HANA Platform Edition, SAP HANA Enterprise Edition and SAP HANA Enterprise Extended Edition which bundles additional components for data provisioning.
SAP HANA Platform Edition
SAP HANA Enterprise Edition
SAP HANA Enterprise Extended Edition
SAP HANA SIZING
The critical factor for SAP HANA implementation is the right sizing of the server on the business requirement and this means correct calculation of amount off memory, the CPU processing power. SAP HANA sizing consists of Memory sizing for static data, Memory sizing of objects created during runtime, Disk sizing, CPU sizing.
SAP HANA In-Memory Database Sizing elements
RAM, Disk, CPU
SAP HANA Scale Out
SAP HANA PRE AND POST INSTALLATIONS
What are the steps to be configured during PRE, POST installations of SANA HANA and also gives you a brief overview about it.
Preparing SAP HANA Installation
Reviewing SAP HANA Installation
LOOK AND FEEL
Understand about Memory computing studio, Switching between different views and about system monitor in HANA.
In-Memory Computing Studio
HANA Navigator View
System Monitor in HANA
In this module, we will explain about the architecture of HANA, How to apply Backup and Recovery to the entire database and different storage formats in HANA.
IMCE and Surroundings
HANA Row Store
Loading data into HANA
Data Modeling in HANA
Persistent Layer in HANA
Backup & Recovery
SAP HANA HARDWARE AND SOFTWARE REQUIREMENTS
For SAP HANA several hardware and software requirements need to be fulfilled. In this module, you can find a complete list of all SAP HANA components and the respective SAP HANA hardware and software requirements..
Prepare HANA Installation parameters
Users created during HANA Installation
HANA Required Installation media
Prepare Installer Configuration file
INSTALLING SAP HANA
Learn, How to install SAP HANA from GUI as well as from Command prompt and also learn what are the components of HANA..
SAP HANA unified Installer, Tool Unified Installer to install the Sap HANA SERVER
HANA Components installed by Installer
Command based Installation
GUI based HANA Installation
SAP HANA TOOL OVERVIEW
By the end of this module, you will get an overview on SAP HANA studio, how the DBA Cockpit works with SAP HANA and also how to execute the SQL statements using HDBSQL command line tool.
SAP HANA Studio
HDBSQL Command Line Tool
INSTALL HANA STUDIO
Know the system requirements and supported Platforms to install SAP HANA studio..
Install SAP HANA Studio
HANA POST-INSTALLATION STEPS
Understand how to monitor HANA Landscape, HANA Security, Start, Stop the HANA system and also know the logging on HANA system.
Starting and Stopping SAP HANA System
Displaying Process List
Logging on to HANA system using HANA studio
HANA User Security
Monitoring HANA Landscape
SAP HANA OPERATION
Here will focus on Start, Stop SAP HANA Database and also to monitor HANA landscape..
Starting & Stopping SAP HANA
Starting SAP HANA Database
Stopping SAP HANA Database
Displaying Process List
Monitoring HANA Landscape
Periodic Manual Tasks
DATA PROVISIONING USING SLT
This session presents you about configuring Steps, Set-up and Architecture for SLT replication server and also about positioning, Different types of benefits of SLT.
Positioning and benefit of SLT for SAP HANA
Key benefits of Trigger-Based Approach
Architecture and building Blocks
Architecture for SAP Source Replication
Architecture for NON-SAP Source Replication
Set-up of LT replication server
Configuration Steps for SLT replication server
Setup Data Replication
Landscape strategy of SLT replication server
SLT replication server Installation Options
Technical Requirements and system setup
In this module, we will provide you, how to configure, Import HANA Studio for Metadata and to Load Data via Data Services into SAP HANA…
Configuring HANA Studio for importing Metadata
Load Data Via Data services into SAP HANA
SAP HANA DIRECT EXTRACTOR CONFIGURATION
We’ll give an introduction to SAP HANA Direct Extractor in this module..
Introduction to SAP HANA Direct Extractor
Learn, how to enable the services, setup, configuration, and also to provide connections for SAP HANA.
Limitations of DXC
Setup and Configurations
HTTP Connection and Test Connection
MAINTAINING USERS & AUTHORIZATIONS (SAPHANA SECURITY)
The identity of database users accessing SAP HANA is verified through a process called authentication. In this module, we’ll provide, how to create users, assign roles- privileges to the users as well as to the roles for SAP HANA Security.
User and Role Concept
Assigning Privileges to Roles
Modeling required Privileges
SAP HANA DB BACKUP AND RECOVERY
Backup and restore is the process of copying/storing data preemptively for the specific purpose of restoring, that same data can be used for restoration in an event such as loss of data in case hardware failure or accidental deletion or corruption of data.
System Configuration Parameters
Monitoring and system state parameters
Backup & Recovery SAP HANA
Need for Backup
Recovery in Replication Scenarios
Backup to External Backup Destinations
MONITORING AND TROUBLESHOOTING
Learn, How to monitor SAP HANA, Checking the availabililty of setting up, system monitoring, overview of Services and providing system alerts.
Configuring Remote Support
Solution Manager Integration
Remote Service Connection
Setting up Monitoring
System Monitoring Setup
System Load History
Disk Usage Details
Checking System Configuration
SAP HANA LOGS & TRACES
This module presents, how to troubleshoot performance in SAP HANA and also configuration to manage log file.
Regular administration tasks
Auditing SAP HANA
Global Audit Configuration
Manage Audit Policies
- 10 Days
- 0 Units
- 0 Hrs