This playlist contains scenario based SQL problems. After solving these you should be able to ace any SQL interview. As and when I find a good problem, i will add it to this playlist.
Curated by: Ankit Bansal (96 videos)
In this video we will discuss a PayPal data engineer sql interview problem. We will solve it with 2 methods and also going to solve it with a twist. 00:00 : understanding the problem 03:10 : the secret trick 06:30 : aam zindagi solution (normal life) 16:28 : mentos zindagi solution (mentos life) 23:35 : the twist ;) data: employee_checkin_details: employeeid ,entry_details, timestamp_details 1000 , login , 2023-06-16 01:00:15.34 1000 , login , 2023-06-16 02:00:15.34 1000 , login , 2023-06-16 03:00:15.34 1000 , logout , 2023-06-16 12:00:15.34 1001 , login , 2023-06-16 01:00:15.34 1001 , login , 2023-06-16 02:00:15.34 1001 , login , 2023-06-16 03:00:15.34 1001 , logout , 2023-06-16 12:00:15.34 employee_details: employeeid , phone_number , isdefault 1001 ,9999 , false 1001 ,1111 , false 1001 ,2222 , true 1003 ,3333 , false Zero to hero(Advance) SQL Aggregation: https://youtu.be/5Ighj_2PGV0 Most Asked Join Based Interview Question: https://youtu.be/xR87ctOgpAE Solving 4 Trick SQL problems: https://youtu.be/Ck1gQrlS5pQ Data Analyst Spotify Case Study: https://youtu.be/-YdAIMjHZrM Top 10 SQL interview Questions: https://youtu.be/Iv9qBz-cyVA Interview Question based on FULL OUTER JOIN: https://youtu.be/KQfWd6V3IB8 Playlist to master SQL : https://youtube.com/playlist?list=PLBTZqjSKn0IeKBQDjLmzisazhqQy4iGkb Rank, Dense_Rank and Row_Number: https://youtu.be/xMWEVFC4FOk #sql #dataengineer #paypal