课程: SQL: Data Reporting and Analysis
今天就开通帐号，24,600 门业界名师课程任您挑！
Understand the demo database
- [Instructor] Sukila database contains fake data for a DVD rental store. So this was created in 2006, back in the day when you would physically go to a shop, look at a selection of DVDs on a shelf, and take one home and watch it. Some of the tables that are in here we would entirely expect of a sort of retail business model. So there's a table on stores or shops data. There's a list of staff, and we have a customer table, which contains obviously customer name, whether that customer is still active, et cetera. Then we have a series of more frequently updating tables. We have the infantry table, which is a stock check effectively, payment table for transactions, and a rental table, which ties lots of these other data points together. So this one will tell you which customer rented which film on which date. So far so ordinary, but the Sukila database is quite a lot more powerful than that. It contains a lot of…
下载课程离线学习
下载课程到移动设备，轻松离线学习。在领英学习 iOS 或安卓版 APP 下载课程