Advanced Training Course: Data Science – Computer Methods for Data Management in Biomedicine and R

The organization of data, their understanding and their representation so that they become useful information in the development of knowledge, can be implemented with different methodologies and tools with performances that change according to the purpose for which the data are collected and processed.
OBJECTIVES AND COURSE PROGRAM
A data organization for continuous and structured use requires knowledge of data structures.
The course aims to provide the adequate consequences to begin to possess the skills for a rapid and efficient manipulation of the same. Starting from the basic concepts of structured data organization with a management system up to the realization in the database and the principles of its optimization.
NO PREREQUISITES ARE REQUIRED TO PARTICIPATE IN THE COURSE.
Teachers: Luigi Corsaro
Activities Calendar and Program
Day 1 – 9.30am-4.30pm
Title: “Data organization, forms and methodologies” & “Basic concepts of DBMS”
Objective of the lesson: to understand the different ways in which it is possible to store and organize data and to know the basics of a DBMS and differences between DBMSs.
-Introduction of the Course and Generalities
-types of DBMS database management systems
– differences between the types of DBMS
-DBMS on the market
-charset
– types of data
-tables and views
– basic security of a database (users and administration)
– advanced security of a database (encryption, anonymization)
Day 2 – 9.30am-4.30pm
Title: “basic elements of an RDBMS”
The aim of the lesson is to understand an RDBMS in detail and to learn the basic elements of an RDBMS.
-architecture of an RDBMS
– RDBMS database design concepts
-definition of Indices and relations
-operations possible on RDBMS
– transaction concept
Day 3 – 9.30am-4.30pm
Title: “Perform operations”
Objective of the lesson: to learn with practical examples how to manipulate the data of an RDBMS
– syntax for creating databases and tables
-syntax for entering, reading, updating and deleting data
– syntax for importing and exporting data
– restore data in a database
Day 4 – 9.30am-4.30pm
Title: “Design and implementation of an sql database”
The objective of the lesson is to learn how to draw a database with a real example.
– presentation of real cases
-selection of the most appropriate solution for each example
-design of an RDBMS database
– complete creation of a database with a visual tool
-create tables with command line
– insertion, reading, updating, deletion, data
– data import and export
– data loss recovery
Day 5 – 9.30am-4.30pm
Title: “R and Database”
The objective of the lesson is to learn how to interact with a database using R.
-Environment preparation
– access to table data
– access to aggregate data
-graphs and plots
– create a model
-save a model
Professor:
Luigi Corsaro is a biomedical engineer graduated from the Politecnico di Milano currently consultant in information technology in A Company, a company of skills that helps public and private organizations to an effective process of innovation and digitization. He has worked in various application fields: industry, health and energy.
Where the course is held:
The course will be held in live online mode with the use of cloud servers for the part relating to the exercises
Costs:
The course is free for PhD students of the University of Pavia
For external users, the course has a cost of 250 euros for students and postgraduates and 500 euros for professionals
Signing up: