ABAP · On-Premise
SAP ABAP SQL On-Premise
Open SQL and advanced Open SQL are the muscle of any ABAP development that touches data: here you learn to read from and write to the database with precision and performance. The course covers inline declarations, subqueries, hierarchical queries, associations and a complete catalog of SQL functions (numeric, string, date, time and time zone), all on an SAP On-Premise system with guided labs.
What you will learn
By the end, you will be able to do this
- Write queries with inline declarations and host variables
- Specify columns and order the clauses correctly
- Solve subqueries with WITH and CASE expressions
- Model hierarchical queries: depth, multiple parents and orphans
- Navigate data with associations and Path Expressions
- Apply numeric, string, date, time and time zone SQL functions
- Insert and modify records with subqueries and global temporary tables
Syllabus
5 sections · 29 videos
2 labs · 2 tests · assignments with solutions
01 Introduction
- Course contents
02 Development environment
- Environment setup
- Connecting to the SAP system
- On-Premise projects
03 Reading and writing lab test
- Inline declarations
- Column specification
- Host variables
- Clause sequence
- CASE
- UNION ALL / DISTINCT
- Subquery with WITH
- Hierarchy
- Depth
- Multiple parents
- Orphans
- Path Expressions and associations
- CDS with parameters
- Hints
- Insert and update with a subquery
- Global temporary tables
+ Documentation · Lab · Assignment · Solution · Test
04 SQL functions lab test
- Numeric functions
- Concatenation functions
- Character string functions
- Date functions
- Time functions
- Time zone functions
- Date and time conversions
+ Documentation · Lab · Assignment · Solution · Test
05 Final test and course certificate
- Final test
- Course certificate
Who it is for
Is this course for you?
- ABAP developers who want to master data access
- SAP consultants with a technical background
- Programmers coming to SAP from other technologies
Requirements
What you need to get started
- Basic ABAP: syntax, data types and control structures
- Access to an SAP On-Premise system in your own company environment (Logali Tech does not provide SAP systems)
- Minimal notions of relational databases
Your instructor
SAP architect with 20 years of experience on real projects. He shares what he has learned along the way, with day-to-day examples.
Training used by SAP professionals in banking, industry, retail, and the public sector.
Path · ABAP Programming for HANA
Other courses in this certification path
Frequently asked questions
How do I get access to this course?
With a Logali Tech subscription (courses are not sold individually). The Free plan opens the first three sections of every course; Standard and Premium unlock the full course. See Pricing.
Do I need my own SAP instance?
Logali Tech does not provide access to SAP systems. In most of the training you do not need your own license: hands-on work is done on a free SAP BTP Trial account that you create, and the course walks you through setting it up step by step. For the On-Premise courses (classic ABAP, Web Dynpro, ALV, Adobe Forms and Fiori administration) you can run the free trial system that SAP makes available (ABAP Cloud Developer Trial) on your own infrastructure, or use the SAP system in your own company environment.
Are there live classes?
Recordings are available 24/7. Live classes and live master programs are included in the Premium plan.
Do I get a certificate?
Yes. When you complete the course you earn a certificate of completion that you can add to your LinkedIn profile.
Start this course today
The first three sections are free. With a subscription you get this full course and the entire SAP catalog.