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 about the SQLScript optimizer and how it helps to run SQLScript in SAP HANA more efficiently.

Please note: There is additional learning material related to the topic of this course available on the SAP Learning site I Learning Journey Building side-by-side extensions on SAP BTP.

Self-paced since July 12, 2023
Language: English
Subtitles (auto-generated): Deutsch, English, Français, Español

Course information

Course Summary

SQLScript is a programming language of SAP HANA to embed data-intensive application logic into the database. It supports imperative programming constructs like assignments, branches, loops, and exception handlers, as well as declarative Structured Query Language (SQL) queries. To run SQLScript efficiently and faster, the SQLScript engine uses the SQLScript optimizer.

In this course, you’ll learn how the SQLScript optimizer works. You’ll discover the general analysis strategy for SQLScript performance issues associated with SQL query performance and the SQLScript optimizer, explore the supportability features of SQLScript, and review case studies.

Here is what some participants are saying about the course:

" I am very grateful for the training course. I find the topics covered very interesting and useful for my daily work and to learn new things.…” Read the original post

" Excellent course and thank you for all these amazing courses.…” Read the original post

“Thank you very much for this great course. Perfectly explained with many very clear examples.…” Read the original post

Course Characteristics

Course Content

Week 1: Understanding SAP HANA SQLScript Optimizer
Week 2: SAP HANA SQLScript Supportability Features
Week 3: Investigating SQLScript Performance Caused by SQL
Week 4: Final Exam

Target Audience

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

Course Requirements

Basic knowledge of SAP HANA SQLScript

Hands-on Exercises

In this course, SAP HANA Cloud and SAP HANA database explorer will be used for examples and demos by default.
However, you can replicate all the examples in any SAP HANA system. If you are using an SAP HANA on-prem system, it is recommended to use HANA2 SPS5 or a higher version.

Further Learning

A First Step Towards SAP HANA Query Optimization

About Further Content Experts

SukHyun An

SukHyun An

SukHyun An is an SAP HANA database product expert 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:

    Understanding SAP HANA SQLScript Optimizer
  • Week 2:

    SAP HANA SQLScript Supportability Features
  • Week 3:

    Investigating SQLScript Performance Caused by SQL
  • 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
8,301
Course End
Jul 12, 2023
6,468
Course Start
Jun 13, 2023
5,150

Rating

This course was rated with 4.25 stars in average from 411 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

Tae-Suk Son

Tae-Suk Son is member of the SAP HANA Product Management Team, focusing on SQL and SQLScript, and session, transaction, metadata, and hybrid scenarios extending on-prem workloads to SAP HANA Cloud.

Follow Tae-Suk 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

Minjeong Lee

Minjeong Lee 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 SQL/SQLScript, as well as contributing to the topic of SQL/SQLScript supportability.

Follow Minjeong on LinkedIn