Database Work
2026
Exercises with a film database
Summer Semester 2026 – Database Systems and Modeling, University of Bremen
Using SQLite 3
List of film titles in which Leonardo DiCaprio appeared:
In these exercises, I worked with storing and retrieving data in a Hollywood film database. To understand the database structure and extract relevant information, I learned the fundamentals of SQL and practiced different query formulations using SQLite.
The 20 most profitable films:
The 20 Films with the Highest Financial Losses:
List the actors who have won two awards at least 50 years apart:
List the top-rated film for each year since 2001:
