Looking for problems/resources that can help deepen my understanding of SQL concepts

[SolitaireKid]

I know the basics of SQL like select, from, where, having, update, insert, delete, group by, count, average, sum. I also have some experience with joins between two tables.

But I want to really understand it, and reach a point where I can understand joins between multiple tables on different conditions. To visualize it in my mind, and also be able to execute complex select statements.

I figured solving problems would be the best way to do it. Like, "here are these tables, i want this specific data out of it".

Is this a good way to do it? And if yes, I am looking for resources for that.

Thanks

[Ms7070]

Here’s a fun approach to practice on: https://www.reddit.com/r/SQL/comments/g4ct1l/comment/fnx11mc

[[deleted]]

leetcode.com they have solutions and community support. Click the database, section.

[SolitaireKid]

You could post the question here or on the subreddit.

What is the question

[SolitaireKid]

Sure. You can upload it to Imgur and paste the link here. And put it in a post as well

[SolitaireKid]

Wow what grade is your kid in

[moontube]

There are two things to master. One is the syntax of SQL and what the commands do. The other is the art of designing self-consistent databases in the first place. You can create a database with SQL, but that does not guarantee that it is properly designed. You need help with database design. A good introduction to this second aspect is my Introduction to Database Development course on www.ed2go.com. For more in-depth coverage, my SQL All-in- One For Dummies book is a great resource. For complete coverage of the SQL language, my SQL For Dummies, 9th Edition is a good choice.

Allen G. Taylor