An error occurred while loading the video player, or it takes a long time to initialize. You can try clearing your browser cache. Please try again later and contact the helpdesk if the problem persists.

Join this free online course to learn how to analyze query performance issues in SAP HANA and optimize queries yourself, including investigating out-of-memory (OOM) issues deriving from queries and finding solutions to improve execution time.

Please note: There is additional learning material related to the topic of this course available on the SAP Learning site I Learning Journey Discovering SAP Business Technology Platform.

Self-paced since December 16, 2020
Language: English
Subtitles (auto-generated): Deutsch, English, Français, Español

Course information

Course Summary

SAP HANA provides a robust set of techniques for advanced query processing. To fully benefit from the capabilities of SAP HANA, the first step is to optimize your queries. For better performance, it’s also important to understand the characteristics of SAP HANA and the techniques that can be applied to improve the execution time, as well as the analysis tools you can use to investigate query performance issues.
In this course, you’ll learn how to analyze query performance issues in SAP HANA and optimize queries yourself, including investigating out-of-memory (OOM) issues deriving from queries and finding solutions to improve execution time.
You’ll discover SQL processing, for example, how SQL queries are processed in SAP HANA, and how the SAP HANA SQL optimizer works.
This course also contains techniques and insights that can be applied to improve SQL performance after introducing SAP HANA-specific features such as column search. You’ll also explore the tools that can be used for performance analysis, such as various monitoring views, EXPLAIN PLAN, and PlanViz.
At the end of the course, you’ll work on case studies that illustrate some of the key points.
The course includes demos to highlight key aspects and hands-on exercises to reinforce learning points.

Here is what some participants are saying about the course:

  • "Got way deeper than expected/required (using DMC staging table). Was really interesting and full of useful knowledge. Congrats to the OpenSAP teams!" Read the original post

  • "This course was very helpful for me, as I had already an experience in SQL, but i learned a lot of things i didn't know." Read the original post

  • "Thanks very much to Helen, Jinyeon and the openSAP team for this course which was very instructional and informative. I will be waiting for the Second Step in Query Optimization." Read the original post

  • "This is a great class to help me how to fix the Hana performance issues. Thank you very much for both instructors to prepare a very good class both in videos and documentation." Read the original post

  • "This course was really good, deep technical and best I've done. Looking forward to a second part including basis admin." Read the original post

  • "I like this course because I learned a lot of new tips and tricks. I also would like to see a successor course that dives deep into performance analysis and tuning of calculation views. In the business intelligence and analytics area these calculation views are heavily used because they provide a lot of benefits." Read the original post

Course Characteristics

Course Content

Week 1: SAP HANA Query Processing
Week 2: Column Search and Analysis Tools
Week 3: Methods for Query Performance Analysis
Week 4: Case Studies
Week 5: Final Exam

Target Audience

  • SAP HANA developers
  • SAP HANA consultants
  • Anyone interested in learning about SAP HANA query performance

Course Requirements

  • Basic knowledge of SQL

Hands-On Systems

If your primary interest in taking this course is getting an overview about SAP HANA Query Optimization, you don’t need access to a hands-on system.
However, we will also offer optional hands-on exercises so you can better familiarize yourself with query processing and query optimization in SAP HANA.
For these exercises, you can use a system image from the SAP Cloud Appliance Library. We will provide details on how to access the system image and the costs at the beginning of the course.

About Further Content Experts

SukHyun An

SukHyun An

SukHyun An is an SAP HANA database product senior specialist with the SQL Performance Consulting Team.
SukHyun designs, develops, and publishes technical information such as the SAP HANA Performance Guide for Developers, SAP Notes, and training courses on SAP HANA SQL performance. Together with other SAP colleagues, he also solves query performance issues for customers.
Follow SukHyun on LinkedIn

Course contents

  • Week 1:

    SAP HANA Query Processing
  • Week 2:

    Column Search and Analysis Tools
  • Week 3:

    Methods for Query Performance Analysis
  • Week 4:

    Case Studies
  • I Like, I Wish:

    We Love Your Feedback … And Want More
  • Final Exam:

    Good Luck!

Reactivate this course

You can access all graded assignments and earn a Record of Achievement with openSAP, course reactivation option. Learn more or

Enroll me for this course

The course is free. Just register for an account on openSAP and take the course!
Enroll me now

Learners

Current
Today
22,171
Course End
Dec 16, 2020
14,086
Course Start
Nov 10, 2020
9,826

Rating

This course was rated with 4.35 stars in average from 1256 votes.

Certificate Requirements

  • Gain a Record of Achievement by earning at least 50% of the maximum number of points from all graded assignments.
  • Gain a Confirmation of Participation by completing at least 50% of the course material.

Find out more in the certificate guidelines.

This course is offered by

Jin Yeon Lee

Jin Yeon Lee is an SAP HANA database product expert with the SQL Performance Consulting Team in SAP HANA Development. He leads the team that transfers SAP HANA SQL performance tuning knowledge to customers.
As well as the topic of SQL performance, Jin Yeon is also in charge of the team in APJ, helping SAP HANA customers in SAP HANA Development.

Follow Jin Yeon on LinkedIn

Helen Shin

Helen Shin is an SAP HANA database product specialist with the SQL Performance Consulting Team. Working in SAP HANA Development, her focus is on helping customers fully benefit from the capabilities of SAP HANA from a SQL/SQLScript performance point of view.

Follow Helen on LinkedIn