Training SQLScript for SAP BW Consultants

The course “SQLScript for BW Consultants” is the most frequently booked training. Whether on-site in your company,as an open training here in Mannheim oras an online event.

As an SAP BW consultant, 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 and use SAP HANA exits for your query variables.

Most problems in BW transformations can be solved much more elegantly and performantly with declarative SQLScript code than with ABAP. The aim of the training is to rethink the participants and to learn how to solve the problems with SQL tools. That’s why I only come up with the concepts of imperative programming in my training SQLScript for advanced users. My experience is that developers tend to replicate the existing ABAP logic 1:1 with imperative coding. This is neither beautiful nor fast. In doing so, one sides the chance to solve the problems much more elegantly with declarative code.

Experienced SAP BW consultants

  • Experience in ABAP programming with OpenSQL
  • Knowledge of SAP BW transformation routines in ABAP
  • SQLScript experience is not required. The course covers the contents of the course SQLScript Basics

About SQLScript:

  • What is the SQLScript programming language?
  • 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
  • Table variables
  • 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 Modelling Tools

Individual company training courses are the first choice for teams of 4 or more participants. Tailored to your tasks, your system stands and hopefully soon again in your rooms. At the moment, of course, the company training courses take place online. In addition to the described standard scope, the training can of course be customized for you. Additional topics can be added and specific problems from your system can be discussed.

Tailored content

You can set the priorities. Depending on the qualifications and experience already available in your team. And also depending on what is important for your current projects. With in-house training, you can set the direction. Or you can rely on our experiences from other customers.

However, the content planing should not be done ad hoc during the event. It is best to discuss the topics 2-3 weeks in advance by phone or via WebEx. Then I can prepare well and offer you an optimal event.

Your rooms

(At the moment unfortunately only very limited possible)

In-house training can take place in the familiar environment of your employees. This has several advantages. On the one hand, you save your employees the trip. This, of course, eliminates the travel costs and the associated organisational effort. On the other hand, this also offers a high degree of flexibility for the participants. For example, if a heterogeneous group is to be trained, participants can join depending on the level of knowledge and topic.

Your systems

HANA System

Every system is different. When in-house training takes place on your systems, you can count on learning the right version of the development environment, application server, and HANA database. It also allows to take a look at problems from your practice on your systems during the event.

Open training courses are ideal for self-employed people or individual participants from companies. They are held every two months. The programme is fixed, but additional modules will be offered during the training week, which can be booked additionally. The weekly programme and further details can be found on the Open Training page.

Dates

Planned events in the near future:

  • 07. bis 10. June 2021 – SQLScript für BW-Berater (4/6)
  • 02. bis 05. August 2021 – SQLScript für BW-Berater (0/10)
  • Schedule of the open training

    TagLektion
    Uhrzeit
    Montag

    SQLScript Grundlagen 1
    8:30 - 12:30 Uhr
    DienstagSQLScript Grundlagen 2
    8:30 - 12:30 Uhr
    MittwochSQLScript Grundlagen 3
    8:30 - 12:30 Uhr
    MittwochEclipse für ABAP und AMDP Einstieg
    13:00 - 14:30Uhr
    DonnerstagBW Transformationsroutinen
    13:00 - 17:00Uhr

    Our e-learning courses are fully-fledged training courses. All lessons are offered as recorded videos , supplemented by exercises and listings .

    For more information, please visit our website at https://brandeis-training.de.

    There is a weekly live office hour and all participants can ask questions via e-mail. At the end of the e-learning course there is a final test where you can obtain a certificate of attendance.

    Badge for all participants of the training SQLScript for BW consultants

    This post is also available in: Deutsch