Level Up: MySQL
1h 4mIntermediate2023-07-31
Authors

Brad Wheeler
Test and Validation Engineer at Allion USA
Course details
MySQL is one of the most common databases in the world and there’s a lot of value in gaining experience with it. Join instructor Brad Wheeler in this course for a series of challenges, framed in real-life scenarios, that will test your MySQL skill and show you some new tricks. In the first half of the course, Brad presents a messy, incomplete database that you’ll have to turn into orderly, usable data. In the second half, you’ll use the newly-reorganized database to learn about a fictional company’s employees and customers—with the challenges getting more involved as you go. Try the challenges, compare your solution to Brad’s answers, and gain confidence in thinking through and solving database problems using realMySQL tools.
Skills covered
MySQLDatabase DevelopmentDatabase ManagementOpen SourceSoftware DevelopmentOne-Off
Concepts
0. Introduction
- 01 - Test your MySQL skills
- 02 - Codespaces
1. Challenge - Clean Up the Products Database
- 03 - Find sales records with missing data
- 04 - Find irregular order numbers
- 05 - Fix column names
- 06 - Fix sales records
- 07 - Fix the irregular order numbers
- 08 - Fix sales tables - Create additional tables
- 09 - Fix sales tables - Create new relationships
- 10 - Fix sales tables - Populate new tables
- 11 - Create sales view
- 12 - Find total sale price
- 13 - Add a new transaction
2. Challenge - Learning about Your Products
- 14 - Find the unpopular products
- 15 - Keep on top of employee performance
- 16 - Cancel the unpopular products
- 17 - Find the best customers
- 18 - Analyze sales by region
- 19 - Find products that are no longer selling
Conclusion
- 20 - Continue your MySQL journey
Related courses
Related learn paths
- Master Your Python Skills
- Master Python for Data Science
- Master Advanced Excel Data & Analytics Skills
- Take Better Photos with Your Phone
- Getting Started as a Java Developer
- Introduction to Fundamental Skills for Data Work: Data Storage
- Build Your Knowledge of Cloud Administration
- The Top Skills IT Professionals Have Right Now