We use cookies to give you the best possible service. For more information, see our privacy policy.

Privacy policy Accept and continue ×

We use cookies to give you the best possible service. For more information, see our privacy policy.

Privacy policy Accept and continue ×
Contact
Contact the EPG | ACADEMY.

Contact us.

By submitting your data, you consent to the details you have provided on this form being processed. Your data is processed to respond to your query. I accept the Privacy Policy.

Data flow/SQL advanced

In this additional course you will receive valuable information on writing complex SQL statements. Particular attention is paid to ensuring that the results are output in a user-friendly and easy-to-read manner. All new SQL terms are introduced step by step and explained with examples.

Training details

Target group:

Controllers or participants who deal with evaluations, key figures and numbers for KPI.

 

Course objectives:

You know the data flow from goods receipt to goods issue in the LFS. You know which files are filled at which point of the process, know important fields and are able to execute complex SQL queries in the warehouse.

 

Previous knowledge:

Data flow/SQL 

 

Length of course:

2 days

 

1. Day Data flow/SQL advanced

  • Basics LFS data flow: Which data from which table is really relevant?
  • Selecting the right data: Unique fields, sequential numbers and non-unique fields in the LFS Status fields, processing indicators and record types: What does which field content mean?
  • Combining the right tables: Which fields interlock and how do they fit together?
  • Combining LFS tables via JOIN commands
  • Naming columns and tables clearly with Column and Table Aliases
  • Compare field values correctly
  • Conditional queries using CASE functions
  • Convert file types using CAST
  • Integrate search functions in queries