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.

If anyone has not already started with PostgreSQL, we will conduct a live tutorial on 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. Understanding queries is an essential part of the course and 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.

NOTE: Please ensure that you have installed the PostgreSQL CLI (Command-Line Interface) before the lab. You can either use Docker (check this docker-setup.pdf) or download and install PostgreSQL directly from the official website (instructions here).

You can find the lab content, including all the queries we tested, here.