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

Go to class Write review
Coursera Ad

40% Off Career-Building Certificates

Learn More → Scrimba Ad

Free courses from frontend to fullstack and AI

Learn More →

Overview

Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Test your knowledge of MySQL through a series of database problems framed in real-life scenarios.

Syllabus

Introduction
  • Test your MySQL skills
  • Codespaces
1. Challenge: Clean Up the Products Database
  • Find sales records with missing data
  • Find irregular order numbers
  • Fix column names
  • Fix sales records
  • Fix the irregular order numbers
  • Fix sales tables: Create additional tables
  • Fix sales tables: Create new relationships
  • Fix sales tables: Populate new tables
  • Create sales view
  • Find total sale price
  • Add a new transaction
2. Challenge: Learning about Your Products
  • Find the unpopular products
  • Keep on top of employee performance
  • Cancel the unpopular products
  • Find the best customers
  • Analyze sales by region
  • Find products that are no longer selling
Conclusion
  • Continue your MySQL journey

Taught by

Brad Wheeler

Reviews

4.6 rating at LinkedIn Learning based on 37 ratings

Start your review of Database Clinic: MySQL

Go to class

Never Stop Learning.

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

Sign up for free
Someone learning on their laptop while sitting on the floor.