ABAP · ABAP Cloud
SAP ABAP Cloud Push Down
The code push-down principle moves data processing to the database instead of the application layer, which is key for performance on SAP HANA. This advanced course covers the techniques to push logic down to the database in ABAP Cloud: advanced queries, hierarchies, path expressions and SQL functions.
What you will learn
By the end, you will be able to do this
- Understand the code push-down principle and its impact on performance
- Build advanced queries that delegate computation to the database
- Model hierarchies and traverse them with path expressions
- Apply SQL functions to transform data in the persistence layer
- Design queries optimized for SAP HANA
- Identify when to move logic from the application to the database
Syllabus
6 sections · 38 videos
3 labs · 4 tests · assignments with solutions
01 Introduction
- Training contents
02 Development environment
- SAP BTP
- ABAP instance in the cloud
- Eclipse - Installation
- ADT - ABAP Development Tools
- Cloud project
03 Advanced queries lab test
- Inline declarations
- Column specification
- Host variables
- Clause sequence
- Case
- Global temporary tables
- Subquery with WITH
- Insert and update with a subquery
- Database Hints
- Union
- Intersect
- Except
+ Documentation · Lab · Test
04 Hierarchies and path expressions lab test
- Hierarchy - Data model
- Hierarchy - CDS
- Hierarchical selection
- Depth
- Multiple parents
- Orphans
- Invalid data
- Hierarchy properties
- Path Expression - Associations
- CDS with parameters
+ Documentation · Lab · Test
05 SQL functions lab test
- Numeric functions
- Concatenation functions
- Character string functions
- Date functions
- Timestamp functions
- Time zone functions
- Conversions - Dates and timestamps
- Conversions - Amounts and quantities
- Extractions - Date properties
- UUID - Universal Unique IDentifier
+ Documentation · Lab · Test
06 Final test and course certificate
- Final test
- Getting the course certificate
Who it is for
Is this course for you?
- ABAP developers optimizing performance in the cloud
- SAP consultants with a technical background fine-tuning data access
- Technicians designing high-performance data models
Requirements
What you need to get started
- Solid ABAP SQL and working knowledge of CDS
- Experience with the data dictionary and the relational model
- Notions of SAP HANA and in-database processing
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 Cloud: Advanced Programming
Other courses in this certification path
Fundamentals
FundamentalsSAP ABAP Cloud: Data Dictionary
View courseFundamentals
FundamentalsSAP ABAP Cloud SQL
View courseIntermediate
IntermediateSAP ABAP Cloud: Object-Oriented Programming
View courseIntermediate
IntermediateSAP ABAP Cloud CDS: Core Data Services
View courseIntermediate
IntermediateSAP ABAP Cloud ATC and abapGit
View courseFrequently 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.