Free trial lesson on string processing
This video course is designed as a full-length training. The content corresponds to my proven company training SQLScript or the first part of the course SQLScript for BW consultants.
Learn the basics of SQLScript, the SQL dialect for the SAP HANA database, and its programming tools.
This 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 will learn the necessary tools such as the Web-Based Development Workbench and the SQL console.
You get 3 months access to the course with all videos and exercises. During this time, you can also schedule a consultation for questions and request assistance on specifics at any time via the Support Portal.
The course is divided into 4 weekly sections, each with approximately 4 hours of study. However, all content is available immediately after booking.
Upon completion of all lessons and passing the final test, you will receive a certificate confirming successful completion.
This course is a prerequisite for the courses:
- SQLScript for BW Consultants
- SQLScript for ABAP Developers
- SQLScript for Advanced
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
Time expenditure
Depending on previous knowledge, approx. 12 – 20 hours, including 8 hours of video material
Requirements
Basic knowledge of a programming language, e.g. ABAP
Training system
The course describes how to create your own free SAP HANA system in SAP Cloud Platform.
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
- Table variables
Tools
- SQL console
