The Workshop introduces students to the use of data management, data visualization and data analysis tools. In particular, we will guide the
students using the MySQL language and the STATA statistical software.
The laboratory foresees the active participation of the students and the carrying out of at least four homework. The exercises carried out during the course are integral to the final evaluation.
The study material will be provided in class and available on the course's Moodle page
Learning Objectives
At the end of the workshop, students can use the MySQL language for querying one or more tables and creating complex views and queries.
Students can also manipulate data sets in STATA for generating graphs and tables.
Prerequisites
Workshop I
Teaching Methods
Laboratory activities
Type of Assessment
The Workshop does not include a final exam. The students have to complete a series of exercises to be carried out during the Workshop or at home.
Course program
Introduction to STATA
- data import
- Data set management
- variables
- data visualization
- tables
Introduction to MySQL
1. Creation, modification and population of MySQL schemas
2. Creation and use of databases and objects for queries on one or more tables (from simple selections to joining multiple tables)
3. Views: creation and use
4. Complex queries on tables and views
5. Introduction to Trigger, function and procedures