Introduction to SQL Programming for Excel Users Part 2 - Basic Tables

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:

[PanFryedEgg]

05:35 - this is the right way - expalining too basic and clear is far better than just for benefitting the intermediate and will attract far more followers, thanks for this video

[jean-marcherard]

Congrats for this great content.
12:56 it is soooo important to remind users what´s behind an excel date column.
Excel gives each date a numeric value starting at 01/01/1900.
So 01/01/1900 has a NUMERIC VALUE of 1, 02/01/1900 has a NUMERIC VALUE of 2 and so on.

[AkshayPatil-sikz]

Thank you Dave for doing this. I am following your posts on Linkedin for a while but learning directly from you on Youtube is great!

[joaliveira]

Congratulations for the channel Dave, long time searching for content like you do!

[srinivaskadiyala]

Thank you David, Started with this series today.

[divaypoddar]

Thanks! Very useful both in terms of excel & SQL!

[meganzhang]

Thank you for making these videos ! I have good excel and want to learn SQL

[briangara]

Thank you Dave. I am trying to become a data analyst and I really enjoy using Excel. It giid to know its transferable. I also need to learn Tableau and Pyrhon but that will be later on.

[marvinlomo]

Thanks Dave. Really enjoying the lessons.

[webpkric]

Thank you for doing this series. Very useful content. 1 suggestion though, audio setup not the best. Difficult to hear when you speak softly.

[tdtrieu]

hi dave, i don't see the adventure db in the microsoft sql server under the databases, am i missing a step? Only system databases and database snapshot shows up?

[Quinley]

Can someone explain how the SQL got the data from the excel table ? was the excel on the same cloud ?

[sobanahmad]

Thanks Dave, when is the next one coming out?

[johnkaruitha]

@Dave langer this is my very first interaction with SQL. Hoping to glean something

[ridohconcepts]

Thanks Dave, how can I access the SQL file please, so as to follow along