Hi Viewers, if you have any queries on this topic or you want any topic to learn from us, drop them in our comments section. Please make sure you subscribe to our KZfaq channel 👉Please ping on WhatsApp wa.me/9916961234

The Most Underrated Teacher or Guru in IT in India Mr. Santosh Sir If you learn from him , you are never going to fail for interview.

I had an interview today and these questions are valid till date. So many questions in these were asked in round 1.

Really u r videos are very helpful bro...if we watch just u r projects videos on power BI, top 25 interview question and EY real time interview...these videos are enough for cracking the interview....thnks alot for u r wor...

For me in interview so many interview Question asked from this list. like windows function,joins, rank,dense_rank,Union,unionall etc. be prepare guys before go to interview. Thanks to KSR to provide like this veios in social platform. i did subscribe and like👋🤌expecting more vedios from u r channel.

The way of explanation is awesome, Thanks a lot for the valuable information. Sir we are expecting more videos from you in the future with Real time Scenario aswell.

Respect for you sir your really kind enough to even reply to the comments n provide links to tutorials when asked expecting more visualization interview videos from your team..

In upcoming days i will facing interview for BI developer. And from few days i will try to finding videos for interview preparation and suddenly yesterday i got your 1st video about BI questions really bro all questions are related and I'm feeling understandable after watching it tqq bro 🙏

My favourite educator .. ❤ sir I wish you get more success

Always check the stored procedures and triggers. For SQL it must follow SDLC with the user's requirements that were communicated to management. No matter what flavor ov Unix box. Sun, Solaris etc. Guys with main frame and mid range experience were easiest to train instead of PC dudes.

The way you are explaining the topic is Awesome.

Hi Sir way of explaining is soooo good, awesome. It would be better if u show us the queries by writing instead of saying words

Todays most important video for me thanks plz bring more video like this And plz make video on top questions ans of powerbi

Video is very informative, Please do more videos. Only concern is, it would be better if u show us the queries by typing instead of saying words . Thank you!!

Thank you sir for consolidating all the important questions in a single concise video.

sir in some interviews they ask to perform in sql and powerbi with one small task eg-write the syntax to find the highest salary from employee table, write syntax whose name starts with A so plz make some practical based questions too. thanks in advance

DDLs can be rolled back in some recent versions of SQL SERVER

Very nice video for the beginners...

Thank you so much bro . Finally I am able to solve all the ans from your vedio. Till now i ha e doubt that what will be the topics for power Bi interview on SQL . NOW I am confident enough that yes i can clear SQL round very easily 👍👍🙏🙏

Sir ! your videos are really helpful and very crisp and easy to understand. Thank you so much for creating!

very true collection of sql for interview

Thanks for sharing interview questions. Nice explanation. Can you, Please share a video on SQL and PL SQL coding..... Sir.

The things which you are explained is best to get job in interview thank you so much sir

This is very helpful and very clearly explained. Thanks!

Tqs for ur effort..It really helpful for Beginners who are facing the interviews.

Its amazing explaination... God bless u to get more success in life..Thankyou so much

Great 🙌 nice video it's very helpful thanks

Wow best SQL video thanks

Please keep uploading this type of sql and power bi videos more thanks a lot sir

Please make a video practically how to write real time sql queries for interview

But we can use aggregated column in where by using nested query/sub query/cte

KSR is one of the best 👌 ❤ thank you ,you're explanation is amazing 👏

Very Well Explained... !!! thank you for the detail and clean answers

This kind of interview questions will be helpful for many candidates and the efforts and content u r sharing is Awesome. Waiting for real time projects to upload in ur channel.. thanks a lot ❤️

Very well explained 👍 please share answers for SQL coding questions

Sir please answer de Mai. 12th pass hu Science maths kiya hu Kya mai data analysis kar sakta hu. Uske kaun kaun se software use hote hai woh bhi video mention Karo please 🙏🙏🙏🙏

Excellent!!! You are amazing. If you can make a video together with Tableau... that would be great!!!

Great explanation

Excellent Sir! Appreciating your hard efforts.❤

It's help ful. But give queries as well. Thanks.

very useful and very effective

Very clearly explained. Worth to watch each n every video of urs 👌👌. Thanks a lot for giving us such good knowledge on subject

Really great explanation. Thankyou so much

Thanks a lot for your nice explanation.

Hi sir Could you please provide answers for coding questions.....

Excellent work! Thank you for sharing your knowledge!

If u r changing the screen. That will be more helpful for better understanding. ..

The way of explanation is awesome sit...Kudos!

THANK YOU SO MUCH FOR THE VIDEO.

Very nice and useful information 👍

Thanks for this sir.

Loved your explanation sir. Thank you for this video

Excellent explanation Bro. Thank you🎉

Ossam explain 🎉

Thank You brother!! Really very helpful🙏🙏🙏🙏👏👏

Thanks Sir, Your videos are really helpful 👍

VERY NICE EXPLANATION AND VERY USE FULL VIDEO

Good explanation sir thank you...i noted everything

Thank you!

Good job sir

Superb explanation 👏

Please upload as soon as possible the interview question on SQL Coding. Also add some more questions in coding questions.

The way u explained it ossum dude

in the first question you said the main difference between DDL and DML is DDL command can not be rolled back. I think thats not correct. begin tran Drop table Brands Rollback tran as above query works with rollback

I am able to answer 19 questions

Sir is it necessary to give a lengthy ans in an interview or I can give crisp and clear to the point ans

Could you please make video on SSIS tutorials and interview questions for beginners to advanced level please. Once you get chance

Thankqq sooo much sir for this video and also plzz provide the solve the coding videos sir

Nice explanation.

We'll explained. Thanks man!

👌

Could you please help me with the Scenario, Input TABLE u DEPTNO ENAME 10 RAGHU,RAJU,RAVI 20 MOHAN,PRIYA 30 PRAVEEN OUTPUT DEPTNO ENAME 10 RAGHU 10 RAJU 10 RAVI 20 MOHAN 20 PRIYA 30 PRAVEEN Oracle 11G PL/SQL

Thank you,

Outstanding

In the first question of sql coding , the 3rd maximum salary person , can we use large ( salary , 3) , to find the 3rd largest salary and then write an outer query to fetch the employee name from this table with the third largest salary ? Would it also be correct ?

finished watching

Thanks for the questions with answers❤

Any SQL classes sir? I want to learn from scratch any tutorial do u have please inform.

Thanks a lot

Great Video Sir

Thqnk you so much for sharing a video. Its help me a lot to crack the interview. Easy to understand with the explanation 🙏

very usefull video

Also , in the second question , can we use row number () over ( partition by id order by id ) , so that any id that duplicates will have the row no as 2 and the rest will have one , so we can select the records where row number =2 ?

Thank you amazing contant

Very Nice Sir ...

This video is a gold mine. Thanks you Sir.

Hi Sir, as i understand once commit after transaction we can't rollback either Truncate or Delete or drop.

Hello sir….Are these still good for Power BI Analyst Role or do you have any updated Questions Videos on SQL and POWER BI.

Hi, Sir, I want to ask one thing. If I am able to answer till intermediate will I able to get a beginner-level job?

GREAT

Appreciated

Hello can you share the coding video questions?

Hi sir.. waiting for most asked SQL queries interview QnA...

Hi All. I have prepared for the interview by watching this.. I got selected and working already..same qns i got in interview.most helpful content

Thanks for this Video, can you assist Same for Azure Data Factory, which helps me a lot.

HAVING Clause implements in column operation. WHERE Clause implements in row operations. You messed it up, sorry

❤

dml commands are not rollback,but delete can be roolback .

Hai sir I have a doubt that IN SSMS SQL WE CAN ROLL BACK SOME OF DDL STATEMENTS ALSO.

power bi and power service topics upload videos sir