Introduction to SQL Programming for Excel Users Part 1 - Overview

SQL is a critical skill for any aspiring analytics and data science professional and you can use your Excel knowledge to learn SQL programming. If you've been looking for content on SQL for beginners, this is it!

In this SQL tutorial series I will cover the 20% of SQL programming that is 80% useful for business analytics.

Not only will you learn super useful business analytics techniques like RFM and Pareto analysis, but you will also learn critical aspect of SQL for data analysis like:

- JOINS
- GROUP BY
- CASE WHEN
- SQL window functions
- And more

Make no mistake, SQL is a top skill for ANY professional looking to have more impact at work with business analytics.

-----------------------------------------------------------------------------------------------------------------------
Excel Analytics Training
-----------------------------------------------------------------------------------------------------------------------
👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

Stay healthy and happy data sleuthing!

#SQL #SqlProgramming #SqlTutorial #SqlForBeginners #SqlForExcelUsers

[DaveOnData]

👩‍🔬👨‍🔬 Learn to use your basic Excel skills to analyze the business like a Facebook data scientist:

[shabchique]

Bless your heart for wanting to teach the whole world 🥰🤗

[AB-kymg]

Thanks Dave - really excited to get stuck into this. AB, London, UK

[BolajiBI]

Hi Dave. Thank you for putting this together. Really excited to begin learning.

I've got a question. I already have MySQL installed on my laptop. Would I be able to follow along with the tutorial or I have to get T-SQL that is used in the tutorial.

[mandarvaidya]

superb! I watched ur R tutorial Opinionated Science where u taught basics of data science using R language .Loved it .Thanks for making this sql series

[maor]

Thank you Dave, looking forward for the videos !

[JimRohn-uc]

Thank you so much for this! You’re a blessing!

[kellymahoney]

Looking forward to combining chocolate and peanut butter

[scguy]

So translating common language in job desciptions - if I read a job description that ask for sql then to what version are they most likley asking? Not an IT postion but more likely data anaylsis

[Serraomomma]

Thank you! I haven't finished this video and I want to Thank You again! Thank You Again!

[tombouie]

Thks & just a quick naive question:
Background: I'm a retired physicist. I never had time but I always wanted to do simple scientific programming directly within SQL (instead of exporting the data out of SQL into a spreadsheet).
In a nutshell I always wanted to do data flow modeling directly within the SQL database butr never had the spare-time to figure it out. I'm retired now & have time to finally figure this out.
1 ??Does SQL have most the basic math functions found on a typical scientific calculate??
2 If-so, ??Do you see any practical reason I can't do data flow modeling direction within an SQL database???

[bouhdibanacer]

God bless you our super teacher master for this excellent tutorials
Yr great