SAP HANA ADMIN

SAP HANA ADMIN

SAP HANA ADMIN ONLINE TRAINING

  •    Rating
  •   Duration 35-40 Hours
  •      Fee $ 450

Request Free Demo

SAP HANA ADMIN TRAINING VIDEOS

  •    Rating
  •   Duration 30 Hours
  •      Fee $ 350

Buy Now



What Is SAP HANA ADMIN Training-

What type of learning curve should you expect when it comes to administering SAP HANA? SAP HANA uses SQL. If you have experience working with modern administrative tools that leverage SQL, then you will be pleased to find that the learning curve is rather minimal. We witnessed this at SAP TechEd this year. We offered hands-on sessions for the SAP HANA studio. Participants were a bit tentative until they had a chance to log on to the SAP HANA studio. The attendees began experimenting based on their own SQL knowledge, and we noticed they started to be relaxed. They discovered that they were able to work well with the tooling, and they realized that they were already familiar with most of the SAP HANA admin concepts.

SAP HANA ADMINISTRATION Course Content

Week-1

Introduction to SAP HANA

SAP In-Memory Strategy

HANA compare to BWA

In-Memory Computing

Hardware-Innovations

Software-Innovations

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 EDITIONS

SAP HANA Platform Edition

SAP HANA Enterprise Edition

SAP HANA Enterprise Extended Edition

Week-2

SAP HANA VERSIONS

HANA 1.0 SPS03

HANA 1.0 SPS04—NEW Features

HANA 1.0 SPS05—NEW Features

HANA 1.0 SPS06—NEW Features

HANA 1.0 SPS07—NEW Features

HANA 1.0 SPS08—NEW Features

HANA 1.0 SPS09—NEW Features

SAP HANA EDITIONS

SAP HANA Platform Edition

SAP HANA Enterprise Edition

SAP HANA Enterprise Extended Edition

Week-3

SAP HANA SIZING

SAP HANA In-Memory Database Sizing elements

RAM, Disk, CPU

Memory Sizing

CPU Sizing

SAP HANA Scale Out

SAP HANA PRE AND POST INSTALLATIONS

Preparing SAP HANA Installation

Reviewing SAP HANA Installation

Post-Installation steps

LOOK AND FEEL

In-Memory Computing Studio

Administration view

Navigator View

System Monitor

Information Modeler

ARCHITECTURE

Architecture Overview

IMCE and Surroundings

Row Store

Column Store

Loading data into HANA

Data Modeling

Persistent Layer

Backup & Recovery

Week-4

SAP HANA HARDWARE AND SOFTWARE REQUIREMENTS

Prepare Installation parameters

Users created during Installation

Required Installation media

Prepare Installer Configuration file

INSTALLING SAP HANA

SAP HANA unified Installer Tool

Unified Installer to install the Sap HANA SERVER

Components installed by Installer

Command based Installation

GUI based Installation

SAP HANA TOOL OVERVIEW

SAP HANA Studio

DBA Cockpit

HDBSQL Command Line Tool

INSTALL HANA STUDIO

System Requirements

Supported Platforms

Install SAP HANA Studio

POST-INSTALLATION STEPS

Starting and Stopping SAP HANA System

Displaying Process List

Logging on to HANA system using HANA studio

User Security

Monitoring HANA Landscape

SAP HANA OPERATION

Starting & Stopping SAP HANA

Starting SAP HANA Database

Stopping SAP HANA Database

Displaying Process List

Monitoring HANA Landscape

Periodic Manual Tasks

Week-5

DATA PROVISIONING USING 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

Installation Aspects

Configuration Steps for SLT replication server

Setup Data Replication

Database-Supportability

Landscape strategy of SLT replication server

SLT replication server Installation Options

Technical Requirements and system setup

INFORMATION

Configuring HANA Studio for importing Metadata

Importing Metadata

Mass Import

Selective Import

Load Data Via Data services into SAP HANA

SAP HANA DIRECT EXTRACTOR CONFIGURATION

Introduction to SAP HANA Direct Extractor

CONNECTION (DXC)

Limitations of DXC

Setup and Configurations

Enabling Services

HTTP Connection

Test Connection

Week-6

MAINTAINING USERS & AUTHORIZATIONS (SAPHANA SECURITY)

Create Users

User and Role Concept

Creating Roles

Assigning Privileges to Roles

Privileges

SQL Privileges

System Privileges

Analytic Privileges

Reporting and Privileges

Modeling required Privileges

SAP HANA DB BACKUP AND RECOVERY

System Configuration Parameters

Monitoring and system state parameters

Backup & Recovery SAP HANA

Need of Backup

Backup Types

Data Backup

Log Backup

Recovery Options

Recovery in Replication Scenarios

Backup to External Backup Destinations

Recovery Scenarios

Power Failure

Disk Failure

MONITORING AND TROUBLESHOOTING

Configuring Remote Support

Solution Manager Integration

Remote Service Connection

Availability Monitoring

Setting up Monitoring

System Monitoring Setup

Status Overview

Services Overview

System Load History

Disk Usage Details

Checking System Configuration

Alerts

SAP HANA LOGS & TRACES

Regular administration tasks

Troubleshooting

Analyzing performance

Auditing SAP HANA

Global Audit Configuration

Manage Audit Policies

Audit Events

Audit Trail

Quick Enquiry