Hii, your explanation & content both are to the point and useful. Thanks for the clarity. Please bring up more videos related to DE profile. Interested. :)
I am now really digging into the attachments that you provided and they ae awesome. I am leaning to become a Data Engineer and this will help tremendously. Thank you! East Coast Sr
Interesting usage of the GROUP BY and HAVING clauses for filtering...didn't know they could be used without an aggregation function in the SELECT statement :D Initially I had done a query like this using subqueries for the GROUP BY exercise (I had no idea how to use the GROUP BY for this)...very long compared to yours hahaha. Thanks Jay!!! I learned a lot of valuable stuff in here 😁 SELECT product_id, product_name FROM Product WHERE product_id IN ( SELECT DISTINCT product_id FROM Sales WHERE sale_date >= DATE('2019-01-01') AND sale_date DATE('2019-03-31') ) );
Glad you found something useful in the video man, honestly there are so many ways to write SQL online, and I feel code readability/conciseness goes a long way
Hey Jayzern, really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .
00:05 Preparation is key for SQL interviews 01:15 Understand different types of SQL joins 02:32 Writing SQL query using joins for comparing salary amounts 03:47 Visualize table joins for clarity 05:10 Using GROUP BY and JOIN to isolate specific data from a table. 06:44 Using window functions to add rank to employee data 08:30 Understanding Entity Relations and Database Design Principles 09:48 Quality of practice over quantity is key
Great video, I'm developing my DE knowledge and I was just thinking of what I should do to improve my SQL skills. Happened to check your channel later on and this was your latest video! So appreciative of your content. Your notion pages are super helpful as well, as that's what I use to take notes when I'm learning. Subscribed and hoping for more Data Engineering topics from you :)
![[UNCUT] "เสรีพิศุทธ์" แฉยับ! งัดหลักฐานใหม่ชั้น 14 ได้นอนคุกสมใจแน่!! I คนดังนั่งเคลียร์ I 2 ก.ย.67](http://i.ytimg.com/vi/O1SSg4p9Izs/mqdefault.jpg)
Yet another great video Jay. Content was spot on and easy to understand. Keep sharing your passion (thru films) with us. Greatly appreciated.
SWE here of 10+ yrs looking to go into DE. thank you for these videos. hope to see more.
Hii, your explanation & content both are to the point and useful. Thanks for the clarity. Please bring up more videos related to DE profile. Interested. :)
Very precise and crisp explanation. Thank for sharing the content.
Amazing! Thanks for the info, started learning sql after building a database to help with my network job. Thinking I might try to move towards DBA
I am now really digging into the attachments that you provided and they ae awesome. I am leaning to become a Data Engineer and this will help tremendously. Thank you! East Coast Sr
really looking for more and more content .....excellent ...thank you
Interesting usage of the GROUP BY and HAVING clauses for filtering...didn't know they could be used without an aggregation function in the SELECT statement :D Initially I had done a query like this using subqueries for the GROUP BY exercise (I had no idea how to use the GROUP BY for this)...very long compared to yours hahaha. Thanks Jay!!! I learned a lot of valuable stuff in here 😁
SELECT
product_id,
product_name
FROM
Product
WHERE
product_id IN (
SELECT DISTINCT
product_id
FROM
Sales
WHERE
sale_date >= DATE('2019-01-01')
AND sale_date DATE('2019-03-31')
)
);
Glad you found something useful in the video man, honestly there are so many ways to write SQL online, and I feel code readability/conciseness goes a long way
Amazing job Jay!
Thank you for the video.
Do you have a Discord channel or anything to group the community? Thanks again!
Thank you! Not at the moment, planning to post more videos first
God bless you
thanks for the video! but I can't open the link for notes...could you please share again?
Informative video buddy
Hey Jayzern, really nice video! I was wondering if I could help you edit your videos and also make a highly engaging Thumbnail which will help your video to reach to a wider audience .
00:05 Preparation is key for SQL interviews
01:15 Understand different types of SQL joins
02:32 Writing SQL query using joins for comparing salary amounts
03:47 Visualize table joins for clarity
05:10 Using GROUP BY and JOIN to isolate specific data from a table.
06:44 Using window functions to add rank to employee data
08:30 Understanding Entity Relations and Database Design Principles
09:48 Quality of practice over quantity is key
Great video, I'm developing my DE knowledge and I was just thinking of what I should do to improve my SQL skills. Happened to check your channel later on and this was your latest video!
So appreciative of your content. Your notion pages are super helpful as well, as that's what I use to take notes when I'm learning. Subscribed and hoping for more Data Engineering topics from you :)
Amazing! Thank you for your support.
This is great