Group By + Order By in MySQL | Beginner MySQL Series

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at Group By and Order By in MySQL!
GitHub Code: github.com/AlexTheAnalyst/MyS...
____________________________________________
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.io/5bBd62
📖Data Analysis with Python - coursera.pxf.io/BXY3Wy
📖IBM Data Analysis Specialization - coursera.pxf.io/AoYOdR
📖Tableau Data Visualization - coursera.pxf.io/MXYqaN
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/AlexTheAnalyst
📱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

Пікірлер: 22

  • @user-kq3tc5tu1c
    @user-kq3tc5tu1c10 күн бұрын

    Alex, this series on MySQL is really polished, no hiccups at all. Also appreciate your GitHub repository where I can also follow along with your SQL files. It's great to see SQL syntax that just works the way it is supposed to. I also appreciate the occasional "best practice" you share (i.e. Normally using proper column names in the GROUP BY clause vice column numbers, etc.) Working smart, not hard ALWAYS appeals to my brain. Thanks again for the awesome content! 😉

  • @elizabeth00653
    @elizabeth006534 ай бұрын

    I love this tutorial, crystal clear, useful examples, straight to the point!

  • @inq_3166
    @inq_31665 ай бұрын

    Thank you Alex. I Just started learning data analytics with your bootcamp playlist and currently I am a little bit confused whether I continue learning the SQL part or jump to excel part and at the same time keep following this MySQL serie. I'm thinking about doing it all because I'm still a rookie and I have to learn. I will be happy to hear your suggestion. And thank you once again Alex for you content.

  • @duurduranto
    @duurduranto5 ай бұрын

    loving the lessons. Waiting for the rest.

  • @ashtonwilson4976
    @ashtonwilson49762 ай бұрын

    This was very helpful! Thank you so much!

  • @uwayojacques317
    @uwayojacques3175 ай бұрын

    thanks Alex for the good tutorial . where can we get the csv data you have used ?

  • @kaltoumrachdi2086
    @kaltoumrachdi20865 ай бұрын

    Thank u sooo much alex for this video

  • @maximillianquaife-larsen3799
    @maximillianquaife-larsen3799Ай бұрын

    Fantastic cvid

  • @mozammilalam3063
    @mozammilalam30635 ай бұрын

    Alex, hello! 🚀 I wanted to be the first to comment and say how much I appreciate all of the amazing content you make! 🙌 Your ability to analyze things is impressive. I would adore the chance to collaborate with you and add to your wonderful projects. I am sure that I can contribute useful expertise. Just a quick intro about me, I am an analyst with almost 3 year of experience Let's talk about how I can benefit the team as a new member! 🌼 #TeamAlex

  • @leovaldan
    @leovaldanАй бұрын

    What happened? Last night I started this bootcamp using SQL Server and today all SQL videos are explained using MySQL

  • @envyivory8202

    @envyivory8202

    26 күн бұрын

    I noticed the same thing

  • @cjbrown3396

    @cjbrown3396

    24 күн бұрын

    MySQL is more popular and use-wise. THat's why.

  • @areejkhairi3495

    @areejkhairi3495

    22 күн бұрын

    also happened to me 😢

  • @ojikutuaishatomolara4132

    @ojikutuaishatomolara4132

    10 күн бұрын

    The boot camp had MSSQL for over 2 years, and the boot camp has just been recently changed to MySQL, I believe this is because it’s widely used, compared to MSSQL

  • @elizabeth00653
    @elizabeth006534 ай бұрын

    Also there doesn't seem to be a way to purchase 1 course at one time, it appears that we have to choose a bundle

  • @AlexTheAnalyst

    @AlexTheAnalyst

    4 ай бұрын

    If you go to the "Pricing" Page there is an option for "Questions, Courses, and Bundles". If you go to Courses you can buy individual courses :)

  • @JJCage78
    @JJCage7829 күн бұрын

    @3:15 You select from employee_salary and group by gender. employee_salary does not have a gender column. I could not get it to work due to the group by request. I also used the select * as you did. The select * would only apply to the employee_salary and not the entire DB since you specified from that table.

  • @florainneh2505

    @florainneh2505

    10 күн бұрын

    Hello, Please I am having the same issue. Please were you able to resolve yours ? if so how ?

  • @JJCage78

    @JJCage78

    4 күн бұрын

    @@florainneh2505 I just skipped it.

  • @Sharky-lu8ie

    @Sharky-lu8ie

    2 күн бұрын

    Hello ! sorry for being late, I think he just wanted to present the fact he was going to group by occupation, what he did is highlight "SELECT * FROM employee_salary" and then ran only those lines with the regular running option (the first bolt icon, not the second one, we can see it on the video if we follow the clicks closely), he didn't actually run the entirety of that code excluding that "GROUP BY gender" , that's how he got it to run. I hope I was clear !

  • @kanchanachristopher5465
    @kanchanachristopher54655 ай бұрын

    Alex create a video on how sql is benefitted for hr's am messaging for a second time