Comments on: SQL for Data Analysis – Tutorial for Beginners – ep1 https://data36.com/sql-for-data-analysis-tutorial-beginners/ Learn Data Science the Hard Way! Wed, 11 May 2022 21:47:47 +0000 hourly 1 https://wordpress.org/?v=6.7.4 By: Tomi Mester https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-191043 Mon, 02 Nov 2020 14:38:55 +0000 https://data36.com/?p=1026#comment-191043 In reply to lydia.

cheers

]]> By: Tomi Mester https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-190895 Sun, 18 Oct 2020 20:23:32 +0000 https://data36.com/?p=1026#comment-190895 In reply to Roja Priya.

you got it

]]> By: The Best Programming Languages for Digital Marketers https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-167248 Tue, 14 Jul 2020 13:12:14 +0000 https://data36.com/?p=1026#comment-167248 […] Get started with: SQL For Data Analysis Tutorial Series […]

]]> By: SQL current date (and time, month, year, etc.) in postgreSQL https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-137436 Mon, 06 Apr 2020 09:18:17 +0000 https://data36.com/?p=1026#comment-137436 […] SQL for Data Analysis – Tutorial for Beginners – ep1 […]

]]> By: lydia https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-127450 Thu, 27 Feb 2020 06:22:02 +0000 https://data36.com/?p=1026#comment-127450 This was very useful for analyzing data.

]]> By: How to Use Cohort Analysis to Ensure Your Loyalty Program's Success https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-78720 Wed, 29 May 2019 08:16:39 +0000 https://data36.com/?p=1026#comment-78720 […] or by setting up a script to do the calculation on your data server automatically (if you’re interested, here’s an article of mine about SQL for Data analysis) […]

]]> By: Tomi Mester https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-43031 Fri, 05 Oct 2018 22:56:54 +0000 https://data36.com/?p=1026#comment-43031 In reply to Suvina Shrimal.

hey Suvina,

yes, from SQL perspective, your answer is actually a bit better than mine. (The best practice is never use the * but specific columns – but I’ll get back to that in ep4.)
From business perspective, it won’t be a question in real life… You will always know what columns you have to select to get an actual business value from your SQL query. (Eg. in this case – for me – it made more sense to see every info about the first 3 zebra and not just that they are zebra. But the task wasn’t 100% clear on that. :-))

Anyway: way to go!
Enjoy the rest of the articles!

Cheers,
Tomi

]]> By: Suvina Shrimal https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-43027 Fri, 05 Oct 2018 22:46:50 +0000 https://data36.com/?p=1026#comment-43027 Hello Tomi,

Thank you for amazing course. I have just started on SQL for data analysis and came across the first Test Yourself. This may be a silly question from my end but the assigned question is :

Select the first 3 zebras from the zoo table!

It does not ask for all columns or specifc column, is it a better way to assume using SELECT * (or all columns)?

my answer was:

SELECT animal FROM zoo WHERE animal =’zebra’ LIMIT 3;

Does not make much difference at small dataset but what would be the best practice?

Thanks,
Suvina

]]> By: Roja Priya https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-42833 Thu, 04 Oct 2018 11:23:28 +0000 https://data36.com/?p=1026#comment-42833 Thanks

]]> By: Trong Nguyen https://data36.com/sql-for-data-analysis-tutorial-beginners/#comment-30601 Sat, 04 Aug 2018 02:52:33 +0000 https://data36.com/?p=1026#comment-30601 Wow, another good course. Easy to follow and very helpful.

]]>