Window Functions in MySQL | Intermediate MySQL

Full MySQL Course: www.analystbui...
In this lesson we are going to take a look at Window Functions in MySQL!
GitHub Code: github.com/Ale...
____________________________________________
SUBSCRIBE!
Do you want to become a Data Analyst? That's what this channel is all about! My goal is to help you learn everything you need in order to start your career or even switch your career into Data Analytics. Be sure to subscribe to not miss out on any content!
____________________________________________
RESOURCES:
Coursera Courses:
📖Google Data Analyst Certification: coursera.pxf.i...
📖Data Analysis with Python - coursera.pxf.i...
📖IBM Data Analysis Specialization - coursera.pxf.i...
📖Tableau Data Visualization - coursera.pxf.i...
Udemy Courses:
📖Python for Data Science - bit.ly/3Z4A5K6
📖Statistics for Data Science - bit.ly/37jqDbq
📖SQL for Data Analysts (SSMS) - bit.ly/3fkqEij
📖Tableau A-Z - bit.ly/385lYvN
Please note I may earn a small commission for any purchase through these links - Thanks for supporting the channel!
____________________________________________
BECOME A MEMBER -
Want to support the channel? Consider becoming a member! I do Monthly Livestreams and you get some awesome Emoji's to use in chat and comments!
/ @alextheanalyst
____________________________________________
Websites:
💻Website: AlexTheAnalyst.com
💾GitHub: github.com/Ale...
📱Instagram: @Alex_The_Analyst
____________________________________________
All opinions or statements in this video are my own and do not reflect the opinion of the company I work for or have ever worked for

[@emmanuel.mireku]

I am learning data analytics completely on KZbin and I must say that you guys are good❤

[@cjbrown3396]

what other sources are you doing on KZbin as well? would you mind sharing

[@emmanuel.mireku]

@@cjbrown3396 sorry for the late reply Bro. I also learn from simplilearn and wscube. So far so good.

[@emmanuel.mireku]

​@@cjbrown3396simplilearn and wscube please

[@emmanuel.mireku]

​@@cjbrown3396 my recommendation is not showing here. I don't really think it's allowed here

[@emmanuel.mireku]

​@@cjbrown3396my recommendation is not showing here and I don't really know why Bro

[@BruceBeck-f1n]

Yet another "WOW!" lesson for me. Don't think I've ever gotten to WINDOW Functions before. Very cool. I suppose it will all start to make more sense once I start using all of this on a regular basis. Am REALLY glad I figured out how to run an almost current version of MySQL on my macBook Pro in macOS Sonoma. Much simpler than using a VM, etc. Anyway, Alex's courses have always been well worth the time I invest. Thanks for putting up quality content Alex!

[@thewryreport]

Awesome, thanks so much! Really appreciate seeing non-basic tutorials! Love learning new things!

[@jyothsnan999]

The concepts are explained beautifully! Thank you! 😊

[@Joseph__ebube]

Omg I really enjoyed this lecture honestly speaking to you. Thank you 🙏🙏

[@rage_roxy421]

🙌🏽 😂 I love the sample names. Thank you for the videos!

[@AhmdsYT]

We demand to have Lil' Sebastian next time! 🤣

[@zeinh5139]

awesome!!! thank you very much, now it makes sense and i really understood it well

[@darrenz2408]

Extremely organized and well explained🎉

[@dineshchellaiahc4588]

1st half video, I am clear about these functions. I decide to skip this video but after that I get clearance for those functions. Thank you, sir...

[@MsAisaule]

Very good! Explained clearly, simple.Very organized!

[@InspireToday797]

Alex the Analyst! You are the very best teacher!!!

[@stephenwagude9330]

I loved this session, you really kept it simple alex

[@katiebarnwell7278]

Great simple video! Thanks, Alex!

[@yeniramirez911]

Thanks Alex, I really appreciate these videos. :D

[@user-dq6eg6yq3j]

Very organized, simple, and clear.

[@moe01]

Great video! Thanks Alex, you made something that seems quite complicated, fairly simple and easy to understand. What are some other use cases for using a Window Function? I've heard having a mastery of these is what folks in the industry use as a gauge to see if someone truly understands SQL.

[@haastrupadebayoibukun6817]

Very clear and useful

[@alienfunbug]

Fantastic video for sure! Thank you!

[@TheeGirl-]

Hi. On your analystbuilder the “on the way out” question, the question says to order the output from oldest to youngest but the answer that will be counted as correct has the answer as ASC. The true answer should be DESC.

[@fuzzwar]

No asc is correct if you do desc then you will get the top 3 youngest not oldest

[@TheeGirl-]

DESC is oldest to youngest. ASC is youngest to oldest.

[@fuzzwar]

@@TheeGirl- you are not understanding the question. Let me break it down, ASC means the values are sorted from smallest to largest (vice versa for DESC). In this case, ordering by ASC for birth_date means from the earliest date (oldest) to the latest date (youngest). Therefore, using ASC will correctly order the output to identify the oldest employees first. hoped this helped

[@TheeGirl-]

Thanks. Makes sense.

[@mbmathematicsacademic7038]

Thank you Alex I like your myql course

[@vighneshutamse]

What are the real life examples for RANK() and DENSE_RANK() functions? How to know where to use which function?

[@tcrawford8430]

Nice!! Whenever you have time could you make a data cleaning video?

[@AlexTheAnalyst]

It's coming :D

[@momohtimothy6898]

Finally understood this lesson.

[@ProXxXify]

Super useful and very clearly explained. Thank you! 🙇

[@faisaladan3455]

yeah😊

[@mutumakimathi]

You make it so simple.

[@ayazqureshi5319]

Useful Content and Very Well Explained.

[@dsd5705]

I am heads down writing a book but as soon as it is done, my next career move is to add data!

[@abhilash6292]

Great example explanation

[@jacquelinesenechal7303]

Loving the tutorials! Quick question - I tried to put in the partition by code, it looks exactly the same as in the video, but I'm getting error code 1064. why isn't it working for me? the main issue: MySQL isn't accepting a parenthesis after OVER.

[@Jan_Be]

You coulduse the using() function for joining

[@checkYourDiet]

Thank You very Much!!

[@ozgunc4735]

Hi Alex, I watch your tutorials, it's really nice and understandable, thanks a lot. I have a problem. Despite it all makes sense when I watch videos, I have hard time to remember these things. So what's your suggestion for making all these knowledge memory, remind it all later as well. I plan to do w3school sql tutorial as well after finishing your tutorial. But if I can get advice from you I'd appreciate.

[@imadethiscuziwsbored]

Ive been taking and adding notes to each tutorial as i follow along in mysql and saving each tutorial as individual sql files so i can reference and review the notes whenever i want to use something in a query! Its been helpful so far. So for example from following this video i have an individual file called “window functions” that i added notes to in the code so then when i want to use window functions i can just open that file and check my notes

[@ozgunc4735]

@@imadethiscuziwsbored thanks yes I will try that

[@omchaudhary8152]

Thank you ! ❤

[@varunchamoli9742]

finally bought course today on pandas, awesome content. But still confused should I go for SQL also?

[@Deepthipaimanoor]

Thanks Alex!

[@MHb789]

Sir,what level of sql solving knowledge necessary for entry level data analytics role?I am not able to build the logic to solve complex problems

[@user-cg9hu8ox3]

So helpful ❤❤❤❤❤❤

[@user-zf3it3vw2e]

thank you

[@zainiichaudhry857]

the code is giving me an error, HELP!!

[@Mr.Arshad-oc1fd]

Why we add dem word with employee table and sal with salary table during join quarrt

[@janvi2294]

That's an alias

[@KasthuriarachichigePrasanna]

great

[@travis37115]

can someone give me the font style and size that he is using on MySQL Workbench?

[@akintimehinmoromoke]

Alex please, i am following your videos 100percent; please the switch is kinda much.. from database to schema. how you got to schema windows please 😥

[@minhajabedin3532]

At the bottom of the interface there are 2 options named with administration and schema. Click on the schema then you will get the schema window

[@blueedm2112]

You are different!!!

[@JigarShah-gk3ew]

select gender, avg(salary) over() from employee_demographics dem join employee_salary sal on dem.employee_id = sal.employee_id; this is throwing a syntax error 1064 . please help

[@rheannalamph3220]

Same for me too...?

[@rheannalamph3220]

I realized it's the version of workbench- I downloaded the 8... version, but when I ran 'Select version();', it shows 5.7.31

[@rheannalamph3220]

I got it working - I had previously installed wampserver - when you open up MySQL Workbench, there were 2 options for me. I had accidentally selected the wampserver version and not the new one. Now I have the correct version and it works :)

[@JigarShah-gk3ew]

@rheannalamph3220 sounds interesting . I am using mamp, maybe I can play around server versions too .. thank you 😊

[@gunjisisters]

Suggest me internship?