Internet Movie Database (IMDB)The Internet Movie Database (IMDB.com) is a large website containing information related to films, television programs, home videos, […] November 12, 2021 in IMDB tagged database / internet / dataset / movie / imdb / tv / IMDB Data Files by Mike
IMDB and the Excel Data ModelWhat if we wanted to import this database into Microsoft Excel and work with it? We want to […] November 23, 2022 in IMDB tagged relationship / imdb / data / model / IMDB Data Files by Mike
IMDB Repeating Genre ValuesIn working with the IMDB database tables, you find that each moving picture can have one or more […] November 24, 2022 in IMDB tagged query / reference / duplicate / power / unpivot / IMDB Data Files by Mike
IMDB Title BasicsThe titlebasics file is a good file to start with after you have downloaded it. I re-named the […] November 26, 2022 in IMDB tagged query / title / imdb / power / IMDB Data Files by Mike
IMDB Unique Genres QueryIn order to set up our relationships in the Data Model, we need to create another table. This […] November 27, 2022 in IMDB tagged type / imdb / genre / IMDB Data Files by Mike
IMDB Name BasicsThe namebasics file has all of the people in it. It has the moving pictures that they are […] November 27, 2022 in IMDB tagged name / people / imdb / IMDB Data Files by Mike
IMDB Primary ProfessionIn the IMDB database, each person in the namebasics.tsv file may have none or more professions. There are […] November 27, 2022 in IMDB tagged name / imdb / profession / IMDB Data Files by Mike
IMDB Titles Known ForEach person in the database can be known for certain titles (moving pictures/movies). We need to “normalize” these […] November 27, 2022 in IMDB tagged link / name / title / imdb / IMDB Data Files by Mike
IMDB Writers and DirectorsLet’s go ahead and add a bit more. We’ll add the writer’s and directors’ tables. Below is the […] November 28, 2022 in IMDB tagged writer / director / name / people / imdb / IMDB Data Files by Mike