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