Searching large datasets provides its own challenges. Using a multimillion line database, learn how to speed up large searches using indexes. Also learn how subqueries can break up large operations, as well as changing how they're formatted.
- [Instructor] When I initially loaded…the California population data in a previous exercise,…I didn't really do anything with it.…I just ran a quick select query to show that the data…had been imported successfully,…and that was it.…In this challenge, I'm going to actually search the database…to find some useful data…and format it in a visually appealing way.…I'll start by adding an index…to our California population table,…since it's so enormous.…Then I'll create a simple, almost correct query…without the formatting.…This query will have all the data we need,…but the columns won't be quite correct.…However, we can modify that query…to provide the data for just one gender,…format it correctly,…and then create a second query for the other gender.…
Then we can join those two queries together…to create our final correctly formatted query…right in the workbench.…All right, let's get started.…
- 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.