START DATE TO BE CONFIRMED!
During this course trainees get an introduction to the concept and history of relational data structures. The pros and cons are shown and explained with a set of hands on examples.
In a first chapter of the course the basic elements of relational databases are explained: tables, fields, relationships. This first chapter is concluded with a set of hands-on exercises aiming to make database structures fitting specific scientific needs.
A second chapter focuses on data export and data selection techniques. Through the use of queries, trainees learn how to efficiently export data from the database towards different formats (e.g. Statistical inputs).
A third chapter provides training in the setup of visual interfaces. An introduction to forms and reports is provided, also dynamic links to spreadsheets and data visualization tools are explored.
The fourth and final chapter informs on differences in database software, how to link databases to each other, use of databases in multi-user environments.