Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 113 views

    Resources

    Uploaded by

    Syed Misbah
    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.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Resources

    Uploaded by

    Syed Misbah
    113 views2 pages
    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.

    Original Description:

    MRES

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    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.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    113 views2 pages

    Resources

    Uploaded by

    Syed Misbah
    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.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 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