MySQL can manipulate data as well as select it. Learn how to perform calculations on fields using the results of other queries. Also learn about the difficulties in joining data that do not share columns.
- [Instructor] This challenge presents…us with an interesting problem.…We need to use our now familiar California population…projection data, and a new data set of real educational…attainment to provide the projected…demand for education in California.…However, there's a difficulty.…The datasets don't share any fields in common,…so a simple join across two columns is impossible.…There's another difficulty.…The educational attainment data only spans the…years 2008 to 2014, and our projection…will need to go from 2010 to 2060.…To solve this, we'll have to calculate the percentage…of the total population that has each type of education,…and then apply this coefficient to the projected…population data already in our database.…
To do this, we'll create an intermediate table…containing that coefficient for every combination…of age range and level of education.…Creating a table with calculated values…is usually not best practices for a relational database.…It's always best to recalculate the data…at runtime as part of your query.…
- 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.