ABAP · ABAP Cloud

SAP ABAP Cloud SQL

ABAP SQL is how modern code talks to the database: reading, writing and combining data with performance and safety. This course covers persistence operations in ABAP Cloud (inserting, updating, modifying and deleting records, transaction control, reads, filters, expressions, dynamic SQL and multi-source queries) from start to finish.

Fundamentals 80 h of training Instructor: Gheorghe Valer 58 videos ABAP Cloud: Advanced Programming Prepares for the C_ABAPD certification

Access with your subscription Go to My learning

What you will learn

By the end, you will be able to do this

Insert, update, modify and delete records with ABAP SQL
Control transactions by committing and rolling back changes
Read data from the database efficiently
Build conditions and filters in queries
Apply SQL expressions to transform results
Write dynamic ABAP SQL statements and queries over multiple sources

Syllabus

12 sections · 58 videos

10 labs · 11 tests · assignments with solutions

01 Introduction 2 lessons

Training contents
What is ABAP SQL?

02 Inserting records into databases lab test 4 lessons

Inserting a record
Inserting multiple records
Inserting records with exception handling
Inserting records without exception handling

+ Documentation · Lab · Test

03 Updating database records lab test 4 lessons

Updating a record
Updating multiple records
Updating columns
Updating columns with expressions

+ Documentation · Lab · Test

04 Modifying database records lab test 2 lessons

Modifying a record
Modifying multiple records

+ Documentation · Lab · Test

05 Deleting records from the database lab test 3 lessons

Deleting a record
Deleting multiple records
Deleting records using filters

+ Documentation · Lab · Test

06 Committing and rolling back database changes lab test 2 lessons

Rollback Work
Commit Work

+ Documentation · Lab · Test

07 Database reads lab test 8 lessons

Select Single
Select Bypassing Buffer
Select Into / Appending Table
Select Into Corresponding Fields
Select Columns
Select Up To n Rows
Select / Endselect
Select Package Size

+ Documentation · Lab · Test

08 Filter conditions lab test 8 lessons

Binary relational operators
BETWEEN
Wildcard characters with LIKE
Escape characters
IN
IN with a ranges table
NULL
AND/OR/NOT

+ Documentation · Lab · Test

09 SQL expressions lab test 8 lessons

MIN / MAX
AVG / SUM
DISTINCT
COUNT
GROUP BY
HAVING
ORDER BY
OFFSET

+ Documentation · Lab · Test

10 Dynamic ABAP SQL statements lab test 4 lessons

Dynamic source specification
Dynamic column specification
Dynamic filter specification
Dynamic programming for ABAP SQL

+ Documentation · Lab · Test

11 Queries over multiple sources lab test 13 lessons

AS - Alias
Subquery
Subquery ALL
Subquery ANY/SOME
Subquery EXISTS
Subquery IN
JOIN types
INNER JOIN
LEFT [OUTER] JOIN
RIGHT [OUTER] JOIN
LEFT | RIGHT EXCLUDING INNER JOIN
CROSS JOIN
FULL [OUTER] JOIN

+ Documentation · Lab · Test

12 Final test and course certificate 2 lessons

Final test
Getting the course certificate

Who it is for

Is this course for you?

ABAP developers consolidating data access in the cloud
SAP consultants who need to master ABAP SQL
Technicians optimizing database reads and writes

Requirements

What you need to get started

Basic ABAP: syntax and data types
Notions of the data dictionary and the relational model
The first block shows how to set up your own practice environment from scratch

G

Your instructor

Gheorghe Valer

SAP architect with 20 years of experience on real projects. He shares what he has learned along the way, with day-to-day examples.

Certificate of completion

7-day guarantee

Forum support

Updates included

Training used by SAP professionals in banking, industry, retail, and the public sector.

Path · ABAP Cloud: Advanced Programming

Other courses in this certification path

Fundamentals

SAP ABAP Cloud: Data Dictionary

View course

Intermediate

SAP ABAP Cloud: Object-Oriented Programming

View course

Intermediate

SAP ABAP Cloud CDS: Core Data Services

View course

Intermediate

SAP ABAP Cloud ATC and abapGit

View course

Advanced

SAP ABAP Cloud Push Down

View course

See the full master program

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.

See plans and pricing Go to My learning Go to the campus