In the MySQL Workbench, design a subquery to pull data from the California Educational Assessment dataset. Then, build a query around that subquery to find the population coefficient that fits into different educational categories.
- [Instructor] Now that we have…the educational attainment data loaded…along with the population projection data from earlier,…it's time to start our calculations.…What we need to do is find the proportion of the population…in each age group that falls…into the different educational attainment cohorts.…Now, I'm not a data scientist…and these simple calculations I'm doing…would probably not get me hired by the state of California.…But in terms of showing calculations in mySQL,…I think they'll do the trick.…If you wanted to do something like this…in a production environment,…you would probably be better off linking your mySQL data…to some sort of statistical analysis package.…
Let's get started writing our query.…I've got the work bench open here.…I've got the CA pop database so I can go…to the default schema.…So, I will open a new SQL tab.…And we're going to need to create a nested query here…because we need two different population totals.…We will need the total population for each age…and then we need the population at each education level…
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Appropriate for all
1. Data and MySQL in under Five Minutes
2. Create a Database
3. Join Two Datasets
4. Search a Database
Searching a database1m 51s
5. Create, Read, Update, and Delete Operations
6. Averages and Calculations
Next steps1m 1s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
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.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.