Welcome to the Treehouse Community

Want to collaborate on code errors? Have bugs you need feedback on? Looking for an extra set of eyes on your latest project? Get support with fellow developers, designers, and programmers of all backgrounds and skill levels here with the Treehouse Community! While you're at it, check out some resources Treehouse students have shared here.

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and join thousands of Treehouse students and alumni in the community today.

Start your free trial

Development Tools Database Foundations Joining Relational Data Between Tables in SQL Joining Tables and Aliasing

Phil Ward
Phil Ward
4,204 Points
Posted by Phil Ward
Phil Ward
4,204 Points

Where can i get a completed project file for this Database deep dive?

At some point in the deep dive we create additional databases and delete data. i have a perfect database with all the correct new columns, foreign keys etc but it has no movies data in it.

The only data file i can find is the file on the first video which has all the data, but is prior to making all the changes on the table.

I'd like to get a complete data set before working on the query/count vids towards the end.

1 Answer

David Ker
David Ker
14,439 Points
David Ker
David Ker
14,439 Points

In the original movie_db.sql file, you can copy the line that inserts all the movie data (looks like it's line 67), and then paste it into the query window. Before you run it, since you've got the extra columns, you'll want to modify the statement so that it inserts the data into the correct columns. It'll look something like:

INSERT INTO 'movies' (title, year) VALUES ...

Might take it a bit for it to insert all 250 rows...but it's much easier than re-watching all the videos to re-create DB from scratch!