We built two (2) different datasets to encompass a motivating hypothetical that's based of personal experience. This is an abridged version of a practical dataset both Serge and I have had to interact with at work. In total, there's only one hundred twenty five (125) rows of data, but that's all you'll need to get up and running with SQL and/or continue to hone your skillset.
If you understand how to setup a local database, and/or already have on setup — we've made it really easy to access each dataset as a CSV file, and either upload or insert each dataset with SQL. All these files are stored in our San Francisco Data School Member Drive.
If you don't understand how to setup a local database and need some help, get in touch via our Contact Us form or check out our Premium Membership offering (we'll let you use our database and BI Software partnerships)!
These datasets are small on purpose, and not to be underestimated. It's incredibly powerful, and a great learning environment to know exactly what you're dealing with. In each new learning endeavor you'll be able to see the entire dataset shift in front of your eyes, thus allowing you to easily quality assure your progress. Even with just two (2) datasets and 125 entries/rows in total you'll still have an opportunity to uncover sophisticated SQL tasks.
Dataset Overview and Specifications
The two datasets are able to be joined together. We've given some high-level guidance as to how datasets join to one another.
This dataset contains five (5) fields with one hundred (100) total entries/rows of data. Below is a breakdown of each field:
This dataset contains five (5) fields with twenty five (25) total entries/rows of data. Below is a breakdown of each field: