Introduction to SQL Programming for Excel Users - SQL Server Windows Setup

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:

[ptiwari]

hey guys, question - i am trying to download SSMS v19.0.2 and every time the download keeps failing. Everything else has downloaded just fine, im not sure why its just this file thats unable to download. Any ideas?

[alexandermaisuradze]

Brilliant way to introduce SQL. I had an opportunity to see the Datacamp course and in the first video they start with select from - while you do not even understand from where you are selecting and what. Your approach is excellent, really pedagogical! Thanks

[jacobm]

Such an amazing teacher. So excited about learning SQL with you thanks, David!

[mdi]

This is EXCELLENT - what a privilege to be taught by a former BI Senior Director! Thank you!

[defr]

Thank you for your videos, David! Im trying to implement R in hospital to create automatic adverse effect reports, and your videos are very inspiring and helpful!

[pavelbiswas]

Hey Guys, a quick update. If you are using windows 8.1 then install windows server 2017 or else it won't work on your machine. David can you please suggest if there are any other alternatives to this at the moment.

[roywit]

This is the ideal channel I been looking!! Just subbed

started excel 5 months ago - with the intention of mastering sql afterwards, then python pandas after that ... long journey ahead, made easier by your content :)

[hiteshjoshi]

Just bumped into your channel u are to the SQL what mike grivin is to the excel
I have learnt advanced excel now SQL later on power bi so my question is your playlist going to be enough I want to be a business analyst rather than a programmer or coder so what should I learn in sql

[iampozyman]

hello, Sir! Thank you very much for your great easy to understand tutorials! I admire each one of them. This video is no exception.

[oviyarp]

Thank you David! This video is very clear and I can able to follow your instructions easily.

[granand]

Hi David, Firstly thank you very much. I was looking for this. Can I ask a few questions
1. I use Dbeaver and connects to all types of databases and excel and I am able to write a few SQL queries, can I use it to save and retreive data from excel
2. Can I Implement this SQL connected Excel on Sharepoint so that I can create forms which multiple users can use ( may be Tkinter / Flask connected to EXCEL / SQL or sorry you love R, which I will run from you, Can I use R language (R based GUI ?) with Excel and SQL as backend ?
3. Can I run above on sharepoint ?
4. What are these two services related to SQL (SQLTELEMETRY & SQLWriter) should I Start/Stop these two services as well ?

Thanks a ton Sir.

[bhaskarjha]

If I need to query cloud database, then do I need to install SQL server dev edition or can I directly use SSMS to query the cloud db?

[marvinlomo]

Super amazing content Dave. Thanks. I am Marvin from Ghana.

[Saaaquib]

Every single thing about you and this video is phenomenal. Followed from the start to the end and it's all worked as intended. Thank you very much!

[abusufiyanmansuri]

Just let you know, you're Awesome.
I appreciate all your efforts you put in to bring out best content for us.

[JimRohn-uc]

Thank you so much for this!

I’m a scientist trying to transition into Data Analytics and I know SQL, tailored my resume to analytics, but I’m still having a hard time finding a entry level Data Analyst position; ive been applying for the past year but then Covid happened.

Would you have any advice for me to break into the field?

Hopefully learning Python or R and Power BI or Tableau will help.

[K-mkpc]

Sir I was working on the R programming project about Titanic in ggplot as you were doing, i wrote the same as you were doing but I got a bug which I couldn't resolve as you mentioned
It says x is discrete and can't initialise w why is that

[evanarchuleta]

Thank you very much for your videos. I appreciate your help so much

[AD-hteb]

Hello Sir, Thank you so much for your knowledge. Do you have a process for MAC?