Database Clinic: MySQL

The Database Clinic series pits experts and their databases of choice against a series of the same challenges, to highlight the unique capabilities of each database. In this installment of the series, Brad Wheeler demonstrates how MySQL—one of the most widely-used database programs—would rise to meet each task. After going over the strengths and weaknesses of MySQL, Brad shows how to create a database, and quickly load data into MySQL. He also explains how to join data sets; how to search, transform, and perform calculations with your data; and how to use external programming tools to interact with MySQL.

Learning objectives
Strengths and weaknesses of MySQL
Creating a database
Joining data sets
Integrating Python with MySQL
Searching a database
CRUD operations
Performing calculations