Creating databases in MySQL is straightforward. The difficulty comes from processing the data that they will contain. Learn what to look for in datasets before importing.
- [Instructor] As with all the data sets in this course,…you'll need to download the data…from the location shown earlier,…or refer to the PDF in the exercise files…and download the data from their source.…I've downloaded the file for this chapter already,…the California Population Projection 2010-2060.…Loading this data into our database…will involve three main tasks,…reviewing and formatting the data,…creating a database structure that will house the data,…and then importing the data itself.…The tasks are relatively simple, so it's a great way…to get used to the MySQL workbench software.…
The first step in importing data into MySQL…is reviewing the data.…Since you'll have to create a structure to hold the data,…you'll need to know what you'll be containing.…The data is stored in a type of file called CSV,…short for comma-separated values.…Essentially, all the data is stored,…such that one line in the file is one record of data,…and each value in that record is separated by a comma.…IF you have Microsoft Office installed on your system,…
- 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.