-
Certificates: Certificate "Relational Databases SQL"
Original SAP Consultant Certificate -
Examination: Practical project work with final presentations
SAP Consultant Certification Sales C_TS462_2022 -
Teaching Times: Full-timeMonday to Friday from 8:30 a.m. to 3:35 p.m. (in weeks with public holidays from 8:30 a.m. to 5:10 p.m.)
-
Language of Instruction: German
-
Duration: 20 Weeks
Relational databases with SQL
Basics of database systems with Access (approx. 3 days)
Redundant data
Data integrity
Normalization
BCNF
DB design
Relationship 1:n, m:n
data types
tables
Primary and foreign keys
Referential integrity
Relationships between relations
Entity relationship model
Index, default value
Restrictions (check)
Queries
Forms, reports
Circular reference
Introduction to SQL Server Management Studio (SSMS) (approx. 2 days)
Overview of
Physical DB design
Creating tables
Data types in MS SQL
Primary Key
Restrictions, default values, diagram, relationships
Backup and restore
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
Introduction to DDL (approx. 8 days)
SQL basics
syntax
Commands
Multiple tables
Operators
Flow control
Scalar value functions
Table value functions
System functions
Procedures with and without parameters
Error types
Transactions, locks, DeadLock
DCL - Data Control Language (approx. 1 day)
Logins
User learning
roles
Authorizations
Data types, data import and export (approx. 1 day)
Data type geography
Data export, data import
Project work (approx. 5 days)
To consolidate the content learned
Presentation of the project results
SAP Consultant Sales (SD): Application Associate - SAP S/4HANA Sales with additional qualification Materials Management (MM)
S4H00 SAP S/4HANA Overview (approx. 4 days)
Overview of SAP S/4HANA
Navigation, SAP Fiori, SAP Business Client, SAP Logon
System-wide concepts with organizational units, master data and transactions
Overview of financial accounting and logistics modules, mapping of the respective processes in SAP
Reporting, system structure and migration
SAP service offerings
Artificial intelligence (AI) in the work process
Presentation of specific AI technologies
and possible applications in the professional environment
S4500 Business Processes Sourcing and Procurement (approx. 8 days)
Overview and navigation
Processes and corporate structure in procurement
Procurement process
Procurement master data
Stock material compared to consumables
Request via self-service
Extended transactions in procurement
Automated procurement process
Evaluations and analyses
S4600 Business Processes in Sales (approx. 8 days)
Navigation with Fiori
Company structures
Sales processes at a glance
Master data
Automatic data determination and scheduling
Availability check
Collective processing
Further processes in Sales
Complaints processing
Monitoring and sales analyses
S4605 Sales Processes in Sales (approx. 10 days)
Introduction to
Corporate structures in sales
Order processing
Control of sales documents
Data flow
Special business transactions
Incompleteness
Partner functions in sales
Outline agreements
Material substitution, listing and exclusion
Discount in kind
Sales workshop
S4610 Delivery processes (approx. 4 days)
Idea and function of the delivery document
Basic organizational units for the delivery process
Control of the delivery
Goods issue process based on the outbound delivery
Processes and functions based on the outbound delivery
Project work/case study (approx. 6 days)
To consolidate the content learned
Optional and recommended as an intermediate test: SAP user certification in sales
S4H02 Fiori overview (approx. 3 days)
Introduction, technology and architecture, setup
S4615 Invoicing in Sales (approx. 4 days)
Billing in sales processes
Organizational units
Billing
Special billing types
Data flow
Creation of billing documents
Billing forms
Special business processes
Account determination
Interface between sales and finance
S4620 Pricing in Sales (approx. 6 days)
Condition technique in pricing
Configuration of pricing
Condition records
Special functions
Condition types
Pricing agreements
Introduction to condition contract management
Pricing workshop
S4650 Overarching topics in sales (approx. 6 days)
Influence of organizational structures
Copy control
Text control
Message control
Enhancements and customizations
SAP Learning Journey - Applying SAP S/4HANA Sales (approx. 1 day)
SAP Learning Journey - Managing Clean Core for SAP S/4HANA Cloud (approx. 1 day)
Project work/case study, certification preparation and SAP Consultant certification Sales (approx. 19 days)
Changes are possible. The course content is updated regularly.
After the course, you will be able to build and manage relational databases with SQL, create views and execute complex queries, including using SQL functions. The course is taught on the Microsoft SQL Server using the Microsoft SQL Server Management Studio.
You will also have the necessary qualifications to provide your clients with comprehensive and competent support as an SAP Sales Consultant. The course will enable you to analyze company-specific processes in the area of sales and adapt the software to the specific needs of the company. Your professional profile will be enhanced by the SAP Consultant certification.
By creating and developing databases, companies ensure efficient sorting, logical structuring and permanent documentation of important data. As an SQL database specialist or administrator, you will work in almost all industries.
In addition, you will acquire the globally standardized and recognized SAP certificate. It is considered one of the most important manufacturer certifications in the commercial sector. With your newly acquired knowledge and skills, you will improve your career opportunities across all sectors.
Your possible fields of activity lie in business and software consulting, development and user support and training.
Training partner of SAP® Germany
In cooperation with the SAP training partner alfatraining Bildungszentrum GmbH, we will qualify you for a job in industry and business.
You are directly connected to the SAP® Germany servers and learn on the original SAP® training system (IDES) in the latest version. This gives you the necessary practical experience during the course.
All SAP consultant courses also conclude with the original SAP certification. Our SAP instructors are qualified SAP consultants who will provide you with intensive support and prepare you optimally for the certification exam.
Didactic concept
Your lecturers are highly qualified both professionally and didactically and will teach you from the first to the last day (no self-study system).
You will learn in effective small groups. The courses usually consist of 6 to 25 participants. The general lessons are supplemented by numerous practical exercises in all course modules. The practice phase is an important part of the course, as it is during this time that you process what you have just learned and gain confidence and routine in its application. The final section of the course involves a project, a case study or a final exam.
Virtual classroom alfaview®
Lessons take place using modern alfaview® video technology - either from the comfort of your own home or at our premises at Bildungszentrum. The entire course can see each other face-to-face via alfaview®, communicate with each other in lip-sync voice quality and work on joint projects. Of course, you can also see and talk to your connected trainers live at any time and you will be taught by your lecturers in real time for the entire duration of the course. The lessons are not e-learning, but real live face-to-face teaching via video technology.
The courses at alfatraining are funded by Agentur für Arbeit and are certified in accordance with the AZAV approval regulation. When submitting a Bildungsgutscheinor Aktivierungs- und Vermittlungsgutschein, the entire course costs are usually covered by your funding body.
Funding is also possible via Europäischen Sozialfonds (ESF), Deutsche Rentenversicherung (DRV) or regional funding programs. As a regular soldier, you have the option of attending further training courses via Berufsförderungsdienst (BFD). Companies can also have their employees qualified via funding from Agentur für Arbeit (Qualifizierungschancengesetz).