Note: None of the labs in this course are mandatory, they are held to help you get started with the hands-on work and give you an opportunity to ask questions live. This lab is Zoom only

We will only be using one zoom room, and there will be plenty of chances to ask questions, related to the lab, the course, databases and SQL.

https://kth-se.zoom.us/j/62040278788

The lab will introduce basic SQL commands, and queries.

In case anyone has not already gotten started with the postgreSQL we will do a live tutorial of loading the imdb SQL file.

Using the IMDB database and running queries on it will be required to answer some of the questions in the mandatory quizzes, and understanding queries are an essential part of course, and to working with databases.

The (rough) schedule for the lab is as follows:

Load the IMDB SQL Database file live tutorial.
Basic SQL Commands live demonstration.
- Example: How to insert rows into a table? How to find the maximum values of a column?
Advanced queries live demonstration.
- Example: Show all movies where Samuel L Jackson is an actor ordered by premiere date.
Non-Graded Quiz Questions. Students solve two questions using queries in break-out sessions.
We discuss solutions to the two questions, and general Q&A.

The schedule may change depending on how many questions we get, and how quickly we are able to progress through our demonstrations.

Resources from the session

docker-setup.pdf

Queries and commands from the lab can be found here.

Slides: lab1-sql.pdf