Sign Up Complete your profile

Name *

Email *

Create Password *

Mobile *

Experience in ABAP? * I am Fresher/Want to start career in ABAP I am Functional - Looking to enhance ABAP Debugging skill 1-5Years 5-10Years 10-20Years 20+Years

Which Course you are looking for? *

Have a referral code?

By signing up, I agree to the Terms of Use and Privacy Policy.

Unable to Login? We are here - pankajkumaram@gmail.com

SQL SCRIPT, AMDP, CDS MASTERY - 2023

Language: ENGLISH

Instructors: Pankaj Kumar

₹12999 23.08% OFF

₹9999

PREVIEW

Why this course?

Description

This course helps you to master the optimization of Advanced Business Application Programming applications that gives access to data stored in the In-memory Database.

It covers the SQL Script concept from Basic to Advance which will help you to write the complex business logic efficiently with the help of AMDP. With this training your AMDP concept will be Crystal clear and you will come to know where, when and How to use.

With AMDP you can use SQLScript procedures and CDS table functions from ABAP programs which Accelerate your customer developments in S/4HANA and have great client experience.

You will also learn about CDS - Core Data Services which is core of all future ABAP Enhancement like FIORI Elements, Restful ABAP Programming Model and Cloud Application Programming Model.

In current scenario - This is must learn subject to sustain in SAP technical Domain. Else, You will be outdated.

We'll be also discussing about BOPF integration with CDS and will be creating Transactional App for same.

This will help you to make happy your client - because your client can access it from Mobile and Table etc.. It's Super cool. It's development is also very fast.. Don't have write much code, Just you have to use the framework and a little or no code based on requirement.

This investment in yourself to groom to be updated in technology is worth.

This training will also help you switch your job change because we'll be covering the important Q & A during Class also we'll be covering Test Scenario ( using simple examples ) to make concept clear by writing the code.

You can Check out the Rough Class wise Break-up in below section.

Who Training Is For

Fresher ABAPER or Experienced ABPER |Techno-Functionals who wants to upgrade with CDS and AMDP for better career growth and visibility
Technical Architect to decide which approach to follow for better performance
Manager/Project Manager to Understand and decide if the current project development should follow the CDS, AMDP approach or not

Points to be Covered

Class 1:

SQL Script
Important Data types: SQL Script
Containers
Anonymous Functions - Examples

Class 2:

IF ELSE
While Loop
While Loop with BETWEEN
Temporary table in SQL SCRIPT

Class 3:

DB Cursor
Parameterized DB cursor
SQL Exception
Exception handling Example
Handle the Exception for specific error code

Class 4:

Example to Handle Multiple Exceptions
TRIM_ARRAY and Cardinality
Why DB Cursor?
DB System Variables

Class 5:

How to Debug a Procedure
Creating Table
User Defined Functions
Table UDF
SQL Script for a ABAP Developer - From Internal Table Perspective
Example How to Declare an Internal Table

Class 6:

Search Internal Table and get the index
Number of count in the internal Table
Existence Check
record_count and INSERT
IS_EMPTY( )
UPSERT

Class 7:

Date Functions
Different Functions
SET and UNSET
DEFAULT NULL
EXCEPT OPERATOR

Class 8:

Why AMDP?
What is AMDP?
Why AMDP is prefferred over Directly creating Stored Procedure for an ABAPer
FOR LOOP
Procedure(Stored Procedure)

Class 9:

Declarative Statement & Imperative Statement
Using Data Element in AMDP Procedure function
Calling a procedure from another procedure
AMDP Function

Class 10:

OIA using SQL Script - A Real time example with SAP test data
DB procedure Proxy(Overview)
CDS - What,Why,How

Class 11:

CDS Common Questions and Answer
SQL View and CDS View
Annotations

Class 12:

Aggregate Functions
CDS with Parameter

Class 13:

CDS Table Functions
Associations

Class 14:

Path Expression
Adhoc Associations and Exposed Associations
Inner Join in Association using INNER

Class 15:

Case and When in CDS
ODATA using CDS

Class 16:

CDS Table Functions
Virtual Data Model
Basic Composite and Consumption

Class 17:

CDS Table Functions
Develop a Transactional App using CDS and BOPF.

Class 19:

CDS Performance

Class 20:

Fiori Elements - List Report
Fiori Elements - Master Detail Report

Course Curriculum

How to Use

After successful purchase, this item would be added to your courses.You can access your courses in the following ways :

From the computer, you can access your courses after successful login
For other devices, you can access your library using this web app through browser of your device.

Reviews

SAPTECH MADE EASY

Declaration: SAPTECH MADE EASY is not an authorized SAP Partner. Any course, training or any other service provided at SAPTECH MADE EASY or by Pankaj Kumar are not associated, affiliated, authorized, endorsed by, or in any way officially connected with SAP organization. SAP is a registered trademark of SAP AG in Germany and many other countries. SAPTECH MADE EASY and Pankaj Kumar both are NOT associated with the SAP organization. We do not conduct any SAP Certification training programs