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 an SQL interview online assess emnt question asked by an startup Vyapar. High quality data analytics and engineering content: https://www.namastesql.com/ scripts: -- Create tables CREATE TABLE department ( dep_id INT, dep_name VARCHAR(50) ); CREATE TABLE empdetails ( emp_id INT, first_name VARCHAR(50), gender VARCHAR(1), dep_id INT ); CREATE TABLE client ( client_id INT, client_name VARCHAR(50) ); CREATE TABLE empsales ( emp_id INT, client_id INT, sales INT ); -- Insert data INSERT INTO department (dep_id, dep_name) VALUES (1, 'Electronics'), (2, 'Furniture'), (3, 'Clothing'); INSERT INTO empdetails (emp_id, first_name, gender, dep_id) VALUES (101, 'Alice', 'F', 1), (102, 'Bob', 'M', 1), (103, 'Charlie', 'M', 2), (104, 'Diana', 'F', 2), (105, 'Ethan', 'M', 3), (106, 'Fiona', 'F', 3); INSERT INTO client (client_id, client_name) VALUES (1, 'Amazon'), (2, 'Walmart'), (3, 'Costco'), (4, 'Target'), (5, 'BestBuy'); INSERT INTO empsales (emp_id, client_id, sales) VALUES (101, 1, 5000), (101, 2, 3000), (102, 1, 7000), (102, 3, 2000), (103, 2, 4000), (103, 4, 3000), (104, 4, 6000), (105, 5, 8000), (106, 3, 5000), (106, 5, 2000); 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