How to PASS SQL Interviews? Data Science Tips⚡

preview_player
Показать описание

====== ✅ Details ======

SQL interviews in data science are tricky. Even seasoned pros fail the SQL rounds at times.

That's why in this video, I share:

👉 Tips that make or break your success in SQL interviews
👉 Daetama - an SQL practice pad with 100 interview questions
👉 A walkthrough of a Google SQL interview question

👍 Make sure to subscribe, like, and share!

====== ⏱️ Timestamps ======

00:00 - How to PASS SQL Interviews?
00:35 - What do interviewers look for?
00:58 - Google SQL question
01:33 - Bad Response
02:12 - Good Response
04:49 - Great Response

====== 📚 Other Useful Contents ======

====== Connect ======

Рекомендации по теме
Комментарии
Автор

Hope you enjoy today's video on SQL! Got questions? Drop one below!👇

DataInterview
Автор

2 things I didn't understand:
1. Why didn't you do a left join? even if the interviewer doesn't expect to see websites without clicks, it's still a better answer that shows that you think of all edge cases.
2. Why do you have to use a WITH or an inner query? I think a better solution would be to ask the interviewer if it make sense to assume that the websites table is rather small (not more than 100k probably), therefore you can easily join it with the events table without losing computation, and then do the join, filter and group by in one simple query.

realsome
Автор

Please keep up the great work you're doing! Super helpful video!

hanipatel
Автор

Thank you for the videos! I believe it would be beneficial to know how the solution would change (if at all) depending on the answers given by the interviewer in response to the interviewee's follow-up questions.

MrBigzBigz
Автор

Hi Dan, I have a habit of checking results output of each step before reaching the final completed code.
For example, I would check the result of my CTE, or subquery first, before joining. Is that allowed in the interview?(if it's not on the phone screen) Thanks

darc.
Автор

I'm excited about tomorrow's launch of Daetama at 9am !

Aidan_Au
Автор

I have a question. What is a standard (if exists) amount of time that is given to the interviewee per SQL question to solve? And if it varies a lot, what is a "safe" (subjective) time limit that I should strive to constrain to for practice purposes?

shermino
Автор

Thank you for keeping updated with such informative content and great work with Daetama launch. I want to practise more questions as I started following your videos lately. Seems like this coupon code got expired, I humbly request you to please enable it.. 🙏🏼 Thanks in advance!!

KarthikeyaRacharla
Автор

Here is a simple version. You do not necessarily need a subquery or a temp table to solve this question:


SELECT
w.url,
COUNT(a.event_id) AS click_count
FROM
google_search_activity a
JOIN
google_search_websites w
ON
a.website_id = w.website_id
WHERE
a.event_type = 'clicked'
AND a.creation_dt BETWEEN '2022-01-01' AND '2022-06-01'
GROUP BY
w.url
ORDER BY
click_count DESC;

technicalboyshreyans
welcome to shbcf.ru