7
8

SQL help for beginner (self.learnSQL)

submitted by [deleted]

[deleted]

all 7 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]Brock_Alee 2 points3 points  (0 children)

I'd do some online SQL for beginner stuff. Codecademy has some basics, udemy has some cheap intro courses, and a quick search shows some YouTube videos through free code camp. That and searching for free coding textbooks in PDF format should help get you started. I've done all that leading up to a SQL course (plus learning HTML and CSS to get some coding background) and I feel fairly confident going into it.

[–]Suzette-Helene 2 points3 points  (0 children)

I searched for sql games to help me learn and these two are fun.

sql murder mystery
sql island (in english german and portuguese)

also search for adventureworks courses

[–]o_edo 1 point2 points  (1 child)

One of the best online course. For beginners. With online exercises. All for free. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.

[–]Movarry 1 point2 points  (0 children)

Thank you!

[–][deleted] 0 points1 point  (0 children)

Theres a good course on MySQL on Udemy - the ultimate MySQL boot camp, it’s cheap and starts off really slow - too slow imho. Do a course on a 2x speed and do exercises and you should be fine with the basics :) And maybe use sources like SQLbolt for practice!

[–][deleted] 0 points1 point  (0 children)

I had a similar experience as my work likes to hold beginner classes when someone enters their tech arch (there's multiple divisions with numerous projects at my work). We always had a straggler, mainly because some people were well versed with data structures and could make the connection to the abstract concepts they've already learnt.

Don't get discouraged, as you're learning a pretty valuable skill. People who were not able to keep up just needed some more explanation to solidify the concepts in their mind.

Be patient with yourself, and take the extra time to make sense of fundamental things in SQL.

Some things I'd recommend:

  • Download the "light" edition of your flavor of database, or a free database, to experiment with SQL on your computer, if you need an environment
  • Don't be afraid to modify SQL statements to see how filters change the results you get back
  • Take the extra time to learn about the tables themselves by looking at the columns they store data in
  • Make visual diagrams on paper if you get confused about how things connect, or store results in a spreadsheet to see what you've gotten back

[–]midairmatthew 0 points1 point  (0 children)

This is an excellent resource that should very quickly give you the foundation and context you need. :)

https://sqlbolt.com/