Training SQLScript Basics

The course comprises approx. 12 hours.

Your introduction to 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 that are used as sources for HANA Calculation Views.

Course Description

Learn the basics of SQLScript, the SQL dialect for the SAP HANA database, and its programming tools..

This one-day course focuses on the declarative aspects of the SQLScript query language. You will learn how to create and test high-performance queries on the SAP HANA database. To do this, you’ll learn about the tools you need, such as the Web-Based Development Workbench, the SQL console, and the SQLScript debugger.

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.

  • SAP BW Consultant
  • ABAP Developers
  • Developers of native SAP HANA applications

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

Declarative programming

  • Anonymous blocks
  • Local variables

Tools

  • SQL console
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 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 09. June 2021 – SQLScript Grundlagen (0/10)
  • 02. bis 04. August 2021 – SQLScript Grundlagen (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

    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