Database Clinic: MySQL

Test your knowledge of MySQL through a series of database problems framed in real-life scenarios.

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