From the course: Intermediate SQL: Data Reporting and Analysis
Join today to access over 24,700 courses taught by industry experts.
Understand the demo database - SQL Tutorial
From the course: Intermediate SQL: Data Reporting and Analysis
Understand the demo database
- [Instructor] The sakila demo database was created for a fictional and old fashioned movie rental business where you went into a real physical shop and left with a real physical movie on a DVD or a VHS. If you look on the left hand side, you can see Tables and Views listed under the word sakila. And normally we would have functions and procedures listed there as well but they have disappeared. And that's because as I said before, this is an unstable environment, so people just come along and delete things at will. We're mostly going to be looking at tables which is contains all of this data. I want to build a database diagram now to show you briefly how all of these tables link together. You can see that we have the rental and inventory tables represented by these two blue boxes here. Each blue box is a table, and I have shown the primary and foreign key fields only 'cause they're the ones that do the work of linking…
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.
