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.
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.
- 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
- Simple SELECT statements
- Procedures and functions
- Processing of date/time/strings/amounts/quantities
- Anonymous blocks
- Local variables
- Creating procedures and functions
- SQL console
Buchungen sind für diese Veranstaltung nicht mehr möglich.