Join Brad Wheeler for an in-depth discussion in this video Join datasets, part of Database Clinic: MySQL.
- Data is inherently messy.…And in this next challenge,…our instructor has to clean it up.…Data sets are stored in different formats.…Sometimes as flat files…with simple rows and column relationships.…Sometimes as key-value pairs…as found in JSON or XML files.…Sometimes data is stored and distributed…with built in relationships.…These are often found in SQL files.…To make things more complex,…data is also stored in various formats.…
For example, sometimes dates are stored as strings.…Other times as the number of seconds…since January 1st, 1970.…Also known as the EPOC.…Numbers can be stored as strings, integers, or floats.…Locations can be represented as longitude and latitude,…or it can be defined as zip code, county,…or a magnitude of other formats.…Because of this, data sets often need to be reformatted.…Data scientists refer to this…as the extract, transform and load process, or ETL.…
Extraction is the simple operation of opening a data file.…The instructor did this in the previous chapter.…Transform is the process of converting data…
- 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.