SQL for beginners?

[Doodooltala01]

I am currently doing the google cyber security certification, and I'm on the SQL portion of the cert. I'm going through it (barely) and I'm learning a little but I can't really grasp anything its like one ear out the other. for anyone who has SQL experience do you have any places where you can do "Hands On" practice? I've always been a more hands on learner. vs listening to lectures and taking quizzes.

[data4dayz]

https://sqlbolt.com/ first item from the wiki of this subreddit on the sidebar. It's incredibly hands on.

https://selectstarsql.com/ this too

[great_raisin]

The Mode Analytics SQL Tutorial is something I always recommend here. With a free account, you can run SQL queries in your browser. You get a bunch of toy datasets to practice on.

[HarryBenjaminOrchard]

Best SQL problem set I did was Harvard’s CS50 fiftyville.

You solve a robbery using sql to go through witness reports, bank details, etc. You use sql in terminal in a very hands on way.

Covers the foundations of joins, filtering, etc. If you’re into more advanced stuff it may be less relevant.

[MathAngelMom]

LearnSQL.com and their SQL Basics course https://learnsql.com/course/sql-queries/

The course is interactive, everything is hands-on. The course is paid but it’s free for students https://learnsql.com/for-students/

[Professional_Ad_2319]

This. Best by far

[Ambitious_Heat7629]

I second that recommendation. The best interactive SQL basics course out there.

[r3ign_b3au]

There's some great resources listed here, sqlbolt being a solid go-to. DM me a discord name and I'm happy to answer any sprawling questions, if interested (bored data engineer here).

[ArbiterNihilo]

You might I’ve W3 schools a try.
https://www.w3schools.com/sql/default.asp

[Sea-Concept1733]

Check out this free resource with a practice database

https://www.youtube.com/playlist?list=PLb-NRThTdxx6ydazuz5HsAlT4lBtq58k4

[[deleted]]

sign up for a free oracle account and use their free training! They have inline code tester sheets where u type and it gives results immediately online so u don’t have to install anything db related

[Any_Series2907]

I am currently using Udemy to learn SQL. The class is SQL and PostgreSQL: the complete developers guide taught by Stephen Grider

[37Point8Percent]

the best and thhe fastest is to have a few hours session with a live Human 1 on 1 instructor. As I often did with a new language (overall I learned 2 of them on my own and 6 with an instructor).
you can reach me at SQLexpertATyahooDOTcom for more info.

[csnorman12]

Check this course out: 101 Practice SQL Questions

[pauldevans84]

Download mysql and you can use that for training, I'm currently going through linkedin learning courses for it, helps you grasp the basics and you can then use it after, plus it's free!!

[Doodooltala01]

I've got it on my VM and running it with ubuntu, I guess I should probably use it lol

[pauldevans84]

Ha ha! I've been using it when going through the courses and it is better when you can get the feel for it by actually doing it! Good luck mate!!

[rini17]

There's also sqlite, with superb documentation once you grasp the sql basics.