SQLScript Grundlagen

8:30 - 12:00

Online

0/10

0,00€
zzgl. 16% MwSt.

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

Bookings

Buchungen sind für diese Veranstaltung nicht mehr möglich.

Info

  • Diese Schulung ist die 1. Hälfte des Kurses SQLScript für BW-Berater, der gleichzeitig startet.
    TagLektion
    Uhrzeit
    Montag

    SQLScript Grundlagen 1
    8:30 – 12:00 Uhr
    DienstagSQLScript Grundlagen 2
    8:30 – 12:00 Uhr
    MittwochSQLScript Grundlagen 3
    8:30 – 12:00 Uhr

  • Wir stellen ein Schulungssystem bereit. Oder Sie legen sich ein kostenloses HANA 1.0 System in der SAP Cloud Platform an. Infos hierfür erhalten Sie rechtzeitig vor der Schulung.

Request more information