Introduction to SQL Programming for Excel Users Part 10 - Basic CTEs

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:

[rpopecpa]

Dave, I now see what you are so excited about. This is awesome. Great video. I love it!!

[Hgghjhfdfg]

Day 2 of learning SQL - mind blown with the combo of windows and CTE's =D
This will help save so much processing power & time in my BI tools!

[ryanbarger]

Great intuitive explanation of CTEs coming from an excel background!

[northscottsdale]

Great video for those of us with good excel skills needing to upgrade. Recommended.

[zubairso]

Wow the series keeps getting interesting by the day!

[ptiwari]

hi dave, are there any recommendations for practice problems website to practice using these concepts?

[jean-marcherard]

We can not ask for a clearer explanation!