{"id":1160,"date":"2017-07-10T22:07:45","date_gmt":"2017-07-10T22:07:45","guid":{"rendered":"https:\/\/data36.com\/?p=1160"},"modified":"2024-02-14T19:02:10","modified_gmt":"2024-02-14T19:02:10","slug":"sql-join-data-analysis-tutorial-ep5","status":"publish","type":"post","link":"https:\/\/data36.com\/sql-join-data-analysis-tutorial-ep5\/","title":{"rendered":"SQL for Data Analysis – Tutorial for Beginners – ep5"},"content":{"rendered":"\n

Combining tables is a key component in data science and analytics. And SQL is really good at it! Of course each case is different, but I run into data science tasks all the time in which joining two multi-million-row data tables took ~20-30 minutes<\/em> in Python<\/a> or bash<\/a>… and not more than ~10-20 seconds in SQL.<\/strong> I\u2019m not saying I couldn\u2019t have done those tasks in Python or bash at all\u2026 But for sure SQL JOIN was the easiest and fastest solution!<\/strong><\/p>\n\n\n\n

So let\u2019s learn how to use SQL JOIN to step up your analytics projects!<\/p>\n\n\n\n

Note: to get the most out of this article, you should not just read it, but actually do the coding part with me! So if you are on the phone, I suggest saving this article and continuing on your computer!<\/em><\/p>\n\n\n\n

But before we start\u2026<\/h2>\n\n\n\n

\u2026 I highly recommend going through these articles first \u2013 if you haven\u2019t done so yet:<\/p>\n\n\n\n

    \n
  1. Set up your own data server to practice: How to install Python, SQL, R and Bash (for non-devs)<\/a><\/li>\n\n\n\n
  2. Install SQL Workbench to manage your SQL stuff better: How to install SQL Workbench for postgreSQL<\/a><\/li>\n\n\n\n
  3. SQL for Data Analysis ep1 (SQL basics)<\/a><\/li>\n\n\n\n
  4. SQL for Data Analysis ep2 (SQL WHERE clause)<\/a><\/li>\n\n\n\n
  5. SQL for Data Analysis ep3 (SQL functions and GROUP BY)<\/a><\/li>\n\n\n\n
  6. SQL for Data Analysis ep4 (SQL best practices)<\/a><\/li>\n<\/ol>\n\n\n\t\t
    \n\t\t\t\t\t
    \n\t\t\t\t\t\t\t
    <\/div>\n\t\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t

    How to Become a Data Scientist
    (free 50-minute video course by Tomi Mester)<\/h4>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    Just subscribe to the Data36 Newsletter here (it’s free)!<\/span><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t