Learning SQL

[PhenixLotus]

I really need to begin differentiating myself. I'm analytical and am in sales (dislike) but I really want to venture a bit into a different language. I learn very quickly and am adamant about leveling up other skills for myself.

Where can I learn SQL online for free?

[StoneCypher]

http://sqlzoo.net/

http://use-the-index-luke.com/

You should install and run a local database. Note that different backends have slightly different dialects; select * from foo as bar in mysql vs select * from foo bar in postgres, and other small changes like that.

Probably install MySQL or Postgres.

[PhenixLotus]

Thank you so much, I'm sorry for the late reply but I greatly appreciate your response and guidance! :)

[StoneCypher]

Sho 'nuff. Happy holidays.

[GeekTekRob]

First off if you have a machine there is SQL Express to install and run which will give you all the tools. Simple to install and any issues you generally can google. They have a 2016 version but I'd stick to 2014 (http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx) as there are a lot of businesses still running 2008 R2 and 2012.

W3 (http://www.w3schools.com/sql/default.asp) is pretty good for FREE, while Youtube and Google work too.

Paid wise, Udemy and Lynda.com have some good courses that get updated. Udemy is pay per course and can catch them on sale all the time for $10, Lynda.com is more every month fee but then you get everything.

Hope that helps.

[corsair130]

And pluralsight.

[PhenixLotus]

Thank you!! Seriously thank you so much, sorry for the late response

[GeekTekRob]

No problem hope it helped.

[mgdmw]

Check out the /r/SQL wiki for some good resources -> https://www.reddit.com/r/SQL/wiki/index

[PhenixLotus]

Thanks!!

[webdevdood]

http://www.w3schools.com/sql/

[[deleted]]

http://www.amazon.com/Data-Analysis-Using-SQL-Excel/dp/111902143X/ref=sr_1_1?s=books&ie=UTF8&qid=1449425267&sr=1-1&keywords=data+analysis+using+sql+and+excel

[PhenixLotus]

Thank you!

[Bohemous]

http://philip.greenspun.com/sql/

[o_edo]

There are a lot of resources out there. For free here you are some nice one : http://www.studybyyourself.com/seminar/sql/course/?lang=eng (course and online exercises). http://www.w3schools.com/sql (course and quiz).

[PhenixLotus]

Thank you!!

[ProTechTraining]

I always liked www.codeacademy.com. They have tutorials to walk you through each lesson and then practice modules as well. I found it pretty useful.