Online Training SQLScript for BW-Consultants

8:00 - 13:00

Online

0/10

1.012,00€
zzgl. 19% MwSt - 1.350,00€
zzgl. 19% MwSt

Description

The two-day training course “SQLScript for BW Consultants” is the most frequently booked training course of Brandeis Consulting! As an SAP BW consultant, you can use the full potential of the SAP HANA database in your BW/4HANA or BW on HANA system. Learn to write effective SQLScript code in the AMDP routines of the transformations.

Most problems in BW transformations can be solved much more elegantly and with better performance with declarative SQLScript code than with ABAP. The aim of the course is to make participants rethink their approach and learn how to solve problems using SQL tools.

My experience is that developers tend to copy the existing ABAP logic 1:1 with imperative coding. This is neither nice nor fast. In doing so, one misses the chance to solve the problems much more elegantly with declarative code.

Target Group

This training is intended for SAP BW consultants and developers who want to work on a BW on HANA or BW/4HANA system landscape. No experience with SQLScript is required, but basic knowledge of programming is essential, ideally in ABAP or SQL.

My book “SQLScript for SAP HANA” is used as training material. For this reason, each participant receives a personal copy of my book as at his or her first training session.

Content

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

  • Syntactical basics
  • expressions
  • Simple SELECT statements
  • Procedures and functions
  • processing of date/time/character strings/amounts/quantities

Declarative programming

  • local variables
  • Creating procedures and functions
  • system variables

AMDP and SAP BW Transformations

  • Declarative programming
  • AMDP Framework
  • AMDP routines in transformations
  • Best Practices AMDP routines
  • modularization in AMDP transformations

Variables of type HANA Exit with SQLScript (optional)

  • Create the enhancement implementation

Tools

  • SQL console
  • Web-Based Development Workbench
  • SQLScript Debugger
  • AMDP debugger
  • SAP HANA Studio with ABAP Development Tools and BW Modeling Tool

Buchungen

Ticket-TypPreisPlätze
Standard ticket
The value added tax (MwSt.) of 19% is only collected within Germany. For other countries this must be clarified in advance.
1.350,00€
zzgl. 19% MwSt
Early bird ticket, 15% discount
Available until 6 weeks before the event. The value added tax (MwSt.) of 19% is only collected within Germany. For other countries this must be clarified in advance.
1.147,00€
zzgl. 19% MwSt
n. a.
Team ticket, 25% discount
From three participants from the same company on one 1 invoice. The value added tax (MwSt.) of 19% is only collected within Germany. For other countries this must be clarified in advance.
1.012,00€
zzgl. 19% MwSt


Info

  • This online training will be split into 3 morings
  • For the HANA part of the training, we will provide a central training system. For the exercises in BW you should bring your own system. Please contact me in advance, if this is not possible.

Fordern Sie weitere Informationen an

Wollen Sie mehr Informationen?

Unverbindliche Anfrage