Ich habe erfolgreich den Kurs bei der E-Learning-Plattform Udemy “Learn Open SQL in New SAP ABAP 7.4x and 7.5x” bestanden.
Abschnitt 1:Introduction of the Course
1. Introduction to Open SQL in New ABAP® on HANA® Course
2. Introduction to the Course
3. Codes and Snippets Examples
Abschnitt 2: Open SQL in ABAP – Open SQL vs Native SQL in ABAP and Basisc
Select Satements
4. Open SQL Basic – Open SQL Architecture Overview and Open SQL vs Native SQL
5. Open SQL Basic – Setting up Sample Tables for Hands-on
6. Open SQL Basic – Usage with Inline Table, UP TO and Extracting Selective Columns
7. Open SQL Basic – Use of Select-Endselect and Append to Internal Table
Abschnitt 3: Open SQL Basic – Insert, Update, Modify and Delete in Open SQL
8. Open SQL in ABAP® – Insert in Open SQL with Inline and Internal Table Syntax
9. Open SQL in ABAP® – Update in Open SQL Using Line, Table and Inline Syntax
10. Open SQL in ABAP® – Update Using SET Keyword and Making it Dynamic
11. Open SQL in ABAP® – Use of Modify in Open SQL
12. Open SQL in ABAP® – Delete Using Where and Internal Table in Open SQL
13. Open SQL in ABAP® – Summary of the Section and Future Pointers
Abschnitt 4: Open SQL Intermediate – Use of COREAPONDING FIELS OF TABLE and FOR ALL ENTRIES
14. Open SQL Intermediate – Use of CORRESPONDING FIELDS OF TABLE
15. Open SQL Intermediate – Making Selection Dynamic/Generic
16. Open SQL Intermediate – Use of FOR ALL ENTRIES
Abschnitt 5: Open SQL Intermediate – Use of Aggregation, Group By, Order By and Subqueries
17. Open SQL Intermediate – Use of Wildcards _ and %
18. Open SQL Intermediate – Use of Aggregation Functions
19. Open SQL Intermediate – Use of Group by, Order by with Aggregation Functions
20. Open SQL Intermediate – Use of Subqueries with Select
21. Open SQL Intermediate – Use of Try-Catch with SQL Queries
22. Open SQL Intermediate – Use of Subqueries and Exists
23. Open SQL Intermediate – Use of Insert with Subqueries
Abschnitt 6: Open SQL Advanced – Use of Joins Inner, LEft Outer, Rigth Outer and Cross Joins
24. Open SQL Advanced – Explanations of Types of Joins with Examples
25. Open SQL Advanced – Use of Inner Joins
26. Open SQL Advanced – Use of Left Outer Joins with Right Outer Joins
27. Open SQL Advanced – Use of Cross Joins
28. Open SQL Advanced – Union with Select
