Introduction to SQL and relational DBMS

September 7

Responsible: A. Belikov

Lecture outline

Start and stop mysql server, create database, ingest data, simple operations, data processing with SQL. Use mySQL and relational database to cross-identify catalogs.

Werkcollege tasks

You can download a copy of the tasks as a pdf copy, or an original PowerPoint presentation.

Description of tasks with solutions step-by-step in pdf.

Additional tasks for homework (pdf).

Necessary materials to werkcollege

How to start using mysql from python