Join this free online course to learn about the SQLScript optimizer and how it helps to run SQLScript in SAP HANA more efficiently.
Language: English
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.
Course Characteristics
- Starting from: June 13, 2023, 09:00 UTC. (What does this mean?)
- Duration: 3 weeks (3-4 hours per week)
- Final exam: July 4-12, 2023, 9:00 UTC
- Course language: English
- How is an openSAP course structured?
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 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 OptimizerWeek 2:
SAP HANA SQLScript Supportability FeaturesWeek 3:
Investigating SQLScript Performance Caused by SQLI Like, I Wish:
We Love Your Feedback … And Want MoreFinal Exam:
Good Luck!
Enroll me for this course
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 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