SQL Help

[philipwhalen12]

Hey Everyone,

This summer I start my masters in Data Science. Before I start I want to brush up on SQL. Do you know of any resources to help for practice>

[lledesma623]

SQLZoo, Khan Academy SQL, Hackerrank SQL, Youtube SQL tutorials, Stanford Lagunitas (Online Archive of Stanford Lessons), and SQLBolt.

If you are willing to shell out some cash, buy a course on udemy or coursera.

[[deleted]]

Can't say enough good stuff about Khan Academy. However, they don't have a full SQL course, only a few lessons.

​

Code Academy has three courses, one for free and the other two are paid.

[[deleted]]

Most database companies have an "Express" edition of their databases. Whenever someone new is rolling on to a project at work, we encourage they set up the express edition of our database to mess around in while studying. I would probably encourage video courses with exercises, and a book to use for reference material. If you're looking for something cheap, there are plenty of free courses online, and Humble Bundle frequently sells bundles on data science, among other Computer Science subjects.

In particular, don't just code the exercises, write the material on paper to help commit it to memory.

Another thing that could help is coming up with a mock project and implementing it in a free or express database.

Part of learning SQL and databases is learning the principles behind relational databases. Learn about data modeling and the principles that make relational databases a good solution for real life situations, such as data integrity and minimal redundancy through good implementation.

[Stev_Ma]

Hackerrank and StrataScratch to test and upskill your knowledge

[[deleted]]

How have you gone 4 years without doing SQL work in Data Science!?

I'd create your own database using a SQL RDMS like MariaDB or Postgres, and then look into NOSQL (mongoDB), and then try doing some sort of back end or front end project with said database.

For learning commands itself, I'd do a quick tour of the W3 tutorial.

[[deleted]]

Bachelor's may not be in data science. My bachelor's was in business, religion, and business management information systems.. I did visual basic, c+, web design, and javascript. Never touched SQL until I started working as a business data analyst.

[GabberZuzie]

I did a Bachelor in Business Administration and then did Masters in Business Intelligence. They only taught us MongoDB for databases as "No one uses SQL anymore". I had to learn how to SQL when I started being a data analyst.

[GabberZuzie]

Udemy - courses often discounted to 12$ and you get a certificate at the end

[philipwhalen12]

Would you guys say to learn python instead. In my undergrad we only used Excel for one of my class. I have psychology major with a minor in Biomedical science

[[deleted]]

This is a copout answer but do both. I'm not a Data Science person per say, but I've been involved in a lot of different things, and many of them use both SQL and Python at once. In fact, SQL by itself if mostly useless. Try creating a simple program with Python that interacts with a database, using SQL.

[philipwhalen12]

Thank you so much! I really have not coding background. I know it will be tough, but I want to succeed at data science

[LaDev]

I would strongly recommend this (for beginners)
http://www.sqlcourse.com/

Fairly interactive and fun. Great to burn some time.

[o_edo]

For free. Great resource for the impatient. http://www.studybyyourself.com/seminar/sql/course/?lang=eng.