The challenging part of this problem is the report. It's easy to select the data, but properly formatting the results required a join as well as a subquery.
- [Instructor] This database clinic problem asks us…to determine if there is a relationship between two values.…The type of motorcycle and the accident severities.…To do this, I'll need to get several sets of data,…link them together, then draw a comparison.…This is a pretty common thing to do with data,…and as in most cases, the raw data…for these values are in two separate datasets.…You'll find instructions for obtaining these datasets…in the beginning videos of this course.…
Or consult the handout in the exercise files.…The Accidents_2015.csv file…is a comma separated file…that contains information about 140,000 accidents.…I've taken a quick look at it here in DB Browser,…and we can take a look at the data that it represents.…Vehicles_2015 is also a comma separated file…that contains information about vehicles in the accident.…
There is also an Excel file…with Road-Accident-Safety-Data-Guide.…And it has two lookup tables.…First is the vehicle type,…and you'll notice that it has two columns.…One for code, and one for the label.…
- Strengths and weaknesses of SQLite
- Creating a database
- Joining data sets
- Calculations with SQLite and Python
- Searching a database
- Subqueries and queries in SQLite
- CRUD operations in SQLite with R
Skill Level Intermediate
1. SQLite in Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.