Welcome to the Treehouse Community

The Treehouse Community is a meeting place for developers, designers, and programmers of all backgrounds and skill levels to get support. Collaborate here on code errors or bugs that you need feedback on, or asking for an extra set of eyes on your latest project. Join thousands of Treehouse students and alumni in the community today. (Note: Only Treehouse students can comment or ask questions, but non-students are welcome to browse our conversations.)

Looking to learn something new?

Treehouse offers a seven day free trial for new students. Get access to thousands of hours of content and a supportive community. Start your free trial today.

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

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

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!