02_managing_data_and_analyses

Managing data and analyses

By Gianluca Campanella (g.campanella@estimand.com)

Objectives

By the end of the session, you should be able to:

• Define the main types of databases, and their use cases
• Write simple SQL queries to extract data from relational databases
• Use the git CLI to interact with local and remote repositories

Plan

The session is designed to be delivered over three hours (including breaks).

Topic	Time
Introduction to databases	30 minutes
Exercise	45 minutes
Version control with Git and GitHub	30 minutes
Git demonstration	45 minutes

Materials

• Introduction to databases
• SQL exercises and solutions
• Version control with Git and GitHub

Additional resources

• DB Browser for SQLite
• Git documentation
• Try Git