SQLScript for BW-Consultants

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 programming language SQLScript?
  • Why is SAP HANA so fast and what does this 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
  • Local variables

Tools

  • SQL console

quote for training "SQLScript for BW-Consultants" request