Overview
-
In this installment of the Database Clinic series, enhance your understanding of MySQL by seeing how it handles a series of common tasks.
Syllabus
-
Introduction
- Welcome
- The Database Clinic series
- What you should know
- How to use the exercise files
- A brief overview of MySQL
- Strengths and weaknesses of MySQL
- MySQL setup
- 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
- 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
- Searching a database
- Overview of search in MySQL
- Searching a database in MySQL
- Insights on searching data in MySQL
- 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
- Calculations
- Overview of calculations in MySQL
- Import education data
- Finding demographics
- Calculations in MySQL
- Insights on calculations in MySQL
- Next steps
