Training SQLScript Basics
The course comprises approx. 12 hours.
Your introduction to the programming language SQLScript! It forms the basis for all applications on the SAP HANA database and can be used universally in different areas. In ABAP Managed Database Procedures (AMDP) of a BW transformation routine as well as in Table Functions that are used as sources for HANA Calculation Views.
Course Description
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.
Target Audience
This training is aimed at experienced ABAP developers who also want to use AMDP procedures and CDS table functions in their programs. Experience with ABAP development in Eclipse is an advantage.
- SAP BW Consultant
- ABAP Developers
- Developers of native SAP HANA applications
Prerequesites
Experience with SQLScript is not required, but basic programming skills should be available, ideally in ABAP or SQL.
Course 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
Tools
- SQL console
Individual company training courses are the first choice for teams of 4 or more participants. Tailored to your tasks, your system stands and hopefully soon again in your rooms. At the moment, of course, the company training courses take place online. In addition to the described standard scope, the training can of course be customized for you. Additional topics can be added and specific problems from your system can be discussed.
Tailored content
You can set the priorities. Depending on the qualifications and experience already available in your team. And also depending on what is important for your current projects. With in-house training, you can set the direction. Or you can rely on our experiences from other customers.
However, the content planing should not be done ad hoc during the event. It is best to discuss the topics 2-3 weeks in advance by phone or via WebEx. Then I can prepare well and offer you an optimal event.
Your rooms
(At the moment unfortunately only very limited possible)
In-house training can take place in the familiar environment of your employees. This has several advantages. On the one hand, you save your employees the trip. This, of course, eliminates the travel costs and the associated organisational effort. On the other hand, this also offers a high degree of flexibility for the participants. For example, if a heterogeneous group is to be trained, participants can join depending on the level of knowledge and topic.
Your systems
Every system is different. When in-house training takes place on your systems, you can count on learning the right version of the development environment, application server, and HANA database. It also allows to take a look at problems from your practice on your systems during the event.
Open training courses are ideal for self-employed people or individual participants from companies. They are held every two months. The programme is fixed, but additional modules will be offered during the training week, which can be booked additionally. The weekly programme and further details can be found on the Open Training page.
Dates
Planned events in the near future:
Schedule of the open training
| Tag | Lektion Uhrzeit |
|---|---|
| Montag | SQLScript Grundlagen 1 8:30 - 12:30 Uhr |
| Dienstag | SQLScript Grundlagen 2 8:30 - 12:30 Uhr |
| Mittwoch | SQLScript Grundlagen 3 8:30 - 12:30 Uhr |
Our e-learning courses are fully-fledged training courses. All lessons are offered as recorded videos , supplemented by exercises and listings .
For more information, please visit our website at https://brandeis-training.de.
There is a weekly live office hour and all participants can ask questions via e-mail. At the end of the e-learning course there is a final test where you can obtain a certificate of attendance.
This post is also available in:
Deutsch