The key to creating a database in MySQL is understanding how the data within is going to be used. Loading data in efficient ways, such as LOAD DATA, reduces the workload of database creation.
- [Instructor] Creating a database in MySQL…is extremely simple.…The real difficulty comes from understanding the data…that it will contain,…since you will need that information…to create a table for the data to reside in.…Often you'll need to make educated guesses…about how the data will be used…in order to decide how it should be stored.…Will you need to do math with a number,…and therefore store it as a numerical data type,…or will you need to manipulate it, like a string?…Once you've created a table,…it's important to load data into it…in an efficient way.…The load table statement is fast.…It only took a few seconds on my machine.…
Using the built-in import tools in a MySQL workbench…will also work,…but it can take vastly longer.…Finally, the relative simplicity of this challenge…lets you ease into the MySQL workbench…and introduced you to a lot of the tools…you'll be using for the remainder of this course.…
- Strengths and weaknesses of MySQL
- Creating a database
- Joining data sets
- Integrating Python with MySQL
- Searching a database
- CRUD operations
- Performing calculations
Skill Level Intermediate
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.