Brandeis Consulting
E-Learning Course SQLScript Basics
E-Learning Course SQLScript Basics

E-Learning Course SQLScript Basics

Published at July 19, 2023by Jörg Brandeis

SQLScriptNewsE-Learning

The following texts were partially or completely generated with the help of generative AI models.

**If you are interested in this e-learning course, please send me a message via our contact form. **

Our video course is designed as a full-fledged training. In terms of content, it corresponds to our proven on-site company training SQLScript, or the first part of the course SQLScript for BW Consultants.

Learn the basics of the SQLScript language, the SQL dialect for the SAP HANA database, and the associated tools for programming.

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 so, you will get to know the necessary tools such as the Eclipse HANA Tools with the SQL console.

You receive 12 months of access to the course with all videos and exercises. During this period, you can also schedule a consultation for questions and request support on specific topics at any time via the support portal.

This course is a prerequisite for our e-learning course AMDP Transformation Routines.

  • Cost: €450 plus VAT
  • Duration: 8 hours of videos

Target Audience

This basic course is intended for all developers and consultants who build applications on an SAP HANA database. These include, among others

  • SAP BW consultants
  • ABAP developers
  • Developers of native SAP HANA applications

Time Required

Depending on prior knowledge, approx. 12 -- 20 hours, of which 8 hours are video material

Prerequisites

Basic knowledge of SQL (SELECT statement)

Training System

You need access to an SAP HANA system. The course describes how you can create your own free SAP HANA system in the SAP BTP. You can also take a look in advance at this SAP tutorial: https://developers.sap.com/tutorials/hana-cloud-deploying.html

Contents

About SQLScript

  • What is the SQLScript programming language?
  • Why is SAP HANA so fast, and what does that 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

Useful links

More articles

New!
Dealing with Level D Code in S/4HANA
July 28, 2026

Jörg Brandeis

Dealing with Level D Code in S/4HANA

SAP's Clean Core Level concept has now been around for about a year. It replaces the old 3-tier model and no longer rates existing Z-code in binary terms as "clean" or "not clean," but on four levels from A to D. At the very bottom is Level D: things SAP actively advises against — using "noAPI" obje

Read more
New!
Authorizations in CDS and RAP — An Overview
July 26, 2026

Marcel Hermanns

Authorizations in CDS and RAP — An Overview

Authorizations in CDS and RAP — An Overview

In customer projects, we keep noticing that authorizations are often a rather unpopular topic. Not infrequently, the authorization concept is reduced to assigning the authorization object S_START (OData V4) or S_SERVICE (OData V2) to the user role –

Read more
DSAG Recommendation on Upskilling SAP Developers
July 21, 2026
Read more