Open SQL in ABAP® with 7.4x and 7.5x
Learn and Understand SQL in ABAP® with New 7.4x and 7.5x ABAP® Version on HANA®
- 41 Videos
- Earn Completion Certification
- Lifetime Access
- Money-Back Guarantee
Instructor
Ajay Nayak
Lead Instructor and CTO at UI5CN
Ajay Nayak is the Lead Instructor and CTO of UI5CN and has about 15 years of experience with Enterprise Technologies and Innovation. Previously he has worked with some of the reputed names like SAP®, Capgemini®, Skybuffer and Statoil® as a developer, consultant, architect and subject matter expert respectively. An Interesting fact about Ajay is, that he started development at a very early age of 15 and according to him, learning should be interactive and engaging. And keeping an element of fun in it can make even difficult concepts simple to understand.
For Latest and Best Offer Check Offer Page
Course curriculum
-
Open SQL in ABAP® - Open SQL vs Native SQL in ABAP® and Basic Select Statements
-
Introduction to the Course
FREE PREVIEW -
Open SQL Basic - Open SQL Architecture Overview and Open SQL vs Native SQL
FREE PREVIEW -
Open SQL Basic - Setting up Sample Tables for Hands-on
FREE PREVIEW -
Open SQL Basic - Simple Select Usage with Inline Table, Use of UP TO, and Extracting Selective Columns
FREE PREVIEW -
Open SQL Basic - Usage of Select-Endselect and Appending Data to Internal Table with Select
FREE PREVIEW -
Ask Your Questions
Duration: 42 min -
-
Open SQL Basic - Insert, Update, Modify and Delete in Open SQL
-
Open SQL in ABAP® - Insert in Open SQL with Inline and Internal Table Syntax
FREE PREVIEW -
Open SQL in ABAP® - Update in Open SQL Using Line, Table and Inline Syntax
FREE PREVIEW -
Open SQL in ABAP® - Update Using SET Keyword and Making it Dynamic
FREE PREVIEW -
Open SQL in ABAP® - Use of Modify in Open SQL
FREE PREVIEW -
Open SQL in ABAP® - Delete Using Where and Internal Table in Open SQL
FREE PREVIEW -
Open SQL in ABAP® - Summary of the Section and Future Pointers
FREE PREVIEW -
Ask Your Questions
Duration: 52 min -
-
Open SQL Intermediate - Use of CORRESPONDING FIELDS OF TABLE, Dynamic Select and FOR ALL ENTRIES
-
Open SQL Intermediate - Use of CORRESPONDING FIELDS OF TABLE
-
Open SQL Intermediate - Making Selection Dynamic/Generic
-
Open SQL Intermediate - Use of FOR ALL ENTRIES
-
Ask Your Questions
Duration: 26 min -
-
Open SQL Intermediate - Use of Wildcards, Aggregation Function, Group By, Order By and Subqueries
-
Open SQL Intermediate - Use of Wildcards _ and %
-
Open SQL Intermediate - Use of Aggregation Functions
-
Open SQL Intermediate - Use of Group by, Order by with Aggregation Functions
-
Open SQL Intermediate - Use of Subqueries with Select
-
Open SQL Intermediate - Use of Try-Catch with SQL Queries
-
Open SQL Intermediate - Use of Subqueries and Exists
-
Open SQL Intermediate - Use of Insert with Subqueries
-
Ask Your Questions
Duration: 51 min -
-
Open SQL Advanced - Use of Joins Inner, Left Outer, Right Outer and Cross Joins
-
Open SQL Advanced - Explanations of Types of Joins with Examples
-
Open SQL Advanced - Use of Inner Joins
-
Open SQL Advanced - Use of Left Outer Joins with Right Outer Joins
-
Open SQL Advanced - Use of Cross Joins
-
Open SQL Advanced - Union with Select
-
Ask Your Questions
Duration: 38 min -
-
Open SQL Advanced - String Expressions, Arithmetic Expressions, CASE and Coalesce
-
Open SQL Advanced - SQL Expressions and Usage Theory
-
Open SQL Advanced - Use of Arithmetic SQL Expressions - Part 1
-
Open SQL Advanced - Use of Arithmetic SQL Expressions - Part 2
-
Open SQL Advanced - Use of String SQL Expressions
-
Open SQL Advanced - Use of CASE and Coalesce
-
Ask Your Questions
Duration: 37 min -
-
Open SQL Advanced - Path Expression, Performance in Open SQL Queries and Best Practices
-
Open SQL Advanced - Path Expression in ABAP® Open SQL
-
Open SQL Advanced - SQL Execution Time and Trace
-
Open SQL Advanced - Performance in ABAP® Open SQL
-
Ask Your Questions
Duration: 22 min -
Reviews
Course Contents
Shambhu Nath Bhattacharya
Course Contents are really good and helpful
Course Contents are really good and helpful
Read Less