|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/learn-open-sql-in-new-sap-abap-on-hana/
课程评论：没有评论
课程名称：在新SAPⓇ S/4 HANA中学习开放SQL与ABAP 课程概述：本课程专注于开放SQL的最新语法和功能，探讨自ABAP®语言7.4x和7.5x版本以来的增强功能。学员将了解开放SQL的执行架构，并掌握开放SQL与原生SQL在SAP®环境中的区别。课程内容包括基础用法与实际示例，如SELECT、INSERT、UPDATE、MODIFY和DELETE语句的基本使用。 学员将学习如何优化数据检索，理解SELECT-ENDSELECT循环、数据包大小优化及在SAP®应用中的最佳实践。此外，还将探讨数据操作技术，熟练运用ABAP®中的INTO与APPEND子句，处理条件与异常，包括基本的WHERE子句、UP TO n ROWS、SINGLE SELECT等。 课程还将教授学员构建复杂查询的方法，使用AND、OR及括号控制来组合简单和复杂的WHERE条件。学员会了解如何利用SELECT语句进行时间戳比较，实施BETWEEN、IN运算符及范围表的用法，掌握自定义数据结构和映射的技巧，并使用通配符。 我们将学习动态选择和表操作，包括使用CORRESPONDING FIELDS OF TABLE和FOR ALL ENTRIES的实现方法。课程还涵盖聚合函数的应用，例如COUNT、DISTINCT、MAX、MIN、SUM和AVG，以及如何使用GROUP BY和ORDER BY子句来整理数据。 此外，学员会掌握使用子查询的SELECT及INSERT语句，理解并应用连接（INNER、LEFT、RIGHT和CROSS JOIN），并学习相关的理论知识和实践示例。课程最后将探讨SQL表达式和函数，包括算术SQL表达式、字符串SQL表达式、CASE语句以及COALESCE函数，使用核心数据服务（CDS）视图及路径表达式进行选择。 欢迎参加本课程，提升您在SAP® ABAP®环境中使用开放SQL的技能！
Explore New Open SQL Syntaxes and Features: Delve into the enhancements available since versions 7.4x and 7.5x of the ABAP® language.Understand Open SQL Execution Architecture: Begin with the theoretical foundation of Open SQL within SAP®, and grasp the differences between Open SQL and Native SQL in the SAP® environment.Basic Usage with Practical Examples: Learn the fundamental usage of SELECT, INSERT, UPDATE, MODIFY, and DELETE statements in ABAP® with hands-on examples.Optimize Data Retrieval: Understand the use of SELECT-ENDSELECT loops, packet size optimizations, and best practices for various scenarios in SAP® applications.Master Data Manipulation Techniques: Gain proficiency in using INTO and APPEND clauses within SELECT statements in ABAP®.Handle Conditions and Exceptions: Utilize basic WHERE clauses, UP TO n ROWS, SINGLE SELECT, and manage SY-DBCNT, SY-SUBRC, and exceptions in SAP® ABAP®.Construct Complex Queries: Build simple and complex WHERE conditions using AND, OR, and parenthesis control in ABAP® Open SQL.Timestamp Comparisons: Discover how to use SELECT statements for timestamp comparisons in SAP® systems.Advanced Operators and Range Tables: Implement BETWEEN, IN operators, and RANGE tables in ABAP® Open SQL.Custom Data Structures and Mapping: Retrieve data into custom structures, map columns, and employ wildcards in SAP® ABAP®.Dynamic Selections and Table Operations: Use CORRESPONDING FIELDS OF TABLE, make selections dynamic or generic, and implement FOR ALL ENTRIES in SAP® Open SQL.Aggregation Functions: Apply functions like COUNT, DISTINCT, MAX, MIN, SUM, and AVG in ABAP® Open SQL.Grouping and Ordering Data: Utilize GROUP BY and ORDER BY clauses in SAP® ABAP® Open SQL for organized data retrieval.Subqueries in SQL Statements: Learn to use SELECT with subqueries and INSERT with subqueries in ABAP®.Implementing Joins: Understand and apply joins in SAP® ABAP®, including INNER, LEFT, RIGHT, and CROSS JOIN, supported by theoretical explanations and practical examples.SQL Expressions and Functions: Explore arithmetic SQL expressions, string SQL expressions, CASE statements, and the COALESCE function in ABAP® Open SQL.CDS Views and Path Expressions: Perform selections using Core Data Services (CDS) views and path expressions in the SAP® ABAP® environment.Selection using CDS views and Path Expression
