Hey Alex, I've been watching your videos for about a year now. I found a lot of your videos very helpful, especially the Portfolio Projects and Resume/Interview stuff. Just wanted to share that I finally got a job as a Data Engineer and I owe you a big THANKS! Keep doing what you're doing, it's all very helpful.
Any tips on landing that first job? I have completed my resume, portfolio website and have started networking through LinkedIn.... I am assuming it is just a numbers game now ?
@@nickl3135There is no secret tips sadly. Just customize your resume to what every key words are on the job posting. If you’re like me and don’t have any prior work experience, then don’t be afraid to put personal projects on your resume. Other than that, it’s just a matter of time.
For how long did you practice sql?I. Know the basics but cannot build up logic and feels like giving up sometimes.Data engineer requires more skills right?How did you acquire them?
For how long did you practice sql?I. Know the basics but cannot build up logic and feels like giving up sometimes.Data engineer requires more skills right?How did you acquire them
Lesson is about: How to select all the rows in a table, How to select some rows in a table, How to preform math operation on a column, How to use the keyword "distinct" to show only the unique values in a table.
Practice makes perfect they say. Didn't note of the data base selection earlier and was having problem practising the subsequent lessons. Great lessons.
Thank you so much Alex!!!! I thought it will be super hard, but with your help it's so understandable!!!! I've already seen your Tableau tutorial and it's great! Thank you so much!
Hi, Mr Alex. I am a beginner when it comes to data analysis, and I have came across your 2023 videos, it's seems they are simple to comprehend than the 2024 . The current videos are too fast. I don't mind if I can have access to that of 2023. Thanks
Are you going to be doing a portfolio project in MySQL? I know thats kind of a lot to ask for, but that would be super helpful because I have had a lot of trouble doing the portfolio project because of the file formats and also being on a mac and also trying to do it on MySQL... Love everything you do, you've been a huge help
I've heard several times you're talking about cloud computing. Can you release a video explaining what we need to learn about cloud as a junior data analyst?
Hello Alex, another excellent video in a VERY long line of fantastic content. Concise and focused content that worked on my laptop EXACTLY how it was depicted on the monitor. That's the way to teach effectively and you have discovered that "secret sauce" a long time ago. Thanks again! 😀
My issue with online courses is that you never get to ask questions, like why do you use column when entering Leslie, or the parenthesis used when calculating. I don't know so it confusing to know when to use it
@@sandraagusti4527 I do like to save it as I go so that if I have to come back the next day or something I can keep going - I also add comments as I go
Help, please 🙏🏿. I have the 3 tables set up, BUT, I can't get the 2nd table to append to the 1st query. It only adds 1 at a time. I do see the tabs above the Navigator line, but I can't get the dual query to execute.
Hi! I’m following along with your MySQL tutorial, and I successfully set up the server and MySQL just like you showed in the first video. However, when I tried to log back into the server the next day, it asked me for a password. I entered the password I set up, but it wouldn’t let me in. I’d really like to keep learning with your videos, but I’m stuck at this step. Do you have any advice on how to solve this? Thanks so much for the tutorials - I’m really excited to learn more!
I have installed and done some amount of work in the application but when i opened the application again after some time it says to reconfigure every time.....any solution please
I successfuly selected data from table but every time when refresh the page it retreive it again and repeat it multiple times in total 585 rows with repeated values
--Video resumido -- Lo mas basico (PD) se pone el nombre completo cuando estamos trabajando con muchas bases de datos SELECT * FROM parks_and_recreation.employee_demographics ; -- Funciones matematicas/ cálculos SELECT first_name, last_name, birth_date, age, age + 10 AS suma FROM parks_and_recreation.employee_demographics ; # PEMDAS -- Para seleccionar cualquier valor diferente/ distinto SELECT DISTINCT first_name, gender FROM parks_and_recreation.employee_demographics ;
how do you get parks an recreation cuz im completely lost i dont have the default option i have deleted an re downloaded this mysql 4 times i dont get it and he is moving kinda fast
After watching the video, I tried some commend lines in the video and error code 1046 occurred. For those who have the same problem, write " USE" commend as "USE parks_and_recreation" before selecting the table. Thank you all 🙏
My issue with online courses is that you never get to ask questions, like why do you use column when entering Leslie, or the parenthesis used when calculating. I don't know so it confusing to know when to use it
Hey Alex, I've been watching your videos for about a year now. I found a lot of your videos very helpful, especially the Portfolio Projects and Resume/Interview stuff. Just wanted to share that I finally got a job as a Data Engineer and I owe you a big THANKS!
Keep doing what you're doing, it's all very helpful.
Any tips on landing that first job? I have completed my resume, portfolio website and have started networking through LinkedIn.... I am assuming it is just a numbers game now ?
@@nickl3135There is no secret tips sadly. Just customize your resume to what every key words are on the job posting. If you’re like me and don’t have any prior work experience, then don’t be afraid to put personal projects on your resume. Other than that, it’s just a matter of time.
For how long did you practice sql?I. Know the basics but cannot build up logic and feels like giving up sometimes.Data engineer requires more skills right?How did you acquire them?
For how long did you practice sql?I. Know the basics but cannot build up logic and feels like giving up sometimes.Data engineer requires more skills right?How did you acquire them
Brilliant! Congratulations!
I don't know how i came across your bootcamp, but its the best thing that has happened to me this year ❤❤.
Thank you Alex
Lesson is about:
How to select all the rows in a table,
How to select some rows in a table,
How to preform math operation on a column,
How to use the keyword "distinct" to show only the unique values in a table.
Practice makes perfect they say. Didn't note of the data base selection earlier and was having problem practising the subsequent lessons. Great lessons.
Alex, you are a gem! Thank you for posting these!
Doing my data analyst basic course and once I'm done there I'm going to watch all your videos and learn. 😅
wow seriously, I m searching for some teaching trainer.Finally i got......Hope will complete all the series without fail. Thank you somuch
Thank you so much Alex!!!! I thought it will be super hard, but with your help it's so understandable!!!! I've already seen your Tableau tutorial and it's great! Thank you so much!
Hi, Mr Alex. I am a beginner when it comes to data analysis, and I have came across your 2023 videos, it's seems they are simple to comprehend than the 2024 . The current videos are too fast. I don't mind if I can have access to that of 2023. Thanks
pick up the pace bucko or you're never getting a job
Are you going to be doing a portfolio project in MySQL? I know thats kind of a lot to ask for, but that would be super helpful because I have had a lot of trouble doing the portfolio project because of the file formats and also being on a mac and also trying to do it on MySQL... Love everything you do, you've been a huge help
Very clear instruction makes note-taking easy!
Watching this even tho i have no laptop yet. Will just rewatch and relearn everything after I can afford one
I've heard several times you're talking about cloud computing. Can you release a video explaining what we need to learn about cloud as a junior data analyst?
Hello Alex, another excellent video in a VERY long line of fantastic content. Concise and focused content that worked on my laptop EXACTLY how it was depicted on the monitor. That's the way to teach effectively and you have discovered that "secret sauce" a long time ago. Thanks again! 😀
Thank you so much for your excellent tutorial, Alex
Today's lesson done, Thank you Alex
My issue with online courses is that you never get to ask questions, like why do you use column when entering Leslie, or the parenthesis used when calculating. I don't know so it confusing to know when to use it
The parenthesis is from PEMDAS. Just like using BODMAS. Just a format for calculation.
Amazing class!!! you make it feel so simple!
Thank you so much!!
can someone please tell me where i can download the table he is using in the video?
If you look in the new comments, someone explained it a month ago.
Hi Alex, thank you for this work you put up. please how can I get the data you used so I can practice along?
from github the link is under the video
Do you have a video on how to create tables?
Thank you for this teaching. Pls do you have any video on Google big query?
note to self
2:29 database needs to be in bold to not write database.table_name in SELECT statement
Thank you very much but please where can I find every related databases?
are you going to do the portfolio projects for MySQL here as well or do I have to replicate the ones done through SQL server mgt studio with MYSQL?
Where do we find CSV file of parks and recreation
Thanks for this great work ❤
Hello can you provide data analyst classes will helps us explore and also help us to get placed in product based organization
Hi Alex! I don't know if this was answered, but you stated that you like to save your code as you go along. What is the benefit of doing this?
@@sandraagusti4527 I do like to save it as I go so that if I have to come back the next day or something I can keep going - I also add comments as I go
hi:) May I ask what the difference is between these videos and your full MySQL course? are the same information but more projects?
Hi Alex, please mysql workbench shows not connected to server
I am having the same issue. Just says it may not be connected to a server and I am not sure why. Did the videos yesterday, log on today and nothing
Hi Alex, I was not able to get the parks and recreation file to create tables from. Is there a possibility for you to post it in the descriptions tab?
Same issue here.
But where will I get your already created sql database from?
can you do tutorial of dates in mysql
Thanks!
😮
Help, please 🙏🏿.
I have the 3 tables set up, BUT, I can't get the 2nd table to append to the 1st query. It only adds 1 at a time. I do see the tabs above the Navigator line, but I can't get the dual query to execute.
Hi! I’m following along with your MySQL tutorial, and I successfully set up the server and MySQL just like you showed in the first video. However, when I tried to log back into the server the next day, it asked me for a password. I entered the password I set up, but it wouldn’t let me in. I’d really like to keep learning with your videos, but I’m stuck at this step. Do you have any advice on how to solve this? Thanks so much for the tutorials - I’m really excited to learn more!
unable to find the data on github, can someone please share the link ????
in the description
Obrigado pelo curso.!
Thanks alot Sir 🙏
Sir Thanks for enable me to become data analyst
I have installed and done some amount of work in the application but when i opened the application again after some time it says to reconfigure every time.....any solution please
I successfuly selected data from table but every time when refresh the page it retreive it again and repeat it multiple times in total 585 rows with repeated values
--Video resumido
-- Lo mas basico (PD) se pone el nombre completo cuando estamos trabajando con muchas bases de datos
SELECT *
FROM parks_and_recreation.employee_demographics
;
-- Funciones matematicas/ cálculos
SELECT first_name, last_name, birth_date, age, age + 10 AS suma
FROM parks_and_recreation.employee_demographics
;
# PEMDAS
-- Para seleccionar cualquier valor diferente/ distinto
SELECT DISTINCT first_name, gender
FROM parks_and_recreation.employee_demographics
;
I am doing marine engineering
Do you think I can learn SQL
Thank you!
✅
I'm interested in ur lecture
I want to become data analyst
Does this work on a Chrome laptop?. That is what I have right now.
my problem is, i use macbook. i do not know how to install the mysql on my macbook
Love youuuuuu Man❣
vsc web portfolio tutorial .U did not show what next after forming portfolio
i have an issue wih my hp because its not the same, kindly assist
how do you get parks an recreation cuz im completely lost i dont have the default option i have deleted an re downloaded this mysql 4 times i dont get it and he is moving kinda fast
hi, the dataset is in the description
Data set please
please do you have the data set?
The code is giving error for sql 20.1
Is anybody else facing this issue?
Yes, I am
@@halimatlawal8455😢😢
When we use SELECT * it shows null value whereas when I used SELECT first_name it showed all values except null. Why? thanks!
When you run the entire code, why didn't it create another column for the calculation (age + 10) * 10 + 10?
because that’s one equation
i dont have lists and folders in sidebar
What do i do if it 'select' position is not valid ?
What is the compiler name
After watching the video, I tried some commend lines in the video and error code 1046 occurred. For those who have the same problem, write " USE" commend as "USE parks_and_recreation" before selecting the table. Thank you all 🙏
Thanks so much
good
thank you soo much😍👍👏
The Playlist was SQL, but this is MYSQL. I am confused
yea I think he changed the videos in the playlist
This play list has been modified by #Sir Alex The Analyst
Thanks
Done
Pls where did this class start from
mugo is from Africa alex
is that Pemdas Or Pandas.....?
This is PEMDAS
Which represents mathematical calculation for slq - stands for :
Parentheses
Exponent
Multiplication
Division
Addition
Substraction
04/11/24
Hey Alex!!! Could you please give me the courses of analyst builder's for free❤😂 🆓🆓🆓
please 🥺 Alex❤
@ Alex the Analyst Please, how can I contact you? I have a question that ONLY YOU can answer.
Kindly let me know ASAP.
My issue with online courses is that you never get to ask questions, like why do you use column when entering Leslie, or the parenthesis used when calculating. I don't know so it confusing to know when to use it
Thanks!