The MySQL Workbench is a powerful tool for interacting with the MySQL Server. Get an overview of the Workbench interface, then create a database for holding California population projection data.
- Now that we've downloaded and examined our dataset,…it's time to setup our MySQL database.…Open up the MySQL Workbench,…and click on your local instance under MySQL Connections.…You might need to enter the password you created…during setup.…Now, you can see the MySQL Workbench interface,…with the Navigator window on the left,…the Output window down below,…the Query window in the center,…and the SQL Additions window on the right.…The first thing I'm going to do is get a little bit more room.…I'm going to click on View,…then Panels, and Hide Secondary Toolbar,…to get rid of the SQL Additions panel.…
We're not going to be using it for this course.…So, now that we've reviewed the data,…we need to create a database to contain it.…In MySQL, databases are sometimes called schemas.…The two terms are interchangeable.…They both refer to collections of related tables,…functions, and metadata.…You can see that there's already a system schema…in the Navigator pane.…We need to create a new one, so we'll right-click…below the schemas here, and click Create Schema.…
- 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.