SAP HANA Installation, Operation and Administration

Name: SAP HANA Installation, Operation and Administration
Rating: 4.1 (1351 reviews)

Learn how to setup a SAP HANA environment from scratch to operate, administer, manage a distributed landscape.

Created byJunaid Ahmed

Last updated 12/2024

English

What you'll learn

Setup up an SAP HANA Environment
Install SAP HANA in different modes and Configurations
Configure SAP HANA DB post installation
Operate and Administer SAP HANA Landscape
Monitor SAP HANA with different Monitoring Tools
Setup end to end Security
Backup and Recover SAP HANA DB
Understand High Availability and Disaster Recovery

Course content

14 sections • 61 lectures • 6h 33m total length

Get introduced to SAP HANA5:39
Understand the big data problem.

What is SAP HANA ?

Understand SAP HANA solution proposition.
Main SAP HANA Features7:14
Understand what is inside SAP HANA.

Understand In-memory concept and other features

Installation Landscape Overview1:06
Clarify the SAP HANA System concepts and system types
Software Components8:35
Understand Software Packaging in SAP HANA.
Pre-Requisites before Installing SAP HANA5:16
Understand what needs to be installed and configurations required on SUSE linux
Understand paths,required parameters and users7:38
Understand the SAP HANA file structure. Parameters and the users created during installation.
Understand Installation Options2:02
Understand the various installation methods
Install SAP HANA DB using HDBLCM GUI11:59
Use HDBLCM GUI to install a SAP HANA DB
Install SAP HANA DB Using HDBLCM6:08
Use HDBLCM command prompt to install the DB
Important: Often used Paths5:02
Get comfortable with the most used paths
Uninstalling the SAP HANA DB with HDBLCM3:33
Uninstall SAP HANA DB using HDBLCM command prompt
Advanced : Installing SAP HANA in batch mode using HDBLCM3:39
Understand the use of the configuration file in batch mode
Installing client and studio in Windows8:22
Install SAP HANA studio and Client on Windows Machine.
Connecting SAP HANA Studio with the DB4:55
Understand the connectivity of SAP HANA Studio with the DB.
Understand how to use the host file for ip mapping
SAP HANA Multiple Host Installation7:07
Explore how SAP HANA handles multiple host installation, configuring local and shared storage, partitions, and master, slave, and standby roles with name server and index server for high availability.

Understand Multi Container/ tenent DB Concept10:27
Explain the architecture of multitenant database containers
Installing SAP HANA as a Multi Container7:35
Install SAP HANA DB in Multi Tenant DB mode.
Connecting to a Multi container from SAP HANA Studio6:55
connect to the DB from the Client using SAP HANA studio in Multi Container Mode
Create a Tenant Database6:25
After Installation, create a Tenant Database from the OS level
Multi Container DB Management ( Start/Stop/Cross Tenant Query)6:38
Manage multi container DB's from the Studio, understand the difference.

SAP HANA Studio7:09
Understand the basic functions of the SAP HANA studio

Explain the concept of perspectives

Add an SAP HANA system to an SAP HANA Studio installation

Obtain an initial system overview in the Administration Console of the SAP HANA studio
SAP HANA Studio - Fiori and Web tools5:55
Understand the basic functions of the SAP HANA Cockpit and Monitoring dashboard.

Use Tile based Fiori admin console.
DBA Cockpit9:54
Understand the basic functions of the DBA Cockpit.

Connect to SAP HANA DB

Monitor SAP HANA using DBACOCKPIT
DBSQL3:02
Know about the capabilities of HDBSQL

Establish a connection to SAP HANA using HDBSQL and execute commands

Starting and Stopping SAP HANA Part 1 -Server Side6:53
Start and stop Single and Muliti Host SAP HANA using command line
Starting and Stopping SAP HANA Part 2 - Studio Side8:41
Start and stop SAP HANA using SAP HANA Studio
Configuring SAP HANA Part 1 - Server Side8:42
Know where configuration files are stored.
Configuring SAP HANA Part 2 - Studio Side9:35
Configure the SAP HANA studio

Configure the SAP HANA database

Maintain Properties in HANA studio

Maintain Preferences in HANA studio
SAP HANA Table Administration - Basics9:56
For SAP HANA administrators table administration is an important task.

In this lesson details on table definition and partitioning are covered.
SAP HANA Table Administration - Load, Unload, Delta-Merge9:28
Load and unload column store tables manually

Trigger delta merge operations manually
SAP HANA Table Administration - Table Partitioning Theory7:41
Understand the advantages of table partitioning

Know which single-level and Multi Level partitioning in SAP HANA
SAP HANA Table Administration - Hash and Range Partition8:33
Use the Table Distribution Editor in SAP HANA Studio

Partition tables

Check partitioning consistency
SAP HANA Table Administration - Sql Syntax to manage Tables2:38
Use Sql commands to manage the Tables.

Configuring Traces12:02
how to activate the traces within SAP HANA studio

Check the trace files
Working with Diagnose files4:14
Open diagnosis files for analysis

Delete/merge files

Download files

Collect and download diagnosis information
Standard System Tables - SQL Console - Running standard Admin Queries4:00
Understand the Standard system schemas and tables, Run pre-built admin queries.
How to analyze a Query6:45
Analyze SQL execution with the plan explanation

Analyze SQL execution with the Plan Visualizer

Analyze SQL execution with the SQL plan cache

Requirements

Have basic information about SAP HANA, Linux and System Administration

Description

SAP HANA is a game changing and best selling product in the history of SAP. Helping companies solve data,reporting,latency challenges and unleash their potential with a real time platform. Learn it by implementing real time use cases, get started with the new and exciting world of real time reporting, analytic's and big data.

In this course you will learn how to install, configure, operate and administer a SAP HANA Landscape.
We start with the Introduction and then move to installation and update, we see different options and modes.
Then we get to know the administration tools ,we also see how to configure the db *
Later we see how to administer, perform standard administrator tasks, setup end to end security and understand how to setup HA and DR.
Towards the end we see back-up and recovery.

Engaging Teaching:

Expressive and immersive teaching with demonstrations and learning tools
Small, purposeful videos, packed with information, designed specifically for a virtual self paced audience.

Credits:I have used SAP Guides, Manuals, Slides, SCN blogs as reference. Credits are due to the corresponding parties.

* SAP HANA express edition can be used for your learning purposes

Who this course is for:

This course is for System Administrators, Architects and Anybody who want to install and operate SAP HANA

SAP HANA Installation, Operation and Administration

What you'll learn

Explore related topics

Course content

SAP HANA Introduction2 lectures • 13min

Setting up VMware and Installing SUSE Linux1 lecture • 8min

SAP HANA Installation13 lectures • 1hr 15min

Post Installation Checks2 lectures • 12min

Updating and Patching SAP HANA3 lectures • 21min

Sizing and Scenarios2 lectures • 14min

SAP HANA Multi Container DB Installation5 lectures • 38min

SAP HANA Administration tools4 lectures • 26min

SAP HANA Operations9 lectures • 1hr 12min

Monitoring and Troubleshooting4 lectures • 27min

Requirements

Description

Who this course is for: