Webinar 1 – Structure
Webinar recording:
Here you can find the structure for the first webinar. In particular, we will discuss: (i) module organization and functioning; (ii) basics of the relational model; (iii) SQL create, delete, and insert.
| Week (date) | Agenda |
|---|---|
| 1 (24-05) | Introduction to SMM695 |
| PostgreSQL vs MongoDB | |
| Relational model | |
| Q&A | |
| Group discussion – artworks sample | |
| ER diagrams | |
| Homework solutions | |
| psql via PgAdmin or Terminal | |
| Loading the Pagila example |
During the group discussion, you will be provided with a small random sample of the artworks_data.csv retrieved at the Tate GitHub repo.
Please review the pre-recorded material and inspect the artwork sample before attending this webinar.
Material
Webinar materials:
- whs_1.sql: solutions for the hw_1.md;
- artwors.csv: a small and simplified version of the artworks_data.csv;
- erd.png: an entity relation diagram obtained with PgAdmin 4;
- wsc_1.sql: a possible schema for the artworks case built with SQL.
Pagila
To load the Pagila example, please do the following:
1). Open psql;
2). Create a new database and connect:
CREATE DATABASE pagila;
\c pagila;
3). Use \i to run the SQL script:
\i /PATH/TO/pagila-schema.sql;
\i /PATH/TO/pagila-data.sql;