SQLScript for ABAP Developers

2-day training, as in-house training or open training in Mannheim. Full performance for S/4HANA – Also in customer programs!

Course Description

With the AMDP Framework, HANA Performance also opens up to ABAP developers. You can use the full potential of the SAP HANA database without leaving your traditional development environment. This is particularly suitable where large amounts of data need to be processed and where the runtimes in the existing ABAP programs are insufficient.

As in the other training sessions, the book SQLScript for SAP HANA will be used as a training document for all participants.

This training is aimed at experienced ABAP developers who also want to use AMDP procedures and CDS table functions in their programs.

Experience with ABAP development in Eclipse is an advantage.

Experience with SQLScript is not required, but basic programming skills should be available, ideally in ABAP or SQL.

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
  • Procedures and functions
  • Processing of date/time/strings/amounts/quantities

Declarative programming

  • Table variables
  • Decomposition of queries
  • SELECT statements

AMDP Framework

  • AMDP Framework
  • AMDP Procedures and Functions
  • CDS Table Functions

Imperative programming

  • Flow control with conditions and loops
  • Autonomous transactions
  • Changing database statements

Tools

  • SQL console
  • Web-Based Development Workbench
  • AMDP debugger
  • SAP HANA Studio with ABAP Development Tools
My book “SQLScript for SAP HANA” is used as training material. That’s why every participant receives a personal copy at his first training.

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 Locations

(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.

This post is also available in: Deutsch

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:

Keine Veranstaltungen

Schedule of the open training

TagLektion
Uhrzeit
Montag

SQLScript Grundlagen (1/4)
9:00 - 12:00 Uhr


SQLScript Grundlagen (2/4)
13:00 - 16:00 Uhr
DienstagSQLScript Grundlagen (3/4)
9:00 - 12:00 Uhr


SQLScript Grundlagen (4/4)
13:00 - 16:00 Uhr
MittwochEclipse für ABAP und AMDP Einstieg
8:30 - 12:30 Uhr
DonnerstagAMDP und CDS Table Functions
8:30 - 12:30 Uhr

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.

In addition to a paper certificate of attendance, each course participant also receives an electronic badge that confirms their attendance with a digital certificate.

This post is also available in: Deutsch