A3 - Data Modeling and Access with ABAP Open SQL

EN | BG

A3 - Data Modeling and Access with ABAP Open SQL

Target audience:

Anyone with some previous knowledge in programming and SAP software who has already mastered the content in A1 - First Steps in ABAP and A2 - Basics of ABAP Programming.

Goals & Expectations:

The goal of this course is to get you ready to work with the database by using ABAP Data Dictionary and a subset of ABAP called ABAP Open SQL.

You will acquire the knowledge to:

define and change tables in the database via the ABAP Data Dictionary;
write programs that create, read, update, or delete records in a database table;
create objects for viewing or maintaining data;
execute database operations in multiple tables;
perform error handling with checks and messages when a database operation fails.

This course is focused on ABAP Open SQL development. After completing it, you will be able to create and change database tables and their data.

In this course:

video lectures;
summarized reference materials;
exercises;
end-of-course project.

By purchasing an individual or a group academy, you get in addition:

access to an SAP training system;
online chat with other participants and a mentor;
personal feedback from a mentor on your exercise solutions;
live sessions with a mentor in a group.

Duration:

4 weeks for lectures and exercises.
2 weeks to prepare your project.

Course program

1 A3 - Working with the Database

Lessons: 19 | Duration: ~02:15 hours | Tasks: 5 | Files & Materials: 19

Working with the Database Overview

1min

Relational Data Model

6min

Reading from the Database

11min

Reading from Multiple Database Tables

4min

Read from the Database Using Aggregation

4min

Exercise: Reading from a Database

Insert Data into the Database

7min

Update Data in the Database

7min

Modify Data in the Database

5min

Delete Data from the Database

6min

OpenSQL Best Practices

6min

Exercise: Writing to the Database

Database Transactions

5min

Creating Database Tables

21min

Creating Database Views

7min

Exercise: Data Dictionary Objects - Transparent Tables and Database Views

Customizing Tables

3min

Maintenance Dialog and Maintenance View

9min

Input Help (F4 help)

18min

Implementation Guide (IMG)

4min

Exercise: Data Dictionary Objects

Customizing Clusters

7min

End of Module Project

Working with the Database Summary

4min

* The course start date may change due to insufficient number of participants or unforeseen events. You’ll have the option to receive a full refund or start at a later date. More details
Language	English
Type
Participants	min. 7 in a group
Start Date *
Deadline For Enrolling
Price	383.47 €
Mentor	Semo Kiskinov
Modules	1
Lessons	19
Length	~02:15 hours
Exercises	5
Files	19

A3 - Data Modeling and Access with ABAP Open SQL

Course program

1 A3 - Working with the Database

Kiril Manov

Semo Kiskinov

Semo Kiskinov

Ventsislav Grigorov