Special offers now — see discounted courses.
day
:
hour
:
min
:
sec
See special offers
Level Up: MySQL

Level Up: MySQL

1h 4mIntermediate2023-07-31

Authors

Brad Wheeler

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

About us

LyndaKade is a leading learning platform that helps people learn business, software, technology, and creative skills to achieve personal and professional goals.

Phone numberAparat ChannelTelegram SupportTelegram ChannelInstagram Page

All rights to this site belong to LyndaKade.

Terms of Service|Privacy Policy

نماد الکترونیک enamad در صورت اتصال با آی‌پی داخل کشور، نمایش داده خواهد شد.
logo-samandehi - لوگو ساماندهی
zarinpal
zibal