Database Clinic: MySQL
2hBeginner2017-09-19
Authors
Brad Wheeler
Test and Validation Engineer at Allion USA
Course details
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
Learning objectives
Strengths and weaknesses of MySQL
Creating a database
Joining data sets
Integrating Python with MySQL
Searching a database
CRUD operations
Performing calculations
Skills covered
MySQLDatabase DevelopmentDatabase ManagementLimited SeriesOpen SourceSoftware Development
Concepts
0. Introduction
- 01 - Welcome
- 02 - The Database Clinic series
- 03 - What you should know
- 04 - How to use the exercise files
1. Data and MySQL in under Five Minutes
- 05 - A brief overview of MySQL
- 06 - Strengths and weaknesses of MySQL
- 07 - MySQL setup
2. Create a Database
- 08 - Database creation
- 09 - Overview of database creation in MySQL
- 10 - Create a database in MySQL
- 11 - Create a table in MySQL
- 12 - Load data in MySQL
- 13 - Insights on database creation in MySQL
3. Join Two Datasets
- 14 - Join datasets
- 15 - Overview of data joins in MySQL
- 16 - Create accident data structure
- 17 - Load accident data
- 18 - Join two datasets in MySQL
- 19 - Index in MySQL
- 20 - Find the median using Python, part 1
- 21 - Find the median using Python, part 2
- 22 - Insights on joining datasets in MySQL
4. Search a Database
- 23 - Searching a database
- 24 - Overview of search in MySQL
- 25 - Searching a database in MySQL
- 26 - Insights on searching data in MySQL
5. Create, Read, Update, and Delete Operations
- 27 - CRUD operations
- 28 - Overview of CRUD operations in MySQL
- 29 - Create database structure for CRUD
- 30 - Insert data in MySQL
- 31 - Update data in MySQL
- 32 - Delete data in MySQL
- 33 - Reading data in MySQL
- 34 - Insights on CRUD operations in MySQL
6. Averages and Calculations
- 35 - Calculations
- 36 - Overview of calculations in MySQL
- 37 - Import education data
- 38 - Finding demographics
- 39 - Calculations in MySQL
- 40 - Insights on calculations in MySQL
Conclusion
- 41 - Next steps