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.8 (81 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.
702 students enrolled
Instructed by Junaid Ahmed IT & Software / Other
$200
Take This Course
  • Lectures 64
  • Contents Video: 6.5 hours
    Other: 12 mins
  • Skill Level Intermediate Level
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 7/2015 English

Course 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.

What are the requirements?

  • Have basic information about SAP HANA, Linux and System Administration

What am I going to get from this course?

  • 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

What is the target audience?

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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: SAP HANA Introduction
Welcome!
Preview
01:26
05:39

Understand the big data problem.

What is SAP HANA ?

Understand SAP HANA solution proposition.

07:14

Understand what is inside SAP HANA.

Understand In-memory concept and other features

Section 2: Setting up VMware and Installing SUSE Linux
01:52

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

07:58

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

Section 3: SAP HANA Installation
01:06

Clarify the SAP HANA System concepts and system types

03:24

Understand from where and how to download the DB

08:35

Understand Software Packaging in SAP HANA.

05:16

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

07:38

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

02:02

Understand the various installation methods

11:59

Use HDBLCM GUI to install a SAP HANA DB

06:08

Use HDBLCM command prompt to install the DB

05:02

Get comfortable with the most used paths

03:33

Uninstall SAP HANA DB using HDBLCM command prompt

03:39

Understand the use of the configuration file in batch mode

08:22

Install SAP HANA studio and Client on Windows Machine.

04: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 Installation
07:07
Section 4: Post Installation Checks
03:58

Understand Licensing information and how to install it.

07:43

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

Section 5: Updating and Patching SAP HANA
06:23

Update SAP HANA components using HDBLCM GUI from the OS level

06:06

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

08:02

Installing and uninstalling separate components

Section 6: Sizing and Scenarios
09:15

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

04:28

Understand the road map and the different landscape scenarios

Section 7: SAP HANA Multi Container DB Installation
10:27

Explain the architecture of multitenant database containers

07:35

Install SAP HANA DB in Multi Tenant DB mode.

06:55

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

06:25

After Installation, create a Tenant Database from the OS level

06:38

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

Section 8: SAP HANA Administration tools
07: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
05:55

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

Use Tile based Fiori admin console.

09:54
  • Understand the basic functions of the DBA Cockpit.
  • Connect to SAP HANA DB
  • Monitor SAP HANA using DBACOCKPIT
03:02
  • Know about the capabilities of HDBSQL
  • Establish a connection to SAP HANA using HDBSQL and execute commands

Section 9: SAP HANA Operations
06:53

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

08:41

Start and stop SAP HANA using SAP HANA Studio

08:42

Know where configuration files are stored.

09:35
  • Configure the SAP HANA studio
  • Configure the SAP HANA database
  • Maintain Properties in HANA studio
  • Maintain Preferences in HANA studio
09:56

For SAP HANA administrators table administration is an important task.

In this lesson details on table definition and partitioning are covered.

09:28

Load and unload column store tables manually

Trigger delta merge operations manually

07:41
  • Understand the advantages of table partitioning
  • Know which single-level and Multi Level partitioning in SAP HANA
08:33
  • Use the Table Distribution Editor in SAP HANA Studio
  • Partition tables
  • Check partitioning consistency
02:38

Use Sql commands to manage the Tables.

Section 10: Monitoring and Troubleshooting
12:02
  • how to activate the traces within SAP HANA studio
  • Check the trace files
04:14
  • Open diagnosis files for analysis
  • Delete/merge files
  • Download files
  • Collect and download diagnosis information
04:00

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

06:45
  • Analyze SQL execution with the plan explanation
  • Analyze SQL execution with the Plan Visualizer
  • Analyze SQL execution with the SQL plan cache
Section 11: High Avalabiliy and Disaster Recovery
04:40
  • Explain the continuous availability scenarios for SAP HANA
  • Explain the high availability scenarios for SAP HANA
Article
  • Understand high availability scenarios for SAP HANA
  • Understand the basics of SAP HANA scale out

Directly from SAP White paper.

Scale out can not be demonstrated due to obvious reasons of infrastructure.

Article

My take on HANA DR and Q&A from IBM

Section 12: Transporting Changes
03:16

Learn how Delivery units are used to transport models

05:02

Learn how to Export models to a local or a server location

05:32

Learn how to Import SAP HANA Models in between environments

04:30

Learn how to import BW models from BW into SAP system

07:11

Learn the maintenance features

Section 13: Managing Security, Users and Profiles
02:30

Learn the user life cycle and how to maintain Users in SAP HANA

07:37

Learn about how to use privileges and roles to build a user securty model

06:40

Learn how to give and restrict access to a SAP HANA Cube

04:46

Learn how to build the end to end security by mapping a BOBJ use to a SAP HANA user

Section 14: BackUp and Recovery
08:31

Explain the concept of backup and recovery

05:11

Understand the various modes of Data Back up and Perform the same

05:14

Understand the location and how to manage the frequency of Log Back up

05:45

Build a new Db with database copy using the recovery options

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Junaid Ahmed, 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 9+ 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 4 years in different products and practices including SAP HANA and now IOT. I have over 2000+ 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!

Ready to start learning?
Take This Course