BESTWAY TECHNOLOGIES LOGO

+91 - 9000567126, +91 - 9848686581

bestwaytechnologies@gmail.com

SAP HANA ADMINISTRATION


We are Provides SAP HANA ADMINISTRATION  Online Training in India with Real time working Professionals.

SAP HANA Admin Major Concepts

  • SAP HANA Technology Overview
  • SAP HANA Versions
  • SAP HANA Pre and Post Installations
  • HANA Architecture
  • Installing SAP HANA
  • Data Provisioning Using SLT
  • SAP HANA Security
  • SAP HANA DB Backup and Recovery
  • Monitoring and Troubleshooting
  • REPLICATION
  • SAP HANA Logs & Traces

 

SAP HANA ADMINISTRATION Course Content 

1). SAP HANA Technology Overview

  •  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 VERSIONS

2) . SAP HANA Versions

  •  HANA 1.0 SPS10—NEW Features
  •  HANA 1.0 SPS11—NEW Features
  •  HANA 1.0 SPS12—NEW Features

3). SAP HANA Editions

  •  SAP HANA Platform Edition
  •  SAP HANA Enterprise Edition
  •  SAP HANA Enterprise Extended Edition

4).  SAP HANA Sizing

  •  SAP HANA In-Memory Database Sizing elements
  •  RAM, Disk, CPU
  •  Memory Sizing
  •  CPU Sizing
  •  SAP HANA Scale Out

5). SAP HANA Pre and Post Installations

  •  Preparing SAP HANA Installation
  •  Reviewing SAP HANA Installation
  •  Post-Installation steps
  •  Understand about Memory computing studio, Switching between different views and about system monitor in HANA.

6). Look and Feel

  •  In-Memory Computing Studio
  •  Administration view
  •  Navigator View
  •  System Monitor
  •  Information Modeler

7).  Architecture

  •  Architecture Overview
  •  IMCE and Surroundings
  •  Row Store
  •  Column Store
  •  Loading data into HANA
  •  Data Modeling
  •  Persistent Layer
  •  Backup & Recovery

8). SAP HANA Hardware and software Requirements

  •  Prepare Installation parameters
  •  Users created during Installation
  •  Required Installation media
  •  Prepare Installer Configuration file

9). 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

10). SAP HANA Tool Overview

  •  SAP HANA Studio
  •  DBA Cockpit
  •  HDBSQL Command Line Tool

11). Install HANA Studio

  •  Know the system requirements and supported Platforms to install SAP HANA
  •  System Requirements
  •  Supported Platforms
  •  Install SAP HANA Studio

12). 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

13). SAP HANA Operation

  •  Starting & Stopping SAP HANA
  •  Starting SAP HANA Database
  •  Stopping SAP HANA Database
  •  Displaying Process List
  •  Monitoring HANA Landscape
  •  Periodic Manual Tasks

14).  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

15). SAP HANA Direct Extractor Configuration

  •  Introduction to SAP HANA Direct Extractor
  •  Connection (DXC)
  •  Learn, how to enable the services,  configuration, setup,
  •  Limitations of DXC
  •  Setup and Configurations
  •  Enabling Services
  •  HTTP Connection
  •  Test Connection

16). 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

17).  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

18).  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

19). SAP HANA Logs & Traces

  •  Regular administration tasks
  •  Troubleshooting
  •  Analyzing performance
  •  Auditing SAP HANA
  •  Global Audit Configuration
  •  Manage Audit Policies
  •  Audit Events
  •  Audit Trail

20). REPLICATION

  •  Configure System Replication for System
  •  Enable System Replication
  •  Registering Secondary System
  •  Unregistering Secondary System
  •  Perform Takeover

21). SAP HANA TABLE Administration

  •  Table partitioning (Hash/Range)

22). MULTI DATABASE CONTAINERS

  •  Single System DB to MDC
  •  Creating Tenant DB
  •  Dropping Tenant DB
  •  Cross Tenant DB access

23). HANA SYSTEM DB REFRESH

  • Request Demo

  • Add Your Review