SQLScript for BW-Consultants
As an SAP BW consultant, learn to exploit the full potential of the SAP HANA database in your BW system. With SQLScript in AMDP routines and in HANA exits.
'Description
Your start in the programming language SQLScript! It forms the basis for all applications on the SAP HANA database and can be used universally in different areas. In ABAP Managed Database Procedures (AMDP) of a BW transformation routine as well as in Table Functions, which are used as sources for HANA Calculation Views.
Learn the basics of the SQLScript language, the SQL dialect for the SAP HANA database, and the associated programming tools.
This one-day course focuses on the declarative aspects of the SQLScript query language. You will learn how to create and test performant queries on the SAP HANA database. For this purpose, you will get to know the necessary tools such as the Web-Based Development Workbench, the SQL console and the SQLScript debugger.
Translated with www.DeepL.com/Translator (free version)
Agenda
About SQLScript
- What is the SQLScript programming language?
- Why is SAP HANA so fast and what does it have to do with SQLScript?
Basics of the programming language
- Syntactic basics
- Expressions
- Simple SELECT statements
- Procedures and functions
- Processing of date/time/strings/amounts/quantities
Declarative programming
- Anonymous blocks
- Table variables
AMDP and SAP BW transformations
- Declarative Programming
- AMDP Framework
- AMDP routines in transformations
- Best Practices AMDP Routines
Tools
- SQL Console
- AMDP Debugger
- SAP HANA Studio with ABAP Development Tools and BW Modeling Tools