0% found this document useful (0 votes)
258 views2 pages

SQL Learning Resources and Guides

The document provides resources for learning data science skills including Python, SQL, R, statistics, and Excel. It recommends interactivepython.org for learning Python and w3schools.com and sqlzoo.net for learning SQL fundamentals. It also lists specific tutorials on calculating customer lifetime value using SQL and pivoting Excel skills to SQL. Books on statistics and links to Quora answers on learning SQL and becoming a data analyst are included.

Uploaded by

Syed Misbah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
258 views2 pages

SQL Learning Resources and Guides

The document provides resources for learning data science skills including Python, SQL, R, statistics, and Excel. It recommends interactivepython.org for learning Python and w3schools.com and sqlzoo.net for learning SQL fundamentals. It also lists specific tutorials on calculating customer lifetime value using SQL and pivoting Excel skills to SQL. Books on statistics and links to Quora answers on learning SQL and becoming a data analyst are included.

Uploaded by

Syed Misbah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

Resources

Most Important: https://getpocket.com/a/read/259106956


http://www.learndatasci.com/best-data-science-online-courses/

1. Python
http://interactivepython.org/runestone/static/pythonds/index.html

2. SQL
Before you learn SQL you need to learn how relational databases work from the
design point of view. Read Tom Jewett's tutorial on database design
http://www.tomjewett.com/dbdesig... for a clear and competent explanation.
Then move on to w3schools' SQL tutorial (http://www.w3schools.com/sql/def...).
You'll review some of the concepts you already learned (which is always a good
thing) and read more about SQL's syntax from a slightly different pont of view.
Dive into practical SQL, create databases mapping some real world cases, learn
how to query for data
Have some SQL expert review your work, this can save you a lot of time
avoiding common mistakes and pitfalls
When you have enough of basics, learn the tricks from the best. If you're into
MySQL I suggest reading http://planet.mysql.com/ and
http://www.hackmysql.com before it's taken offline (the site is not maintained
anymore).

The best way to learn any language, including SQL, is to use it to make progress
toward something you care about. Unless you somehow think SQL is the most
mesmerizing thing in the universe, it's hard to sit down and grok through W3School
and its ilk. Instead, you should find a problem that interests you that requires
some knowledge of SQL.

1. Learn SQL by Calculating Customer Lifetime Value Part 1: Setup, Counting


and Filtering
2. Learn SQL by Calculating Customer Lifetime Value Part 2: GROUP BY and
JOIN
3. Pivot your Excel skills into SQL (Free E-Book)

3. R
4. Stats Books
5. Excel http://www.excel-easy.com/

List of Quora Answers


1. https://www.quora.com/How-do-I-learn-SQL
2. https://www.quora.com/What-should-I-study-or-learn-if-I-want-to-be-a-data-
analyst
SQL & Database
o http://www.w3schools.com/
o http://sqlzoo.net/wiki/Main_Page

R
o http://www.tutorialspoint.com/r/
o https://www.r-project.org/

Statistics
o http://onlinestatbook.com/
o http://www.umjacksonem.net/wp-
content/uploads/2014/08/Complete-Idiots-Guide-Statistics-
2nd.pdf
o https://www.khanacademy.org/math/statistics-probability

Excel
o https://www.youtube.com/playlist?list=PL3FBEE51974F03CCF

Python
o https://www.codecademy.com/learn/python
o https://www.datacamp.com/courses/intro-to-python-for-data-
science

You might also like