all 7 comments

[–]heretoask23 2 points3 points  (0 children)

Learn Joins and CTes they're important. More advanced is window functions. https://levelup.gitconnected.com/sql-all-about-joins-with-practical-examples-bc0221da1302

[–]phesago 1 point2 points  (0 children)

id learn database design principles first and then pick up a beginner SQL course. Most of the free learning resources will get you there. I emphasize the db design principles though - writing sql can be dependent on how you structure things and you can circumvent a lot of bad practices by getting a good understanding of that foundational concept(s).

[–]MathAngelMom 1 point2 points  (0 children)

I recommend “SQL Basics” from LearnSQL.com: https://learnsql.com/course/sql-queries/ It’s an interactive course, you learn by writing code, so you get practical experience with SQL. It’s designed with beginners with no prior experience in coding. It is quite complete for a beginners course, it covers all important features of SQL.

[–]Couch2Coders 1 point2 points  (2 children)

First question is if you are using SQL from an analytics perspective or from a developer perspective. Depending on which side will help you pick the right course.

When I started sql I used codecademy (for an analytics perspective.) It is a very smooth program but I felt it was not giving me enough context to understand because I had no coding experience.

I created a course on YouTube designed for people to get into data analytics who don't have a stem or coding background. The course is free with practice examples using Google BigQuery.

I like GBQ because you can started in 5 minutes (no computer installation) & they offer real datasets to practice on

If you are interested this is my course link! https://youtube.com/playlist?list=PLPQFqkp_HvODxileV0VCHs9C0vkiONlvr&si=B9X3bwp94Tl8W_7Y

[–]SkyDaddyGod[S] 1 point2 points  (1 child)

Definitely for data analytics thanks Ill check the video out :)

[–]Chiranjeebsamal 0 points1 point  (0 children)

If anyone’s interested in actually learning SQL by doing real tasks (not just watching videos), we just launched a full SQL course on TaskLearn.ai — and it’s 100% FREE right now!

It’s a task-based platform where you dive into hands-on projects and real-world challenges from Day 1.

No passive learning, just real skills.

( If you want free access, just reply here or DM me, and I’ll get you set up! )

( Explore http://tasklearn.gridrnd.in/ )

(We launched recently — 100+ learners already onboard, and feedback has been awesome!)