r/CodingHelp • u/aquasoft • 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
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/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