Extracciones de datos con SQL. Ejemplos a partir de la Muestra continua de vidas laborales (MCVL).

Duration: 8 hours / 2 days

Date: 12th and 13th of December 

Time: 9:30 - 14:00 

Format: Presential.  Dr. Aiguader 80, Barcelona - classroom 61.106 (12th of December) (1st Floor - teaching building),  classroom 61.212 (13th of December) (2nd Floor - teaching building)

Available places: Closed

Course Description

This course is an introduction to SQL. We will explore the different SQL SELECT STATEMENTS, from basic structures to others more complex. We will use the MCVL tables as a practical example.

Prerequisites

This course has no formal prerequisites. 

You should bring your own laptop with MySQL Workbench installed.

Schedule

Day 1

• Tablas y tipos de datos.
• Reglas de integridad: Índices, Primary Keys y Foreign Keys.
• Consultas básicas: formato, operadores, resultados sin repeticiones. Funciones de agregación, ordenación y agrupación.

Day 2

• Formato de consultas sobre más de una tabla.
• Consultas de Unión, diferencia.
• Subconsultas.
• JOINS

Class Pace 

We encourage the participants to do as many questions as needed during the whole course. The hands-on practical session aims to enhance dynamic learning.  

References

• Gulutzan, P.; Pelzer. 1999. SQL-99 complete, really. T, R & D books.
• Jeremy D. Zawodny, Derek J. Balling. Third edition 2012. High Performance MySQL: Optimization, Backups, Replication, Load Balancing & More (Advanced Tools and Techniques for MySQL Administrators). O'Reilly.

Short biography 

Juan Manuel Fuentes is a HPC System Administrator in the Scientific IT Service in the MELIS Department at Universitat Pompeu Fabra. Previously, he did the Bachelor’s degree in Computer Science Engineering in the Facultat d'Informàtica de Barcelona at Universitat Politècnica de Catalunya. His interests include HPC Systems, Linux OS, Quality management systems and best practices in IT service management.