Training SQLScript Basics

Course description

The course consists of approximately 7 hours of time. On the 2nd day of training, it is therefore a little shorter. 

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.

As training material, my book is SQLScript for SAPHANA.  That’s why every participant receives a personal copy at his first training.

Target audience

This basic course is intended for all developers and consultants who build applications on an SAP HANA database. These include, but are not only

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

Content

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
  • Creating procedures and functions
  • Variables

Tools

  • SQL console

Open training

approximately every 2 months. Planned events

Other course formats

  • Individual training online or in-house
  • Video training in preparation

Scope

Minimum 1 day of 7 hours

As video training approx. 4 weeks of 2 hours of video plus 2 hours of exercises. 

Request more information

This post is also available in: Deutsch

Wollen Sie mehr Informationen?

Unverbindliche Anfrage

Do you want more information?

Inquiry