Learn a new way of creating a database structure by using raw SQL queries to create tables. Also learn how to export data from Excel into a format that MySQL can import.
- [Instructor] The first step to joining the dataset…is to load our data and in order to load our data,…we're going to create a structure for the data.…Since this UK accident data has nothing to do with the…California population data we were looking at before,…best practice is to create a new database,…which is what I'm going to do.…So, right click below schemas here, create a new schema…which I will call accidents.…I hit Apply.…There's my SQL window which I'll hit Apply again…and it was executed successfully.…I'll double on my accidents database and then right click…and set as the default schema.…
This means that any queries that are run…in the MySQL Workbench will by default be run…against the accidents database.…Of course the database is empty,…so we're going to need to create some tables.…In order to create some tables,…we're going to need to look at our data first.…So I'm going to go to the desktop where I've downloaded…the datasets for this challenge.…Let's take a look at the data.…I've downloaded to my desktop the road safety 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 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.