SAP HANA Installation, Operation and Administration
3.9 (199 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,432 students enrolled
Wishlisted Wishlist

Please confirm that you want to add SAP HANA Installation, Operation and Administration to your Wishlist.

Add to Wishlist

SAP HANA Installation, Operation and Administration

Learn how to setup a SAP HANA environment from scratch to operate, administer, manage and distributed a landscape.
3.9 (199 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
1,432 students enrolled
Created by Junaid Ahmed
Last updated 7/2017
English
Current price: $10 Original price: $200 Discount: 95% off
5 hours left at this price!
30-Day Money-Back Guarantee
Includes:
  • 6.5 hours on-demand video
  • 2 Articles
  • 1 Supplemental Resource
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I 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 Lanscape
  • Monitor SAP HANA with different Monitoring Tools
  • Setup end to end Security
  • Backup an Recover SAP HANA DB
  • Understand High Availability and Disaster Recovery
View Curriculum
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:

  1. Expressive and immersive teaching with demonstrations and learning tools
  2. 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.

* Suser ID with sufficient privileges is required for downloading the software directly from SAP.

Who is the target audience?
  • This course is for System Administrators, Architects and Anybody who want to install and operate SAP HANA
Students Who Viewed This Course Also Viewed
Curriculum For This Course
64 Lectures
06:40:01
+
SAP HANA Introduction
3 Lectures 14:15

Understand the big data problem.

What is SAP HANA ?

Understand SAP HANA solution proposition.

Preview 05:39

Understand what is inside SAP HANA.

Understand In-memory concept and other features

Preview 07:14
+
Setting up VMware and Installing SUSE Linux
2 Lectures 09:50

Get to know from where to and how to download the SAP HANA.

Download
01:52

You will be able to configure a VM and install SUSE Linux.

Creating and Configure a new Virtual Machine with SUSE Linux operating system
07:58
+
SAP HANA Installation
14 Lectures 01:18:46

Clarify the SAP HANA System concepts and system types

Installation Landscape Overview
01:06

Understand from where and how to download the DB

Download SAP HANA and sub components
03:24

Understand Software Packaging in SAP HANA.

Software Components
08:35

Understand what needs to be installed and configurations required on SUSE linux

Pre-Requisites before Installing SAP HANA
05:16

Understand the SAP HANA file structure. Parameters and the users created during installation.

Understand paths,required parameters and users
07:38

Understand the various installation methods

Understand Installation Options
02:02

Use HDBLCM GUI to install a SAP HANA DB

Install SAP HANA DB using HDBLCM GUI
11:59

Use HDBLCM command prompt to install the DB

Install SAP HANA DB Using HDBLCM
06:08

Get comfortable with the most used paths

Important: Often used Paths
05:02

Uninstall SAP HANA DB using HDBLCM command prompt

Uninstalling the SAP HANA DB with HDBLCM
03:33

Understand the use of the configuration file in batch mode

Advanced : Installing SAP HANA in batch mode using HDBLCM
03:39

Install SAP HANA studio and Client on Windows Machine.

Installing client and studio in Windows
08:22

Understand the connectivity of SAP HANA Studio with the DB.

Understand how to use the host file for ip mapping


Connecting SAP HANA Studio with the DB
04:55

SAP HANA Multiple Host Installation
07:07
+
Post Installation Checks
2 Lectures 11:41

Understand Licensing information and how to install it.

Manage Licenses
03:58

Take a tour on the OS to check the functioning of the installed components

Check Installation Health and Components
07:43
+
Updating and Patching SAP HANA
3 Lectures 20:31

Update SAP HANA components using HDBLCM GUI from the OS level

Update using HDBLCM GUI
06:23

Update SAP HANA components using HDBLCM from the client using SAP HANA Studio

More Oprtions: Update Using HDBLCMWEBGUI and Studio LCM
06:06

Installing and uninstalling separate components

Removing and Adding additional components like AFL
08:02
+
Sizing and Scenarios
2 Lectures 13:43

What needs to be taken into consideration when sizing an SAP HANA system

Sizing the DB
09:15

Understand the road map and the different landscape scenarios

Installation/Landscape Scenarios
04:28
+
SAP HANA Multi Container DB Installation
5 Lectures 38:00

Explain the architecture of multitenant database containers

Understand Multi Container/ tenent DB Concept
10:27

Install SAP HANA DB in Multi Tenant DB mode.

Installing SAP HANA as a Multi Container
07:35

connect to the DB from the Client using SAP HANA studio in Multi Container Mode

Connecting to a Multi container from SAP HANA Studio
06:55

After Installation, create a Tenant Database from the OS level

Create a Tenant Database
06:25

Manage multi container DB's from the Studio, understand the difference.

Multi Container DB Management ( Start/Stop/Cross Tenant Query)
06:38
+
SAP HANA Administration tools
4 Lectures 26:00
  • 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
07:09

Understand the basic functions of the SAP HANA Cockpit and Monitoring dashboard.

Use Tile based Fiori admin console.

SAP HANA Studio - Fiori and Web tools
05:55

  • Understand the basic functions of the DBA Cockpit.
  • Connect to SAP HANA DB
  • Monitor SAP HANA using DBACOCKPIT
DBA Cockpit
09:54

  • Know about the capabilities of HDBSQL
  • Establish a connection to SAP HANA using HDBSQL and execute commands

DBSQL
03:02
+
SAP HANA Operations
9 Lectures 01:12:07

Start and stop Single and Muliti Host SAP HANA using command line

Starting and Stopping SAP HANA Part 1 -Server Side
06:53

Start and stop SAP HANA using SAP HANA Studio

Starting and Stopping SAP HANA Part 2 - Studio Side
08:41

Know where configuration files are stored.

Configuring SAP HANA Part 1 - Server Side
08:42

  • Configure the SAP HANA studio
  • Configure the SAP HANA database
  • Maintain Properties in HANA studio
  • Maintain Preferences in HANA studio
Configuring SAP HANA Part 2 - Studio Side
09:35

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 - Basics
09:56

Load and unload column store tables manually

Trigger delta merge operations manually

SAP HANA Table Administration - Load, Unload, Delta-Merge
09:28

  • Understand the advantages of table partitioning
  • Know which single-level and Multi Level partitioning in SAP HANA
SAP HANA Table Administration - Table Partitioning Theory
07:41

  • Use the Table Distribution Editor in SAP HANA Studio
  • Partition tables
  • Check partitioning consistency
SAP HANA Table Administration - Hash and Range Partition
08:33

Use Sql commands to manage the Tables.

SAP HANA Table Administration - Sql Syntax to manage Tables
02:38
+
Monitoring and Troubleshooting
4 Lectures 27:01
  • how to activate the traces within SAP HANA studio
  • Check the trace files
Configuring Traces
12:02

  • Open diagnosis files for analysis
  • Delete/merge files
  • Download files
  • Collect and download diagnosis information
Working with Diagnose files
04:14

Understand the Standard system schemas and tables, Run pre-built admin queries.

Standard System Tables - SQL Console - Running standard Admin Queries
04:00

  • Analyze SQL execution with the plan explanation
  • Analyze SQL execution with the Plan Visualizer
  • Analyze SQL execution with the SQL plan cache
How to analyze a Query
06:45
4 More Sections
About the Instructor
Junaid Ahmed
4.1 Average rating
1,053 Reviews
7,412 Students
7 Courses
Entrepreneur, Product Designer, Architect and Trainer

Hello there! I am Junaid Ahmed. I have a bachelors in electrical and electronics engineering and a masters in software engineering . I would like to call my self a technologist, I am excited to learn new technologies, working and teaching on them.

I come from a background of enterprise software, and I am currently also focusing on Internet of things(IOT) and building products. I have worked for over 10+ years with enterprise applications, reporting and security products from SAP and Oracle. I have consulted with large organizations in Government, Telecom, Power, FMCG sectors and start-ups.I manage projects using agile methods and tools. I hold certifications in SAP HANA and scrum master . As far as training goes I have been involved in on site and online Training for the last 6 years in different products and practices including SAP HANA, BODS, BOBJ Suite, soft skills and IOT. I have over 6000+ students enrolled in my courses on Udemy. My clients include Consulting Companies, Implementation partners and Consultants. Currently, I have also started working with firms to provide solution in the IOT space.

Happy Learning!