SAP HANA® 2.0 SPS07 SQLScript for SAP HANA

Overview

Course announcements To maximize the performance of data models and applications running on SAP HANA, it is essential that all data related tasks are effectively and according to best practices programmed at the database level. The language used is SQL…

Find smart ways in SAP HANA to push down data intensive tasks to SAP HANA with SQLScript and guarantee performance over time
Understand how to code using advanced SQLScript techniques with guided best practices

Follow recommended best practices in data models for writing in- memory optimized SQL code
Gain solid knowledge on how to fix performance issues on behalf of SAP HANA’s traces and solve those issues in an enduring way

Getting Started Fast and effective walk through HDBSQL and SQLScript and its special functionalities
Understanding SAP HANA extended application services and HDI to support SAP HANA development in SQL
Learn to work with Web IDE for SAP HANA
Quickly finding the right way to SQL solutions
SQL Essentials
SQL Logic Containers Creating user-defined functions
Creating database procedures
Trapping errors in SQLScript
User defined libraries, functions and stored procedures

Declarative Logic Using declarative logic
Imperative Logic Using imperative logic if needed
How to implement transactional save points
Working with temporal tables
OLAP operations Using OLAP analytic features
Working with hierarchies
Troubleshooting and best practices Tools for troubleshooting and creating professional performance tuning
Best practices and how to reduce code volume while leveraging smart SAP HANA functionalities
Appendix: Starting from the beginning with SQL fundamentals