Where Clause in MySQL | Beginner MySQL Series

Full MySQL Course: www.analystbuilder.com/course...
In this lesson we are going to take a look at the Where Clause 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

Пікірлер: 43

  • @akinsinasegun2379
    @akinsinasegun23796 ай бұрын

    I have a knowledge of it, but the way you are simplifying it and touching every nitty-gritty of it is making me understand better and wanting to just delete what i had known before and stick to yours. Thank you Alex

  • @Mjagcayab
    @Mjagcayab6 ай бұрын

    Hey Alex! I wanted to say a big thank you for your amazing tutorials. Your videos were a major part of my journey, and I'm thrilled to let you know that I've landed my dream job as a Data Scientist today. Your clear and insightful teachings gave me the skills and knowledge I needed for success in this field. I feel incredibly lucky to have learned from you, and I'm truly grateful for the positive impact you've had on my career. Fun fact: I didn't even have my final interview with the senior manager-they saw how well I aced my technical exam with SQL. I'm genuinely overjoyed right now. Sending love from Philippines ❤️.

  • @muthuranimm6821

    @muthuranimm6821

    8 күн бұрын

    Hi sir could you please share your experience in which platform you prepared for interview give some suggestions im a fresher and Im actively seeking for fresher DA role please help me sir

  • @transplantman2287
    @transplantman22875 ай бұрын

    I’m currently doing a Coursera certification course and it’s not at ALL as helpful for skill building as these videos. Thank you!!

  • @nelu114

    @nelu114

    10 күн бұрын

    100% I was using DataCamp and at one point although I understood the logic, it just becomes overwhelming and goes over your head as you have to read a lot and the courses are not necessarily intuitive like how Alex explains things. I think I am finally going to stick to learning SQL without giving up because of Alex

  • @sweetnessfuwela4882
    @sweetnessfuwela488215 күн бұрын

    Hi Alex I'm a begginer in data analytics, I was so scared that I've wasted my money and time, but your videos are God sent,I am so grateful I found them,things are more clearer now. Thank you so so much for your tutorials they are a great help.

  • @Meej88
    @Meej886 ай бұрын

    Hey Alex, you've made it! Now, our teachers use your videos to teach us, making you quite famous in Canada. That's great!

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

    Thank you Alex, so insightful cant wait to update you on the job search. Recently completed the Google Data Analytics Certification, your channel has become an incredible recourse for me to use. You're killing it man!

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

    Alex, I appreciated the refresher regard the WHERE clause in MySQL. Good to be going over this info again. Getting the basics down solidly represents a firm foundation for future learning. Thanks again! 👍

  • @marinavasileva340
    @marinavasileva3403 ай бұрын

    A HUGE THANK YOU ALEX!!!!!!!!! I have no words to express, thats really helpful!!!!!

  • @gestr4125
    @gestr41256 ай бұрын

    Hey Alex, I have recently decided to transition to Data Analytics and your content is helping so much! I am working on my portfolio with your guidance and I hope to land a job soon.

  • @nelu114
    @nelu11410 күн бұрын

    Hi Alex! You are really transforming lives with these videos as these open up so many opportunities for people like me. Hope good things continue to come your way for doing this!

  • @xmanncoko4639
    @xmanncoko463921 күн бұрын

    Hello Alex i am a begginner on the Data Analytics space and for me watchin this videos give me a great insight ..i am gona watch all the tutorial up until i obtain my data analytics certification.

  • @user-lm7cj4bv3u
    @user-lm7cj4bv3u6 ай бұрын

    Alex you're the best, love from student in saudi arabia

  • @tessjune88
    @tessjune886 ай бұрын

    Great video! I started learning sql earlier this year and already have an understanding of these but it is still helpful to hear how you explain it

  • @KC-hk2ub

    @KC-hk2ub

    6 ай бұрын

    Same here!!

  • @user-db4nh9wq4y
    @user-db4nh9wq4y6 ай бұрын

    Love from India 🇮🇳

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

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

  • @Rajkumar-tf6qr
    @Rajkumar-tf6qrАй бұрын

    Thank Your For Teach Us 😇

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

    Hi alex create a video on how sql is benefitted for HR.

  • @sylviengono9606
    @sylviengono960627 күн бұрын

    So helpful content

  • @ogollaogolla7
    @ogollaogolla76 ай бұрын

    Bless you man

  • @user-lm9di2cw2z
    @user-lm9di2cw2z4 ай бұрын

    hi where can i find the dataset to this tutorial andsubsequent mysql tutorials pls?

  • @akintundesanyaolu2769
    @akintundesanyaolu27696 ай бұрын

    Thank you

  • @peterdavid-hy6yg
    @peterdavid-hy6yg6 ай бұрын

    THANKS

  • @caitlinmendex
    @caitlinmendex28 күн бұрын

    How do I write the where clause you wrote at the top ?

  • @adwaamohamed2674
    @adwaamohamed26744 күн бұрын

    great thanks

  • @ivanoska13
    @ivanoska134 ай бұрын

    Thanks! Parks and Rec

  • @PlayerOne-GT
    @PlayerOne-GT5 ай бұрын

    Great 👍

  • @pantomima5841
    @pantomima58416 ай бұрын

    Any Black Friday sale? )))

  • @RyanaQuadir-fz6eq
    @RyanaQuadir-fz6eq9 күн бұрын

    Tom & Jerry with 50000 😍

  • @Yaadballgame876
    @Yaadballgame8769 күн бұрын

    when i copy and paste SELECT * FROM WHERE it does not work, can anyone help me figure out what am I doing wrong? please!

  • @Yaadballgame876

    @Yaadballgame876

    9 күн бұрын

    and it does have ; included

  • @lillypop49
    @lillypop4926 күн бұрын

    New adhd hyper fixation 👍

  • @kusumadhony7797
    @kusumadhony779719 күн бұрын

    Saya agak sulit memahami bahasa ingris, kalau bisa aktifkan subtitel indonesia nya kawan. Hal itu akan sangat membantu saya

  • @northremembers5455
    @northremembers54556 ай бұрын

    Please try to make 10 minutes video, these videos are perfect to understand a topic🎉

  • @judilynlojera8554
    @judilynlojera85546 ай бұрын

  • @Vlath
    @Vlath6 ай бұрын

    SO many ITs. Dont worry, the Junior Era in IT sector is over.

  • @ridorock6

    @ridorock6

    6 ай бұрын

    Could you elaborate?

  • @efenewton778
    @efenewton7782 ай бұрын

    Great work Alex. Really appreciate this.. However, i have been trying to get that command.."From employee demographics." Keeps giving me error codes. Until I use, From parks_and_recreation.employeedemographics. I don't know why. Can someone help out please

  • @Vortixx

    @Vortixx

    19 күн бұрын

    I don't know if you still want an answer, but it might be because you haven't selected the "parks_and_recreation" database in the Schemas section. So you have to specify the database in the FROM statement.

  • @biancafraise578

    @biancafraise578

    16 күн бұрын

    I had the same problem. You may be missing the ; (semicolon) after the WHERE line of text.

  • @user-db4nh9wq4y
    @user-db4nh9wq4y6 ай бұрын

    Love from India 🇮🇳