DEV Community

poboisvert
poboisvert

Posted on

Serious SQL during Summer 2022 & free

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

Image description

Top comments (0)