Join this free online course to learn about the SQLScript optimizer and how it helps to run SQLScript in SAP HANA more efficiently.
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.
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
Basic knowledge of SAP HANA SQLScript
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.
A First Step Towards SAP HANA Query Optimization
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
Find out more in the certificate guidelines.
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 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 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 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