Target group:

HYDRA users who would like to develop their own reports / evaluations by accessing the database.

Course objective:

You become familiar with the data structures and their interrelations in the HYDRA database. This training course represents the basis for individual data selection, which will be explained in more detail during other customization training courses.

Requirements:

• Basic knowledge of the HYDRA application, SQL and database
• Basic knowledge of software development

Contents of the course:

Introduction to the database system

• Theory of relational databases
• Terminology of database systems

SQL query language

• SQL query tools in the HYDRA environment
• Exercises based on predefined tasks
• Optimization of queries

Becoming familiar with the HYDRA database structure

• Structure of the MES system's database tables relevant to applications
• Meaning of the fields in database tables
• Logical relations between individual database tables
• Usage in HYDRA

Exercises

Course:

CUT-HDB

Duration of the course:

1 day