Just in time for my job interview. I don't have any certification, didn't even finish college. I just watched all of your Data Analyst Bootcamp and I can't even thank you enough. I'm looking forward to get your Analyst Builder. And I got multiple interviews all thanks to you ALEX!!!
Excellent content I just found you from Sundas Khalid interview. From today, you are my guru / mentor. I believe, I shall be a very shining student. :-)
Great video! One thing I would add is that not all interviewees will get a chance to live code as part of their interview process; some will only send this question to you as a take-home. The expectation, then, is to send back the query (unless the questions explicitly ask you to elaborate more on your thought process). In this basic query, though, the comments should suffice in succinctly conveying the thought process. I was lucky enough to have a senior data analyst go back-and-forth with me to learn SQL. To be fair, it was SQL Developer, which is a less "conventional" SQL language...
I am such a huge fan of your comments in the editor. Plus the concept of “explaining your thought process to the technical interviewer”. Great way by build the confidence as well if you actually know the theory behind what you are doing 🎉
00:01 Solving easy SQL technical interview questions is important for data analyst positions. 01:18 Practicing SQL interview questions on Analyst Builder. 02:44 Write a query to identify cars that passed inspection and list owner name and vehicle name ordered by owner name alphabetically. 04:29 Filter cars without critical or with three or less minor issues 06:09 Ordering data in SQL using 'order by' clause 07:41 Identifying new customers without duplicates 09:16 Filtering based on age and total purchase amount 10:53 Articulate your thought process and earn points by solving easy SQL interview questions on Analyst Builder.
I finished your free youtube sql series and tried these questions by myself before watching the vids and passed! Kinda feels like my first real solo accomplishment with sql ^_^ thank you for being a great teacher and im excited to keep learning more
I totally bombed on an interview with Amazon for a BI Engineer about a month ago. I have been out of work for over a year and forgot basic syntax. I also was not prepared for how they just paste a bunch of text into the chat window and say "Pretend these are records in a database and write a query that..." I thought I would get access to a database, get my queries together, and paste them into the chat window.
@@malcorub Exactly. It was pretty bizarre. I launched VS Code so my query would be formatted nicely for readability and Chime told the interviewer that its window did not have focus. He told me to maximize Chime and not click out of it for the duration of the interview. He was a nice guy, but my anxiety was through the roof and I just kind of froze up at that point.
Hey ALex hope you are doing good. I have been learning allot from your videos. I just have one request. Can you make a video on SQL explaining how to connect with cloud servers and company servers?
Hello Alex, thanks for all you do. It is inspiring! I would like to know regarding the car inspection question, should the minor issues not be written as minor issues >3 since the question said a car with minor issues more than 3 will fail.
This is the catching point *Write a query to identify all of the cars * so your query will be >=3 The interviewer will always twist the question one way or another. This is where your attention to details comes in 🤣
visually checking for dupilcate customer_id works in this case but would be difficult in a long table. This could be sped up by: SELECT COUNT(customer_id) AS total_purchases, COUNT(DISTINCT customer_id) AS unique_customers FROM customers;
Please we need more exercise on this , thank you very much Mr Alex_Analyst And please can you differentiate ( or explain with a short )between SQL and MySQL and other versions because I don't really know their differences and similarities, and again do we have to pay to access the website before going through these examples ? Thank you in advance 🤲
There are different "flavors" or types of SQL. I have a few videos on this :) and there are free questions on the platform as well as premium questions.
My question is, i understand the queries you wrote, what I don't understand are the real world use. I also understand that you're showing really simple csv files, and the real purpose of sql is that you might have a million lines of data. For finance, would your boss maybe ask you to find the customers that earned over 5% in their portfolio in 2023 or how many people over 67 starting withdrawing from their Roth IRA? I get the simplicity you're trying to show, I'm just curious about real world use.
These are very simple examples. Most queries on the job aren't that simple. I have some queries that are hundreds of lines of SQL (and bigger actually)....things like decile analysis, or customer life cycle stage for example. The exercises here are examples of a few basic concepts, building blocks, that you combine with other methods. Also, he's demonstrating how to think through an exercise, note how he writes comments in the code first (pseudo code) to establish the goals and logic, then fills in the SQL code after. Also note how he's doing a broad SELECT * to explore the data beforehand.
Hi Alex, looking at becoming a data analyst this year and I have been following your boot camps. I would like to ask a question; Most of the softwares used in your videos are done on a PC my question is what is your advise for people with MacBook, is it possible to learn on them (SQL, Tableau etc)?
Alex I'm having a problem with postgres first on Mint, now on Windows: User pg_restore: error: input file does not appear to be a valid archive . I don't get it how to solve it?
This is easily the best data analyst channel on TH-cam, no one else is putting out content like this. Really appreciate it
I love the fact that you remind us to talk it out loud and walk the interviewer through what we are doing. That's what sets us apart from the rest.
Just in time for my job interview. I don't have any certification, didn't even finish college. I just watched all of your Data Analyst Bootcamp and I can't even thank you enough. I'm looking forward to get your Analyst Builder. And I got multiple interviews all thanks to you ALEX!!!
True, his guidance is invaluable.
Excellent content I just found you from Sundas Khalid interview. From today, you are my guru / mentor. I believe, I shall be a very shining student. :-)
Great video! One thing I would add is that not all interviewees will get a chance to live code as part of their interview process; some will only send this question to you as a take-home. The expectation, then, is to send back the query (unless the questions explicitly ask you to elaborate more on your thought process). In this basic query, though, the comments should suffice in succinctly conveying the thought process.
I was lucky enough to have a senior data analyst go back-and-forth with me to learn SQL. To be fair, it was SQL Developer, which is a less "conventional" SQL language...
I am such a huge fan of your comments in the editor.
Plus the concept of “explaining your thought process to the technical interviewer”.
Great way by build the confidence as well if you actually know the theory behind what you are doing 🎉
really words can't describe how much all of us are grateful for u for making everything east for us , thanks alot , hope you r doing great
We are grateful indeed 🤲💯
Thank you so much, Alex! It was a great video SQL lesson. I appreciate it, and looking forward to the next SQL interview questions.
Hi Alex plz upload the power bi ,and tableau interview questions also
00:01 Solving easy SQL technical interview questions is important for data analyst positions.
01:18 Practicing SQL interview questions on Analyst Builder.
02:44 Write a query to identify cars that passed inspection and list owner name and vehicle name ordered by owner name alphabetically.
04:29 Filter cars without critical or with three or less minor issues
06:09 Ordering data in SQL using 'order by' clause
07:41 Identifying new customers without duplicates
09:16 Filtering based on age and total purchase amount
10:53 Articulate your thought process and earn points by solving easy SQL interview questions on Analyst Builder.
Thank you very very much for these videos and bootcamp. You've made the data analysis so easy for me, Alex.
I finished your free youtube sql series and tried these questions by myself before watching the vids and passed! Kinda feels like my first real solo accomplishment with sql ^_^ thank you for being a great teacher and im excited to keep learning more
Thank you for putting this out, super solid explanation! Mini confidence boost in being able to solve them!
Yes, I enjoyed the video
Thanks so much for sharing Alex.
Thanks🎉. I have no regret of buying Analyst Builder Course Bundle. Cheers !!!
Over 65 usually includes 65. I would clarify that with HR
Wonderful!!! You are the best. ❤I heart you from Nigeria
Awesome 👍
Thanks a million Alex!
That was a wonderful video, I'll practice on it to prepare for my interviews 😊
I totally bombed on an interview with Amazon for a BI Engineer about a month ago. I have been out of work for over a year and forgot basic syntax. I also was not prepared for how they just paste a bunch of text into the chat window and say "Pretend these are records in a database and write a query that..." I thought I would get access to a database, get my queries together, and paste them into the chat window.
So you had to free hand SQL into a chat window? Interesting to see how various companies handle the technical interview.
@@malcorub Exactly. It was pretty bizarre. I launched VS Code so my query would be formatted nicely for readability and Chime told the interviewer that its window did not have focus. He told me to maximize Chime and not click out of it for the duration of the interview. He was a nice guy, but my anxiety was through the roof and I just kind of froze up at that point.
Hey ALex hope you are doing good.
I have been learning allot from your videos. I just have one request.
Can you make a video on SQL explaining how to connect with cloud servers and company servers?
Best site Ever, Ty Alex!
Great one expecting more such videos for interview preparation ❤♥
Hello Alex, thanks for all you do. It is inspiring! I would like to know regarding the car inspection question, should the minor issues not be written as minor issues >3 since the question said a car with minor issues more than 3 will fail.
This is the catching point *Write a query to identify all of the cars * so your query will be >=3 The interviewer will always twist the question one way or another. This is where your attention to details comes in 🤣
visually checking for dupilcate customer_id works in this case but would be difficult in a long table. This could be sped up by:
SELECT COUNT(customer_id) AS total_purchases, COUNT(DISTINCT customer_id) AS unique_customers FROM customers;
You are amazing just I am sad I didn't find you earlier👍
Please we need more exercise on this , thank you very much Mr Alex_Analyst
And please can you differentiate ( or explain with a short )between SQL and MySQL and other versions because I don't really know their differences and similarities, and again do we have to pay to access the website before going through these examples ?
Thank you in advance 🤲
There are different "flavors" or types of SQL. I have a few videos on this :) and there are free questions on the platform as well as premium questions.
@@AlexTheAnalyst okay thanks I just joined the discord team now , so where do I get these videos so I can be able to differentiate them
thank you
Nice sh!t Alex! :)
Thank you !
My question is, i understand the queries you wrote, what I don't understand are the real world use. I also understand that you're showing really simple csv files, and the real purpose of sql is that you might have a million lines of data.
For finance, would your boss maybe ask you to find the customers that earned over 5% in their portfolio in 2023 or how many people over 67 starting withdrawing from their Roth IRA?
I get the simplicity you're trying to show, I'm just curious about real world use.
These are very simple examples. Most queries on the job aren't that simple. I have some queries that are hundreds of lines of SQL (and bigger actually)....things like decile analysis, or customer life cycle stage for example. The exercises here are examples of a few basic concepts, building blocks, that you combine with other methods. Also, he's demonstrating how to think through an exercise, note how he writes comments in the code first (pseudo code) to establish the goals and logic, then fills in the SQL code after. Also note how he's doing a broad SELECT * to explore the data beforehand.
@@Mister_Garibaldi That was my guess. Thanks very much for sharing.
Some customers are over 65 AND purchased more than 200 dollars, so I think distinct-count would be a better way to approach. Anyone agrees?
Hi Alex, looking at becoming a data analyst this year and I have been following your boot camps. I would like to ask a question; Most of the softwares used in your videos are done on a PC my question is what is your advise for people with MacBook, is it possible to learn on them (SQL, Tableau etc)?
You can still use a MacBook. I bought one myself and there are lots of great alternatives.
@@AlexTheAnalyst Yh but I find it had to access the SQL software
Alex I'm having a problem with postgres first on Mint, now on Windows: User
pg_restore: error: input file does not appear to be a valid archive . I don't get it how to solve it?
Thanks Alex_ Analyst
Awesome!
3:45
Always on 0.75 speed😊
Anyone else have problem signing back in?
Is your course permanent sir?
Hi Alex I do not know if you are more active here or tik tok but I sent a message on tik tok! If not please let me know I’ll send it here? Thank you