Master the art of SQL @ Rs 1999 with my zero to hero SQL course. The course is focused on data analytics and covers all the advanced concepts starting from scratch. www.namastesql.com/courses/SQL-For-Analytics-6301f405e4b0238f71788354 Course contains 2 portfolio projects and a bonus session on Tableau. 100+ interview problems to crack any SQL INTERVIEW.

create table emp( emp_id int, emp_name varchar(20), department_id int, salary int, manager_id int, emp_age int); insert into emp values (1, 'Ankit', 100,10000, 4, 39; insert into emp values (2, 'Mohit', 100, 15000, 5, 48); insert into emp values (3, 'Vikas', 100, 10000,4,37); insert into emp values (4, 'Rohit', 100, 5000, 2, 16); insert into emp values (5, 'Mudit', 200, 12000, 6,55); insert into emp values (6, 'Agam', 200, 12000,2, 14); insert into emp values (7, 'Sanjay', 200, 9000, 2,13); insert into emp values (8, 'Ashish', 200,5000,2,12); insert into emp values (9, 'Mukesh',300,6000,6,51); insert into emp values (10, 'Rakesh',300,7000,6,50);

This is my one-stop video before every interview for the past years. Brushes up my SQL skills like no other

Crisp & insightful

Literally great. In all my SQL interviews one or the other is asked. Subscribed

Your videos are very good and helpful. Thank you for providing data with create and insert statements.

very simple way to explain...Nice!

Thnks for the video. Very helpful 👍

Great video! Loved that last question. Subbed and eager to practice more SQL with your other videos

Wow it wsd asked today delete duplicates..thanks for the videos.it is really really helpful

Really Master class videos Ankit, Thanks.

Good explanation👏 Please do more intermediate and advanced level of concepts in SQL.

Thank for the video 🙏

Very well explained... 👌

Bang on ! Started product based companies interview prepration for Sr. DE role ( Google/Microsoft/Ubder/Amazon/Expedia / AirBnB) etc...and your content is crisp and clear. Thanks

simple and clear explanation!!

For the First time in 10 years, I am feeling confident with using SQL, only after watching your series of videos. Earlier I used Python to do data preprocessing after doing Vanilla Select * from Table Statement, which was not a recommended approach for memory efficiency.

yeah it was really important vid as see for the interveiw sceneriao

Thanks for this!

Million thanks

Awesome

Tqsm for awesome explanation 🔥

DDL and Insert values for emp table. create table emp( emp_id int, emp_name varchar(20), department_id int, salary int, manager_id int, emp_age int); insert into emp values (1, 'Ankit', 100,10000, 4, 39), (2, 'Mohit', 100, 15000, 5, 48), (3, 'Vikas', 100, 10000,4,37), (4, 'Rohit', 100, 5000, 2, 16), (5, 'Mudit', 200, 12000, 6,55), (6, 'Agam', 200, 12000,2, 14), (7, 'Sanjay', 200, 9000, 2,13), (8, 'Ashish', 200,5000,2,12), (9, 'Mukesh',300,6000,6,51), (10, 'Rakesh',300,7000,6,50);

I was asked 3 questions out of 5 from your list. Thanks alot

Great video, I took down some notes!

You just earned a subscribe from me bro. I haven't used SQL in years, but due to a career change I'm planning to have soon, I'll need to learn more about SQL in-depth alongside bettering my skillset in C++ programming.

Just landed here bro you are doing amazing job

Thanks 👍

Great content. Thank you Ankit

It will be helpful if you can create videos on views and stored procedures

Good one .. !!

finished watching

thanks, it actually let me through so i could download it.

Just loving your content.. Very well explained.

Thanks for this video.

Thanks ankit, ur videos always encourage and boost confidence to prac more n go beyond our limit. Thanks Man

Thanks

You just earned a subscriber really great content🥺

Very Useful...I hope part2 will come soon

Hi Ankit, loved your all videos. Looking forward to see a video on subqueries,

Very Good explanation!

Hi Ankit, first of all this is really a great initiative that you are sharing all this knowledge and explaining the complex queries in a very easy way. And because of this I am really glad to tell you that your channel has majorly helped me to crack one of the SQL interview. Thank you so much for such a great effort and we all wish to see some more complex queries and concepts in coming future, once again thank you so much. Wish you a great health!

Thanks Ankit its very helpful in interivews wish i had come across your videos early.. thnks much

keep doing more videos like it. It really helped me in my job interview today. I am able to answer the question of how to remove duplicates from a table because of your videos.

Thanks brother, nice explanation

Beautiful presentation

Thanks sir for this amazing video

very helpful ..thanks

Ankit, I love your educational content. Is it possible for you to record the whole PL/SQL course for beginner/Intermediates?

thanks Ankit..good tutorial..

I guess we can use subquery table as a normal table to display information using alias and where clause , but when it comes to comparison it needs to return only 1 value :) !!

Ankit sir added humour silently in this video with q10 😃

Superb video..liked every second of the video 💖

#For swap gender : update orders set customer_gender=IF(customer_gender='Male','Female','Male');

Very helpful sir, thank you!

Thanks a lot, Learned lots of new concepts.

I have subscribed and liked . you are doing wonderful job

Love your valuable contents. I have few question sets from facing different screening. Can I share with you for help with solutions? Your way of explanation helps a lot

revised today for deloiite interview and suscribed too

Amazing video, tomorrow I have an interview, I was clueless how to start and where to start, now I know what to do for tomorrow :)) Thanks for sharing :)

Thank you bro

Please make a playlist for sql for the beginners which includes everything like joins, Subquery, functions which used in ms sql..

I am watching your one video each morning. So one day I will work as data engineer in good product based company.

Thank you so much. Make vidoes on JOINS.

5/123 Stuck with 2 ques , coz i'm using mysql

you don't need the motivation from others because, you yourself is a motivation 🤗

for better reach, keep creating content

❤

Wonderful crisp and short explanation Ankit. I have my interviews lined up can you share resources for SQL interview questions, Data Modelling and Normalization scenario based questions? I know all basics and all theories but I want to practice on questions which have answers as well.

please make a part 2 of this video Ankit. thank you for your efforts

Q7. MSSQL does not depend on case-sensitive but in the Oracle is depend on the case-sensitive

You are doing really awesome. Please keep doing this. One suggestion: Please don't forget to add create table script.

Done

Sir pls make latest interview sql quetions

Just wanted to know can we use left anti join for the 5th question?

I asked a question a employee enters and leaves office and he swipes in and swipes out in multiple instances, so I want to find the total office hours he spent in the office( he may come at 10 PM and take a break at 12:30 AM in that case it shows that he is spending 2 hours in that day but that's not true right), so now I have to calculate total time he spent employee id, Office_swipe_record given

1m likes 👍

In 2nd Question of removing duplicates: We are deleting values from the CTE table which is a TEMP table. Then how it is deleting values from the MAIN table?

5th question can we also done used left anti right? like where dep.deptid is null?

Ankit bhai if you have time can you solve some hacker rank test questions for better understanding for people who are learning sql newly..that would be helpfull

can you make a video on stored procedures.. from basic to everything needed to know

hi Ankit , can you please make some videos for product based companies. Thank yoou for your effort. Appriciatable

Wow such a nice content. Please zoom a bit while making videos. Because most audience watch it over phone it strain the eyes

In the 2 question, delete from cte is written so how the records got deleted from original table

with CTE as ( select * ,row_number() over(partition by emp_id order by emp_id) as rnk from emp order by emp_id asc ) delete from CTE where rnk > 1 From CTE we can't delete records?

Performance wise why joins are better than subqurey??

what if i wanna to swap from row 4 and 5 value , I think 'case' only do for the first occurrences of match value.Thus why, only the first two rows are evaluated with case clause and rest remain the same. Is it true bhai? I am not clear about it. Plz shed some light .

Hi, Ankit. you made them look so easy. Thank you💌. it would be great if you could provide the code of the creation of tables so i can practice it on my workbench.

Sir please raise the editor font more than 130% while recording , coz it's very hard to watch on the phone

Hey Ankit! I was thinking about that delete duplicate question. U r deleting the duplicate data from cte which is a temporary result set , right? It is working fine but how it's deleting from original table? MySQL doesn't support this from 8+ versions I guess..we have to use that cte query like a subquery in mysql. But in ssis it is working. Even in leetcode ! But I think it is always better to reference the original table rather than querying from cte i.e a temporary result set. Selection is fine with cte but dml operation! Let me know about your thoughts, I would love to hear!

@Ankit , Requesting you to add more scenario based SQL questions mostly asked in NICHE Product based companies, would be helpful.

Hello Ankit, I have onre request along with the explanation if you can share the create table command as well , will be helpful to dummy it to my own schema. Like here employee table

What is the difference between union and union distinct

in union it will also SORT the result

Delete duplicate records query in not working in databricks notebook for deleting duplicate records from a table.. is there any way to do this in databricks notebook table? @ankit

Thanks for this Video. I have one doubt, Question number 2. How to delete duplicates from a table? Shall we do it in mysql? I tried but I didn't get correct result.

Diff between count* and count1

Helpful video, Thanks. could you please share the dataset used in the video, to practice please.

Hello ankit, Seems like you have lots of videos but not in a playlist, for ex: I want to start from the beginner level and then moved to medium then hard queries. I have seen your playlist but lots of videos aren't there where you are explaining things like the date function, and rank function, If it's in a playlist/series then it would be easier for us to go through step by step. Let me know if you already have or i have missed something.

Can you please tell me how to delete duplicates in mysql?