Window Functions in MySQL | Intermediate MySQL
ฝัง
- เผยแพร่เมื่อ 5 ก.ย. 2024
- 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
I am learning data analytics completely on TH-cam and I must say that you guys are good❤
what other sources are you doing on TH-cam as well? would you mind sharing
@@cjbrown3396 sorry for the late reply Bro.
I also learn from simplilearn and wscube. So far so good.
@@cjbrown3396simplilearn and wscube please
@@cjbrown3396 my recommendation is not showing here. I don't really think it's allowed here
@@cjbrown3396my recommendation is not showing here and I don't really know why Bro
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!
Awesome, thanks so much! Really appreciate seeing non-basic tutorials! Love learning new things!
The concepts are explained beautifully!
Thank you! 😊
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...
Extremely organized and well explained🎉
🙌🏽 😂 I love the sample names. Thank you for the videos!
We demand to have Lil' Sebastian next time! 🤣
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.
Very good! Explained clearly, simple.Very organized!
I loved this session, you really kept it simple alex
Very clear and useful
Great simple video! Thanks, Alex!
Alex the Analyst! You are the very best teacher!!!
Nice!! Whenever you have time could you make a data cleaning video?
It's coming :D
Very organized, simple, and clear.
Fantastic video for sure! Thank you!
Thanks Alex, I really appreciate these videos. :D
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.
No asc is correct if you do desc then you will get the top 3 youngest not oldest
DESC is oldest to youngest. ASC is youngest to oldest.
@@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
Thanks. Makes sense.
Super useful and very clearly explained. Thank you! 🙇
Great example explanation
I am heads down writing a book but as soon as it is done, my next career move is to add data!
Finally understood this lesson.
You coulduse the using() function for joining
You make it so simple.
Thank you Alex I like your myql course
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.
Useful Content and Very Well Explained.
Thank you ! ❤
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.
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
@@imadethiscuziwsbored thanks yes I will try that
finally bought course today on pandas, awesome content.
But still confused should I go for SQL also?
Thank You very Much!!
Why we add dem word with employee table and sal with salary table during join quarrt
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
Thanks Alex!
thank you
can someone give me the font style and size that he is using on MySQL Workbench?
So helpful ❤❤❤❤❤❤
great
You are different!!!
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 😥
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
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
Same for me too...?
I realized it's the version of workbench- I downloaded the 8... version, but when I ran 'Select version();', it shows 5.7.31
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 :)
@rheannalamph3220 sounds interesting . I am using mamp, maybe I can play around server versions too .. thank you 😊
Suggest me internship?