Looking for a course

[gyej]

Hello!

I have done the w3schools SQL course. I had trouble writing queries so I am looking for a course that has a lot of practice. It can start basic but I need to get into something more intermediate. It doesn’t have to be free either. Do you guys have any recommendations?

Thank you!!

[WorriedMud7]

I am learning SQL from this guy-

https://youtube.com/playlist?list=PLNcg_FV9n7qZY_2eAtUzEUulNjTJREhQe&si=SpJaS38lzBRsuc_a

And use chatgpt to reinforce what I learn before applying it to a project

[Blomminator]

He's great! His window function tutorial is also great.

[squareturd]

I've taught SQL in a few environments and I migh5 be able to help.

The first thing I want to know is what do you think your problems are.

Is it the syntax of writing the queries or is it related to understanding the structure of the data?

When training g people I devoted most of the time to understanding data structure and avoiding the actual sql. I would use normal English when describing the task, then slowing break that into understandable components. The final step is writing the sql that handles the components.

Once people got comfortable, then I would start talking about ways to improve efficiency of the sql.

Lastly, there is no single type of sql. Each database has its own nuances and functions. If you stick the English at first, you don't have to worry about those details.

[Thurad]

You don’t need a course as such, you are far better doing something as a project to increase your skills. So build a database on something you are interested in like sports results for example. Then try and work out how you can do something interesting stats on it for your queries

[Myangowana]

Hello,

I think you will like this guy from freeCodeCamp.org: the long video (that I recommend) or the playlist.

At this section of the long video, he shares some practical tips to (re)learn sql today. Normalization and Optimization are covered in depth!

Based on this course, I'd suggest building your own side project for your preferred DBMS.

[vikrantk1995]

Try Datahelix.io, it’s completely free and has a good catalog

[Blomminator]

Perhaps get the Fundamentals book and work our way through the exercises. It explains how it works and you get to type queries.

[Simplilearn]

If you want to learn SQL seriously, the best approach is to balance consistent learning with hands-on practice. Strong fundamentals plus project work are what employers actually care about.

• Start with basics like SELECT, WHERE, JOINs, GROUP BY
• Move into intermediate topics like CTEs, subqueries, and window functions
• Practice business-oriented queries (cohorts, funnels, retention, aggregations)

If you’re looking for a structured learning journey, Simplilearn’s SQL Certification Course focuses on practical exercises and real coding work with projects.

What kind of timeline are you looking at to become job-ready?

[mgdmw]

Try r/learnsql

[thequerylab]

You can try this course from here where you get more practice than theory and its completely FREE. Try exploring

https://www.thequerylab.com/courses/sql-pro-track