MySQL has powerful ways of interacting with data, but not all of them provide exactly correct results. Performing join operations with subqueries allows for a finer—not to mention faster—degree of data manipulation.
- [Instructor] Like most challenges,…this one was a little more complicated…than it looked at first.…Gathering the requested data was very simple.…We didn't even have to do any joins.…The complicated part came from…trying to format the data in a useful way…using only SQL.…However, it's an important skill to learn.…In production databases, you'll often need to format data…for reporting purposes,…or so that it can be exported into a specific format.…SQL has very powerful tools for making the data look right.…The idea of queries joining subqueries and tables…is also incredibly powerful.…In SQL, certain types of queries,…especially those with aggregated columns,…get exponentially more expensive.…
In terms of computer resources,…the more rows they involve.…Frequently, creating a simple query…to collect one subset of data…and then using it as a subquery…where it's joined back to the original data set…can be faster than creating a query…that joins to the original large data set…multiple times.…In fact, we'll take advantage of this very fact…
- 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.