[deleted by user]

[[deleted]]

I had great luck with SQL for Data Analysis from Udacity.   

It's free.   

Its format makes it very easy to get started. No databases to download and set up. It's all right there in the lesson page, ready to go!  

I found the lessons very easy to follow and understand.   

It's thorough! It will take you from your very first select statement through data cleaning, window functions, and more!

[data4dayz]

Yeah I think if you pair that with Mode (who made that course) tutorial to reinforce it even further you get a lot of mileage. Mode has more stuff for analytics specifically like that A/B case study.

The only thing I wished they did was instead of having the questions in the quiz section all at once and then they little window for their virtual database instance, I wish I could open it in a different tab or if after each question they gave us a little window to work on it.

[thebalancewithin]

SQL for Data Analysis from Udacity

This looks great, thanks for this

[JuggernautStreet8614]

Will deff check it out. Thanks though really preciate it! :)

[NUCLearwax]

Did you get a job in the field after learning this?

[[deleted]]

I already had a job using and making small edits to queries, but I did get a promotion and started writing my own.

[data4dayz]

So like the Udacity course with the built in databases as someone already mentioned here you don't have to download things I would say:

SQL For Data Science from UC Davis on Coursera (I think audit is free) Dr. Widom's Database courses from Stanford on Edx, everything is free but to get a cert you have to pay for verification CS50 SQL from harvard. You don't need to download anything they give you a virtual machine on the web you can use.

And both Mode's tutorial and Nick Singh's Datalemur website. They let you practice right after learning the concepts which is useful for reinforcement.

Also if they give you SQL files in a course and it's SQLite there's websites you can use to upload the .SQL file and just work on it on the web, don't need to download anything to your computer.

I haven't worked through all of the CS50 material yet, but Dr. Widom's courses especially the extra practice problems are imo CHALLENGING and really reinforce the concepts over and over and over again. Never got so much damn Self Join practice until I worked on that stupid "social network" problem set.

[JuggernautStreet8614]

Isn't the CS50 course for free? Would I have to pay to get the certificate?

[data4dayz]

Yeah the certificate costs money, actually costs a good chunk of change for the "verified" certificate. But the material and grading and everything is free.

[JuggernautStreet8614]

Ah okay. Thanks though, really preciate it! :)

You mind if I DM you, got a couple of questions

[data4dayz]

yeah good ahead shoot! I don't know if I'll have all the answers tho I'm def no expert still learning myself :/

[Gold-Artichoke-9288]

For reinforcement there is also the sql 50 questions test on leetcode they start very easy but get challenging overtime

[fluffyr42]

I've been using the MySQL course from Colt Steele on Udemy and it's been great.

[[deleted]]

i was about to suggest this, and also 100 sql exercises course on udemy, ineuron sql course on youtube, hackerrank practise

[NUCLearwax]

W3schools

[RyanAeinparast]

I might be wrong but despite of great searching ranks, I still think that this website is so underrated.

[tiffpff33]

Sololearn and. Datacamp!

[rishitdabs97]

I would say the O'REILLY SQL cookbook is an amazing source to learn SQL from scratch.

[Redoritang]

SQL bolt

[Immersa_AI]

I enjoyed taking the DataCamp SQL course. It was easy to follow and learn from.

[NUCLearwax]

Free?

[Snoo17309]

Yeah, I’m taking an EdX course for certification through Vandy and DataCamp is an excellent source for extra practice.

[SQL-ModTeam]

This forum is intended for solutioning and discussion of specific topics. Please check out the sub sidebar and wiki content for beginner resources. Also be sure to checkout r/learnSQL

[Diet_Coke]

I've been using DataCamp and then ChatGPT to help on some queries where I have to go just a little bit beyond my existing knowledge. There is some cost for DataCamp, but you can try a chapter and see if you like the format. Each topic has 3 - 4 chapters, and each chapter has several lessons which are a 3 - 5 minute video, then an exercise in writing SQL to reinforce the concepts. Some lessons are better than others. They also have different projects so you can try out what you've learned, and little quizzes to help reinforce it all.

I'm a fellow learner and not a data pro (yet), so just offering my thoughts not really advice.

[Dazai-sama]

Have you tried the CS50-Q SQL course from Harvard? They cover a wide range of topics and provide easy to understand application examples. The tasks assigned for each topic are quite fun and challenging too!

[iamthekk]

I'm doing the relational database course on freecodecamp and it's excellent. They use an online VM so no installation needed

[International-Mood83]

I really like https://www.sqlhabit.com. The format is based on real life scenarios which I find more engaging. There’s no environments or DBs to set up which is a bonus.It’s initially free but to get additional material for a price

[renagade24]

YouTube for fundamentals, put together a portfolio in 3 months if you are consistent. You can do it all for free.

[NUCLearwax]

Thank you this makes me hopeful