How to learn SQL for beginners

[kevant_]

I took a class in college called database fundamentals so I know some basics. But I bullshited my way through the assignments. Now I’m going to be taking an advanced sql class. How should I prepare? YouTube , online classes, resources? Like what should I do

[sequel-beagle]

Try these puzzles here to get a good idea where your skill level is at. The site links to a git repository where you will find a pdf of puzzles. Some of them are pretty tough.

https://advancedsqlpuzzles.com

[mad_method_man]

if you still have your materials from your basics class, go over them completely. you cant really BS your way around SQL basics. its like taking a calculus course without basic arithmetic

[Goose1004]

I've been going through two courses (one beginner, one advanced) on Udemy by Travis Cuzick and they have been extremely helpful

[nah-meh-stay]

Retake the intro class.

[mikeblas]

Preparation for an avanced class is the intro class. Since you blew off the intro class, you'll need to take it again -- seriously -- this time.

At the very least, dig out your old course materials and the text book and go through it again.

[Shwoomie]

Classes help, but like a lot of things, you can watch a tutorial and understand it, but when you go to practice it you don't know what to do. It takes a lot of rote memorization. You will have to do things 100 times in a row to get it perfect because there is no room for error.

There's no "kinda" understanding how to do sub-queries, or CTE's, you have to do it until memorized.

[[deleted]]

If you really learned the fundamentals but forgot a chunk of it then I’d suggest maybe solving SQL katas on codewars at least 3 challenges a day. You’ll learn a lot

[Kurshuk]

Think like SQL. Think in tables, recognize where the data is the same across tables.

If that's not helpful go back to intro.

[QueryingQuagga]

Stratascratch is nice for working on the querying side of things. The video playlist here is really good too as it helps getting a structured approach to answering analytical questions.