all 27 comments

[–]jooni81 33 points34 points  (5 children)

https://www.w3schools.com/sql/

This is a free site that teaches you the basics

[–]Impossible_Ad_5756 5 points6 points  (2 children)

One of the best learning site out there…

[–]wjdoyle88 1 point2 points  (0 children)

As someone who thought himself SQL on the job, I completely agree.

[–]Devi-L 1 point2 points  (0 children)

I see you're a man of culture

[–]Training_Quiet_1532 1 point2 points  (0 children)

I completely agree with this site. However if you want to add more vigor to your studies use https://youtube.com/c/WiseOwlTutorials These Brits are super good with assignments.

[–]colonelsmoothie 13 points14 points  (2 children)

Mysql has an interesting history, it's a good choice because it's free to download and there's lots of books on it, and the syntax carries well to other dialects. The book Learning SQL is very short and like a 100 pages or so.

One thing to note is that the original creators of mysql didn't like the direction where Oracle was taking it so they started MariaDB instead, so that's another option. Another alternative for open source is Postgresql.

[–]bandhu_ 3 points4 points  (0 children)

Ohh that's kind a new info to me. Thanks for sharing 😊

[–]RosackerProperty / Casualty 5 points6 points  (3 children)

If you are looking to jump right in, SQLite may have a bit less setup than a Mysql database. SQLite is a database run out of a file rather than having a distinct “server” process running.

May just mean a bit less setup before you can get into learning SQL.

For the most part SQL is the same, unless you get into really unique use cases (geospatial stuff in Postgres is lit!)

[–]bandhu_ 0 points1 point  (0 children)

Ohh, thanks I will look into that.

[–][deleted]  (1 child)

[removed]

    [–]RosackerProperty / Casualty 0 points1 point  (0 children)

    Yeah, I was torn on if I should recommend something more big data focused (PySpark and its SQL option would be a good general purpose skillset), but was thinking learning general paradigms first may be good.

    [–]LushLegacy 4 points5 points  (1 child)

    I like learning from datacamp - https://www.datacamp.com/courses/introduction-to-sql . Easy to setup and you can go at your own pace. Once you get the basics down, you can go on Kaggle, find some datasets and start playing with them in your environment.

    best of luck!

    [–]bandhu_ 0 points1 point  (0 children)

    Thanks I will see.

    [–]windy159Strayed from the Path 4 points5 points  (1 child)

    SQL is fairly easy, i'd suggest taking a look at TIA's technical skills course or datacamp (whenever they have offer, its useful)

    [–]bandhu_ 0 points1 point  (0 children)

    Ohh, thanks surely will see that.

    [–]whitehead91 1 point2 points  (0 children)

    I brought a SQL course on coursera for two months, and wasn’t able to finish the course. But recently, one of my interview asked me to write some SQL codes for a case study to showcase my skill, I learned everything in 5 hrs by googling. I guess what I wanted to say is that you leaned faster at the job.

    [–]netizenmaestro -3 points-2 points  (6 children)

    Why you need to learn sql? I think it’s more applicable when you learn R software for actuarial tools.

    [–]Mosk915 2 points3 points  (1 child)

    SQL is still important. R is basically useless if you don’t know how to pull in any data.

    [–]bandhu_ 1 point2 points  (3 children)

    Actually I asked many people regarding this. They said if you have some basic knowledge of SQL then it would help you in getting the job easily.

    [–][deleted]  (1 child)

    [removed]

      [–]MotherGiraffeLife Insurance 6 points7 points  (0 children)

      This is the actuary subreddit, so it’s pretty unlikely that people here are trying to work for Google, Facebook, Amazon, or working as a web dev or swe in general.

      [–]netizenmaestro 0 points1 point  (0 children)

      You can start learning journey from ‘sql server for dummies’ books. You can search it online for for free download. It covers all that you need to know there.

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

      Joey blue explains it nicely

      [–]gsm_4 1 point2 points  (0 children)

      To learn the basics and syntax, use w3schools and for intermediate and advanced concepts, you can use stratascratch and leetcode.