I was looking to improve my SQL and I found this gem that I want to share. This is in a nutshell:
SQL to work with: ranking, join & data mining.
First Step:
https://8weeksqlchallenge.com/getting-started/
This website I agree is not the most easy to navigate, but browse to the link and search for "Case Study #1 - Danny’s Diner". Click on the article and you will see the "DB Fiddle" which emulate a real SQL database.
E.g.
Week 1: https://8weeksqlchallenge.com/case-study-1/
DB Fiddle: https://www.db-fiddle.com/f/2rM8RAnq7h5LLDTzZiRWcd/138
For those that want to load data on their own, I create a docker server where you can import a CSV, build a SQL database and create SQL queries.
Last Step:
Go on the 8weeksqlchallenge website and load the example into the docker-compose server
Here is my repository if that helps some!
Repository: https://github.com/poboisvert/docker_sql_csv_loader
Your CSVs will be there
Your SQL tables will be there
Docker server settings is there
- docker-compose.yml
Top comments (0)