Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

LinkedIn Learning

Database Clinic: MySQL

via LinkedIn Learning

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

Taught by

Brad Wheeler

Reviews

Start your review of Database Clinic: MySQL

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.