Beim Laden des Videoplayers ist ein Fehler aufgetreten, oder es dauert lange, bis er initialisiert wird. Sie können versuchen, Ihren Browser-Cache zu leeren. Bitte versuchen Sie es später noch einmal und wenden Sie sich an den Helpdesk, wenn das Problem weiterhin besteht.
To enable the transcript, please select a language in the video player settings menu.
Join this free online course to learn about the SQLScript optimizer and how it helps to run SQLScript in SAP HANA more efficiently.
Kurssprache: English
Kursinformationen
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
- 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
Lernmaterial
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!
Diesen Kurs reaktivieren
Diesen Kurs können Sie reaktivieren und so die Möglichkeit erhalten, sich noch für einen Leistungsnachweis zu qualifizieren. Weitere Informationen finden Sie hier — oder
Für diesen Kurs einschreiben
Lernende
Bewertungen
Der Kurs wurde mit durchschnittlich 4.25 Sternen bei 411 abgegebenen Stimmen bewertet.
Anforderungen für Leistungsnachweise
- Den Leistungsnachweis erhält, wer in der Summe aller benoteten Aufgaben mindestens 50% der Höchstpunktzahl erreicht hat.
- Die Teilnahmebestätigung erhält, wer auf mindestens 50% der Kursunterlagen zugegriffen hat.
Mehr Informationen finden Sie in den Richtlinien für Leistungsnachweise.
Dieser Kurs wird angeboten von
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