Database Clinic: MySQL

Introduction

• Welcome
• The Database Clinic series
• What you should know
• How to use the exercise files

1. Data and MySQL in under Five Minutes

• A brief overview of MySQL
• Strengths and weaknesses of MySQL
• MySQL setup

2. Create a Database

• Database creation
• Overview of database creation in MySQL
• Create a database in MySQL
• Create a table in MySQL
• Load data in MySQL
• Insights on database creation in MySQL

3. Join Two Datasets

• Join datasets
• Overview of data joins in MySQL
• Create accident data structure
• Load accident data
• Join two datasets in MySQL
• Index in MySQL
• Find the median using Python, part 1
• Find the median using Python, part 2
• Insights on joining datasets in MySQL

4. Search a Database

• Searching a database
• Overview of search in MySQL
• Searching a database in MySQL
• Insights on searching data in MySQL

5. Create, Read, Update, and Delete Operations

• CRUD operations
• Overview of CRUD operations in MySQL
• Create database structure for CRUD
• Insert data in MySQL
• Update data in MySQL
• Delete data in MySQL
• Reading data in MySQL
• Insights on CRUD operations in MySQL

6. Averages and Calculations

• Calculations
• Overview of calculations in MySQL
• Import education data
• Finding demographics
• Calculations in MySQL
• Insights on calculations in MySQL

Conclusion

• Next steps