Lynda - Database Clinic: MySQL

Lynda - 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.

https://www.lynda.com/MySQL-tutorials/Database-Clinic-MySQL/609013-2.html

Introduction

1. Data and MySQL in under Five Minutes

2. Create a Database

3. Join Two Datasets

4. Search a Database

5. Create, Read, Update, and Delete Operations

6. Averages and Calculations

Conclusion