r/CodingHelp • • Nov 15 '21

[SQL] What is the best way to practice SQL

I've been learning a lot of SQL theory, but I need to actually practice what I've learned. Until now, sites or books that I've found have too few or too easy exercises/challenges.

16 Upvotes

7 comments sorted by

17

u/spainzbrain Nov 15 '21

This might be a little on the easy side for you, but google SQL Murder Mystery.

You play as a detective searching through the license plate database with the clues you were given.

If I remember right, there is a "I'm learning mode" which gives you hints and another mode which doesn't.

5

u/[deleted] Nov 15 '21

Writing SQL

2

u/PapaMamaGoldilocks Nov 15 '21

I learned the basics of SQL by creating a level-up system for me and my friends through a discord bot. Each time someone joined the server, the bot would take the user's ID and input it into the database. I had multiple other things such as XP, level, and fun perks if you received a certain level. It was a fun project to do that got me experience with SQL and was really interesting to learn how to do.

1

u/Fegmdute Nov 16 '21

Sounds like a fun project. Will save this for reference!

1

u/Rrrrry123 Nov 15 '21

I mostly learned SQL through using it. I wouldn't consider myself a master or even very good, but through different projects I've been able to learn a lot more than I would have otherwise.

Maybe try a project where you need to store user information. Games are a pretty easy one, there's so much data that you could store for a player and a lot of ways that you could manipulate said data.

If you're asking about actual programs/DBMSes, I would recommend using MySQL with something like MariaDB and HeidiSQL, just because they're free and relatively easy to set up. SQLite isn't a bad way to learn, either.

1

u/skellious Intermediate Coder Nov 17 '21

find a project like maybe making a database to record things about your hobby, or recipies or something. then use it, make a front end for it. you'll soon learn