Sap Hana Administration

SAP HANA 2.0 Installation and Administration

What you'll learn

SAP HANA Architecture

Preparation of SAP HANA Installation and H/W Sizing

Installation of SAP HANA System

Post Installation activity

HANA Administration Tools

HANA database Administration

Backup and Recovery of SAP HANA

Multi tenant Database Administration

Instillation and configuration of Replication Server

HANA System Monitoring

Requirements

Basic understanding of SAP HANA, Linux and System Administration

Description

SAP HANA system administrators are responsible for installing and ensuring continuous operation of all SAP HANA databases deployed in the corporate environment. 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.In this course, we’ll learn about the different tasks available to manage SAP HANA systems, with all administration tool, including SAP HANA cockpit web-based tool. We’ll examine the operations offered for both individual and multiple database administration, resource monitoring, configuration management and backup and recovery. We’ll also explore factors that affect performance, such as analyzing memory usage, SQL statements, and workloads.Course also covers installation of SAP HANA, HANA replication server installation and configuration. This course uses demonstrations to highlight key aspects, and hands-on exercises to reinforce learning points.Highlights :- · Preparations of HANA Installation· HANA Installation & Post Installation Tasks· SAP HANA Architecture· SAP HANA Cockpit 2.0· SAP HANA Scenarios and Deployment Options· Tools & Database Administration· Backup and Recovery· Managing Multitenant Database· SAP HANA High Availability & SAP HANA Disaster Tolerance· SAP HANA Fault Tolerance· SAP HANA System & Proactive Monitoring

Overview

Section 1: Introduction

Lecture 1 Introduction to course

Lecture 2 Introduction to SAP HANA

Lecture 3 SAP HANA Documentation and Support

Section 2: Preparations of HANA Installation

Lecture 4 Sizing of SAP HANA System

Lecture 5 Operating System Requirements

Section 3: HANA Installation

Lecture 6 HANA Lifecycle Management Tools

Lecture 7 HANA Advanced Installation

Lecture 8 Distributed Systems

Lecture 9 Install a SAP HANA System

Section 4: SAP HANA Architecture

Lecture 10 SAP HANA Architecture

Lecture 11 SAP HANA Memory Management

Section 5: SAP HANA Cockpit 2.0

Lecture 12 Introducing SAP HANA Cockpit

Lecture 13 Installing SAP HANA Cockpit

Lecture 14 Configuring SAP HANA Cockpit

Lecture 15 Updating SAP HANA Cockpit

Section 6: SAP HANA Scenarios and Deployment Options

Lecture 16 SAP HANA Scenarios and Roadmap

Lecture 17 Deployment Options Identifying

Section 7: Post Installation Tasks

Lecture 18 Post-Installation Steps

Lecture 19 Updating SAP HANA

Lecture 20 Resident SAP HDBLCM Tool

Lecture 21 SAP HANA Interactive Education (SHINE)

Lecture 22 SAP HANA Revision Strategy

Section 8: Administration Tools

Lecture 23 SAP HANA Administration Tools

Lecture 24 HDBSQL - Command Line Tool

Lecture 25 SAP HANA DBA Cockpit

Lecture 26 SAP HANA Studio

Section 9: Database Administration

Lecture 27 Starting and Stopping SAP HANA

Lecture 28 Configuring the SAP HANA Database

Lecture 29 Database Administration Tasks

Lecture 30 SAP HANA Mini Checks

Lecture 31 Configuring Traces

Lecture 32 Diagnosis Information and Diagnosis Files

Lecture 33 Using the SQL Console

Lecture 34 SAP HANA Table Administration

Section 10: Backup and Recovery

Lecture 35 Backup and Recovery Introduction

Lecture 36 Backup Strategy

Lecture 37 HANA Database Backup

Lecture 38 HANA Database Recovery

Section 11: Multitenant Database

Lecture 39 Creating Tenant

Lecture 40 Starting and Stopping Tenants

Lecture 41 Renaming and Deleting Tenants

Lecture 42 Backup and Restore Tenant

Lecture 43 Tenant Resource Allocation

Section 12: SAP HANA High Availability Overview

Lecture 44 SAP HANA High Availability

Lecture 45 Fault Recovery in SAP HANA

Lecture 46 Disaster Recovery in SAP HANA

Section 13: SAP HANA Fault Tolerance

Lecture 47 SAP HANA Scale-out

Lecture 48 High Available SAP HANA

Section 14: SAP HANA Disaster Tolerance

Lecture 49 HANA System Replication Overview

Lecture 50 HANA System Replication Configuration

Lecture 51 HANA System Replication Monitoring

Section 15: SAP HANA System Monitoring

Lecture 52 SAP HANA Memory Analysis

Lecture 53 SAP HANA CPU Analysis

Lecture 54 SAP HANA Expensive Statements Analysis

Section 16: Proactive Monitoring

Lecture 55 SAP HANA Alerting Framework

Lecture 56 SAP HANA Workload Management

Section 17: Conclusion

Lecture 57 Conclusion

SAP Basis Administrator,SAP System and Data Center Administration,SAP Business Solution and SAP Project Manager