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
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 ❤️.
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
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.
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.
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!
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! 👍
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
I'll share this resourceful information on my IG and all my pages for people to find you here.... this is a well organized tutorial I never get to watch and put in practices as real class, now i have book and a pen 😂😂Thank you Alex you're amazing.
Hi Alex, Thanks for your tutorial! Your videos are very helpful. You are very organized and deliver concepts clearly that are easy to follow and understand. Thank you again!
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!
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.
Hey Alex! I'm just on the 6th video but I'm really excited already for what's ahead. You teach so well. I'll be here soon to give you my success story 😊❤🎉
12:25 I ran this query and my result shows 2 lines of Leslie, any idea why? Also, I have tried with the ; and without ; but results are all same, showing 2 lines of Leslie.
Hey alex, for calculation () is fine but what is the use for string values for instance //// where (first_name like 'Les%' and salary = 75000) or salary
Thanks for this Alex, wanted to ask as you mentioned if one may need to focus on the SQL part...can they claim the certificate without having to touch on the rest of the courses?
Can I ask a good Samaritan to explain to me what difference does it make to use parentheses? For example, while watching this video I tried myself a similar exercise: SELECT * FROM parks_and_recreation.employee_demographics WHERE (first_name= 'Andy' AND age= 34) OR age = 40 Or SELECT * FROM parks_and_recreation.employee_demographics WHERE first_name= 'Andy' AND age= 34 OR age = 40 Result was exactly the same. I do understand what the PEMDAS rules are about, it's just I'm trying to figure out a practical use for this? Thanks !
mine didnt come with developers option when installing , i am windows i took full option , now i try to run the where function but it keeps saying no database selected how do i select database
You can double tap on the DB shown in the left hand side column "parks_and_recreation" and make sure it gets bold or you can just write the command "use parks_and_recreation" to use the DB.
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
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.
![Seungmin "그렇게, 천천히, 우리(As we are)" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/kAzmhLHePqU/mqdefault.jpg)
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
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 ❤️.
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
Brilliant! Congratulations! Such comments truly motivates me to persevere further on this path.
This lesson is about:
using "Where" to filter data. (example where column_name = value)
using =, >=,
thanks
Hey Alex,
you've made it! Now, our teachers use your videos to teach us, making you quite famous in Canada.
That's great!
omg alex is explaining sql much better than most university lecturer. great ! thanks!
Been very hesitant.. but watching a few of your videos made me realize it isn't that complicated. huge thanks to you Alex!
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.
A HUGE THANK YOU ALEX!!!!!!!!! I have no words to express, thats really helpful!!!!!
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.
Day 2 learning and practicing about Data Analyst, Thank you Alex!!
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
Same here!!
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!
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! 👍
I’m currently doing a Coursera certification course and it’s not at ALL as helpful for skill building as these videos. Thank you!!
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
Me too, I come here for brighter knowledge
yeah and the lessons and videos are boring. but Alex videos make me motivated
Thank you, Alex! On my journey to become a data analyst every single video you have made has been of great value.
The best teacher for sql tbh I’m doing the charlotte chaze cert and I feel like I understand Alex more!
I'll share this resourceful information on my IG and all my pages for people to find you here.... this is a well organized tutorial I never get to watch and put in practices as real class, now i have book and a pen 😂😂Thank you Alex you're amazing.
Hi Alex, Thanks for your tutorial! Your videos are very helpful. You are very organized and deliver concepts clearly that are easy to follow and understand. Thank you again!
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!
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.
wow database is actually so so convenient and useful! i really hope to learn this
Alex you're the best, love from student in saudi arabia
Your courses are very interesting and you give much explanations. Thank you very much.
Complete the bootcamp is one of my goals to the 1st trimester of 2025. I am focusing on landing a job as Sustainability data analyst!
Keeping it consistent thank you for the lessons!
Hey Alex!
I'm just on the 6th video but I'm really excited already for what's ahead. You teach so well.
I'll be here soon to give you my success story 😊❤🎉
12:25 I ran this query and my result shows 2 lines of Leslie, any idea why? Also, I have tried with the ; and without ; but results are all same, showing 2 lines of Leslie.
2:01 bro just wanted to make a tom and jerry pun
Love from India 🇮🇳
Tom & Jerry with 50000 😍
this is perfect professor Alex! Thank u thank u
Hi Alex,
Thank you very much for your time and effort.
On 7:06 shows an x on select and won’t let me press the lightning bolt. Can someone let me know what’s wrong
Now I see why everyone talks about Alex the Analyst!
why it is showing a null record in the end? 4:31
Hey alex, for calculation () is fine but what is the use for string values for instance //// where (first_name like 'Les%' and salary = 75000) or salary
thanks Alex for the good tutorial . where can we get the csv data you have used ?
Thanks for this Alex, wanted to ask as you mentioned if one may need to focus on the SQL part...can they claim the certificate without having to touch on the rest of the courses?
Thank Your For Teach Us 😇
Thank you!
✅complete
Can we edit the data inside the compiler, if the data was mistaken somewhere?
Hi alex create a video on how sql is benefitted for HR.
hi where can i find the dataset to this tutorial andsubsequent mysql tutorials pls?
why it return only one row?
use parks_and_recreation;
select *
from employee_salary
where first_name = 'Ron' or 'Tom'
when i copy and paste SELECT *
FROM
WHERE
it does not work, can anyone help me figure out what am I doing wrong? please!
and it does have ; included
Try restarting your workbench
I'm running into the same issue.
Me too😢
How do I write the where clause you wrote at the top ?
When I do select from employee salary it gives me an error
So helpful content
Trying to do the where clause but when I run it it's saying employee_salary doesn't exist
Tom & Jerry is a pleasant coincidence!
Thank you so much sir
Can I ask a good Samaritan to explain to me what difference does it make to use parentheses?
For example, while watching this video I tried myself a similar exercise:
SELECT *
FROM parks_and_recreation.employee_demographics
WHERE (first_name= 'Andy' AND age= 34) OR age = 40
Or
SELECT *
FROM parks_and_recreation.employee_demographics
WHERE first_name= 'Andy' AND age= 34 OR age = 40
Result was exactly the same.
I do understand what the PEMDAS rules are about, it's just I'm trying to figure out a practical use for this?
Thanks !
mine didnt come with developers option when installing , i am windows i took full option , now i try to run the where function but it keeps saying no database selected how do i select database
You can double tap on the DB shown in the left hand side column "parks_and_recreation" and make sure it gets bold or you can just write the command "use parks_and_recreation" to use the DB.
Thanks Alex
excute statment under keyboard is not working while giving run anyone help me
Bless you man
Thanks! Parks and Rec
Any Black Friday sale? )))
Alex The Analyst please I didn't understand how the data was been generated if you can help me with it
watch from the begining
Weird episode of Tom and Jerry
New adhd hyper fixation 👍
Great 👍
Aqui aprendemos a realizar busquedas filtradas
THANKS
Thank you
Hello, Done.
Please try to make 10 minutes video, these videos are perfect to understand a topic🎉
Saya agak sulit memahami bahasa ingris, kalau bisa aktifkan subtitel indonesia nya kawan. Hal itu akan sangat membantu saya
lost it at tom and jerry
Hey! When i am using Select two times it shows error on my second select statement. I dont know why. Can someone help???
put ; on the next row
thanks
❤
done
great thanks
SO many ITs. Dont worry, the Junior Era in IT sector is over.
Could you elaborate?
Thank you so much for patiently explaining everything in detail.
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
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.
I had the same problem. You may be missing the ; (semicolon) after the WHERE line of text.
Love from India 🇮🇳