jha-vineet69/SQL-Practice

Solved 42 Problems on Northwind Database in MySQL

SQL-Practice

Solved 42 Problems on Northwind Database with 10 Tables in MySQL.

Want to code along?

• Run Northwind.sql Script in MySQL.

  • This will generate Database and Tables for you.

• Problems are divided into categories.

  • Basic
  • Intermediate
  • Advanced

• Solutions can be found in these scripts:

  • Basic
  • Intermediate
  • Advanced

To Gain Maximum Results in Learning, Try to not look at Solutions and try the Problems yourself first. If you can do all the Basic problems with little to no difficulty you are good to go. Otherwise it would be better if you could brush up on SQL.

Some Good Introductory Videos on SQL:

• Learn SQL In 60 Minutes - Web Dev Simplified
• MySQL Crash Course | Learn SQL - Traversy Media

Tip: Goto Database -> Reverse Engineer OR Press Ctrl + R in MySQL Workbench. It will generate EER Diagram from you. This makes it easier to look at how the tables are connected. Simply makes your life easier.