Analyzing Movie Data with SQL

There is a programming assignment about analyzing movie data with SQL In the module 3, Course 4 of the Data Analytics Professional Certificate on Coursera.

The link that was provided to the database dataset used in this lab on Kaggle is broken. The page cannot be found again. I want to have a copy of this dataset so I can complete the lab on my local JupyterLab.

My findings reveal that the size of the database file, “mubi_movies_ratings.db“ used in this lab and another one is 1.8GB. I would appreciate any help to have a copy of this file. Thank you.

Hi @angeleyes!
I believe you might be able to download the .db file from the lab directly (click with the right button >> download). In case it doesn’t work, please use my link as a ‘temporary solution’:

And thank you for reporting the broken link! I will report it, so it can be fixed.

Thank you for coming to my rescue. I initially thought that I could download the .db file directly from the lab, but it didn’t work. It failed each time, but the lab notebooks can be downloaded. I tried a lot of tricks, but they still didn’t work.

However, the link that you just shared works just fine. Thank you.

1 Like

Glad to help! Have fun with the lab :slight_smile: :woman_technologist:t4:

Because of the size of the dataset, I do not think the assignment includes a copy. Instead it likely uses a link and accesses the database online as needed.

When I said I tried a lot of tricks, that was because I knew the database file was there, but it could not possibly be downloaded, unlike the other files and notebooks. I was even able to copy the content of the hidden environment variable files that were needed for some labs.

It was the same database file that was symlinked for the second lab, which also required it. I guess maybe they restricted its download because of its size. Thanks to @imgabidotcom for sharing her own Kaggle link to download the file.

2 Likes