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
@sunilrawat89552 жыл бұрын
Me me
@user-gm7lr6nx2z Жыл бұрын
Couldn't join the whatsapp group
@AshishTiwari-ug2lg3 ай бұрын
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.
@DataExplorer21Ай бұрын
I had an interview today and these questions are valid till date. So many questions in these were asked in round 1.
@KSRDatavizon5 сағат бұрын
i am glad its helpfull to you, hope you Got the Job. all the best for your future.
@arunn72552 жыл бұрын
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...
@KSRDatavizon2 жыл бұрын
Thank you so much for your msg, we are trying to get placed as much as students we can. we are very happy if it helps to even one single student.
@ReferKaroEarnKaroo8 ай бұрын
Hello Arun can u help me for interview
@user-wu5zo1th5o8 ай бұрын
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.
@KSRDatavizon5 ай бұрын
Thank you for your support! Your subscription and likes mean a lot, and I'll work on more videos on these topics.
@BhanuPrakash-mf7br2 жыл бұрын
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.
@vamshiabhilash2 жыл бұрын
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..
@KSRDatavizon2 жыл бұрын
Thanks for your words.. Definitely we will upload more videos
@pranavjogladevikar47382 жыл бұрын
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 🙏
@KSRDatavizon2 жыл бұрын
All the best Pranav, please do watch other Power Bi interview videos here kzfaq.info/get/bejne/ntd1orWfmsnNiIU.html kzfaq.info/get/bejne/d7uGadal3LiygYE.html kzfaq.info/get/bejne/Z66Xm5ZzsrfDhIk.html kzfaq.info/get/bejne/jbNnhbZ-37HWimw.html
@healyourstress7658 Жыл бұрын
My favourite educator .. ❤ sir I wish you get more success
@KSRDatavizon Жыл бұрын
Hope you are liking it !! keep watching
@stevel.2759 Жыл бұрын
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.
@KSRDatavizon Жыл бұрын
thanks for your response
@HemaBhargavi-xx8gs Жыл бұрын
The way you are explaining the topic is Awesome.
@KSRDatavizon Жыл бұрын
Thanks a ton
@Maahi812 Жыл бұрын
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
@KSRDatavizon Жыл бұрын
Noted, will do those kind of video. please subscribe our channel for more details.
@karanmalkhede66892 жыл бұрын
Todays most important video for me thanks plz bring more video like this And plz make video on top questions ans of powerbi
@KSRDatavizon2 жыл бұрын
Thank you for liking our videos, sure will make more like these
@MaDmAxLoCaL2 жыл бұрын
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!!
@KSRDatavizon2 жыл бұрын
Sure Sandeep, will improve it in next videos.
@user-hs7fd9dq2m9 ай бұрын
Thank you sir for consolidating all the important questions in a single concise video.
@KSRDatavizon9 ай бұрын
You are most welcome, Please subscribe our channel, it motivates a lot
@TheVishalrockstar2 жыл бұрын
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
@KSRDatavizon2 жыл бұрын
Yes we will upload videos on sql practical questions asap
@chinchusabu65392 жыл бұрын
U can use finding first letter Select * from table name where column name like 'A%';
@nikhildhiwar23558 ай бұрын
SELECT * FROM employee ORDER BY salary DESC ;
@sathyanarayanan42272 ай бұрын
DDLs can be rolled back in some recent versions of SQL SERVER
@user-uh4gr7po2h2 ай бұрын
Very nice video for the beginners...
@icici2442 жыл бұрын
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 👍👍🙏🙏
@KSRDatavizon2 жыл бұрын
Most welcome 😊
@sovanpattnaik07Ай бұрын
Sir ! your videos are really helpful and very crisp and easy to understand. Thank you so much for creating!
@KSRDatavizon5 сағат бұрын
You're welcome! I'm glad my videos are proving helpful. I strive to make my content as clear and concise as possible. If you have any other questions or requests, please don't hesitate to ask.
@princysingh1398 Жыл бұрын
very true collection of sql for interview
@KSRDatavizon Жыл бұрын
thank you so much, please subscribe our channel for regular updates.
@sureshavullapalli2357 Жыл бұрын
Thanks for sharing interview questions. Nice explanation. Can you, Please share a video on SQL and PL SQL coding..... Sir.
@KSRDatavizon Жыл бұрын
Will upload soon
@manjupreetham2 жыл бұрын
The things which you are explained is best to get job in interview thank you so much sir
@KSRDatavizon2 жыл бұрын
Most welcome
@monicaakannan94613 ай бұрын
This is very helpful and very clearly explained. Thanks!
@KSRDatavizon3 ай бұрын
I'm glad you found it helpful! Please subscribe our channel for regular updates and it motivates us a lot.
@ravireddy2702 жыл бұрын
Tqs for ur effort..It really helpful for Beginners who are facing the interviews.
@KSRDatavizon2 жыл бұрын
Thank you so much, please subscribe our channel.
@vigneshwariguru2098 Жыл бұрын
Its amazing explaination... God bless u to get more success in life..Thankyou so much
@KSRDatavizon Жыл бұрын
Thanks and welcome
@raginishrivastav42649 ай бұрын
Great 🙌 nice video it's very helpful thanks
@KSRDatavizon9 ай бұрын
You are most welcome, Please subscribe our channel, it motivates a lot
@devd53552 жыл бұрын
Wow best SQL video thanks
@KSRDatavizon2 жыл бұрын
Glad you liked it
@supratikpaul64032 жыл бұрын
Please keep uploading this type of sql and power bi videos more thanks a lot sir
@KSRDatavizon2 жыл бұрын
Sure we will do. Thanks
@kiranid57826 ай бұрын
Please make a video practically how to write real time sql queries for interview
@KSRDatavizon6 ай бұрын
Sure we will make it soon
@user-rh1hr5cc1r5 ай бұрын
But we can use aggregated column in where by using nested query/sub query/cte
@KSRDatavizon5 ай бұрын
You're absolutely right! While aggregate functions can't be directly used in the WHERE clause of most relational databases, you can achieve the desired filtering effect by using a subquery (also called a nested query) or a Common Table Expression (CTE).
@user-rh1hr5cc1r5 ай бұрын
thank you..this what i learned from santosh sir@@KSRDatavizon ... (KSR Student)
@aziserak4743 Жыл бұрын
KSR is one of the best 👌 ❤ thank you ,you're explanation is amazing 👏
@KSRDatavizon Жыл бұрын
You're welcome 😊
@ajinkyashinde1778 Жыл бұрын
Very Well Explained... !!! thank you for the detail and clean answers
@KSRDatavizon Жыл бұрын
You are welcome!
@angadisuhail41742 жыл бұрын
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 ❤️
@KSRDatavizon2 жыл бұрын
Very soon suhail, thank you for the feedback, please do share in your network. Please watch our End to End project here - kzfaq.info/get/bejne/l86BpcuqsNPcd30.html
@meghab2910 Жыл бұрын
Very well explained 👍 please share answers for SQL coding questions
@KSRDatavizon Жыл бұрын
Will upload soon
@NiceThought143 Жыл бұрын
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 🙏🙏🙏🙏
@KSRDatavizon Жыл бұрын
Hi sir, We need a degree to get more opportunities , with a graduation most of the companies won't hire us, you can start learning Data science and start a degree in distance, if possible take Statistics as a specialization. all the best sir.
@sudheer2682 Жыл бұрын
Excellent!!! You are amazing. If you can make a video together with Tableau... that would be great!!!
@KSRDatavizon Жыл бұрын
Very soon! Please subscribe our channel, it motivates a lot
@venkatasivaraobhimanaduni51374 ай бұрын
Great explanation
@KSRDatavizon4 ай бұрын
Thank you for your feedback!
@rafiqalam8418Ай бұрын
Excellent Sir! Appreciating your hard efforts.❤
@KSRDatavizon4 сағат бұрын
Thanks a ton, Please subscribe our channel, its motivates us a lot.
@srinukummari91352 жыл бұрын
It's help ful. But give queries as well. Thanks.
@KSRDatavizon2 жыл бұрын
Ok next time
@easwerprakhyath1878 Жыл бұрын
very useful and very effective
@KSRDatavizon Жыл бұрын
Glad you think so!
@roddam43912 жыл бұрын
Very clearly explained. Worth to watch each n every video of urs 👌👌. Thanks a lot for giving us such good knowledge on subject
@KSRDatavizon2 жыл бұрын
Great.. thanks.. keep watching !!!
@harimca3444Ай бұрын
Really great explanation. Thankyou so much
@KSRDatavizon5 сағат бұрын
You're welcome! I'm glad I could help. If you have any other questions, feel free to ask. Please subscribe our channel for regular updates.
@muralimohan33504 ай бұрын
Thanks a lot for your nice explanation.
@KSRDatavizon4 ай бұрын
Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot
@sravaniT-ur6ns4 ай бұрын
Hi sir Could you please provide answers for coding questions.....
@Curic-Ivan10 ай бұрын
Excellent work! Thank you for sharing your knowledge!
@KSRDatavizon5 ай бұрын
Your appreciation means a lot! I'm grateful for your support.
@jk-sg6xb4 ай бұрын
If u r changing the screen. That will be more helpful for better understanding. ..
@jk-sg6xb4 ай бұрын
Whenever u r explaining explain with example.
@Ali-ds5iy2 жыл бұрын
The way of explanation is awesome sit...Kudos!
@KSRDatavizon2 жыл бұрын
Glad you liked it!
@VenkateshRamesh-qk7nyАй бұрын
THANK YOU SO MUCH FOR THE VIDEO.
@KSRDatavizon4 сағат бұрын
Thank you so much , Please subscribe our channel for regular updtes, its motivates us
@ojusyummyreceipes71982 жыл бұрын
Very nice and useful information 👍
@techdular88 Жыл бұрын
Thanks for this sir.
@KSRDatavizon Жыл бұрын
You are welcome, Please subscribe our channel it motivates us
@SonuSonu-uh2er2 жыл бұрын
Loved your explanation sir. Thank you for this video
@KSRDatavizon2 жыл бұрын
You are most welcome, please do share and subscribe our channel. here is the link for more SQL videos - kzfaq.info/get/bejne/jMB3Zdqgq9Ctj2g.html
@srinivasg13318 ай бұрын
Excellent explanation Bro. Thank you🎉
@KSRDatavizon5 ай бұрын
Your feedback means a lot to me. Thank you for watching!
@hellochandi1 Жыл бұрын
Ossam explain 🎉
@KSRDatavizon Жыл бұрын
Thank you so much, Please subscribe our channel.
@rinkupradhan5085 Жыл бұрын
Thank You brother!! Really very helpful🙏🙏🙏🙏👏👏
@KSRDatavizon Жыл бұрын
Glad it helped
@snehmishra54928 ай бұрын
Thanks Sir, Your videos are really helpful 👍
@KSRDatavizon5 ай бұрын
Thank you so much for the kind words, it means a lot to me.
@MaheshSVB2 жыл бұрын
VERY NICE EXPLANATION AND VERY USE FULL VIDEO
@KSRDatavizon2 жыл бұрын
Thanks a lot Mahesh, keep watch other videos of SQL topics. kzfaq.info/get/bejne/m7SnrJR4v7StmWw.html
@angryff5768 Жыл бұрын
Good explanation sir thank you...i noted everything
@KSRDatavizon Жыл бұрын
All the best
@lakshmajijakka Жыл бұрын
Thank you!
@KSRDatavizon Жыл бұрын
you are welcome, please subscribe our channel for regular updates.
@reddysekharsingadi46232 жыл бұрын
Good job sir
@Ran120242 жыл бұрын
Superb explanation 👏
@narayanjena42592 жыл бұрын
Please upload as soon as possible the interview question on SQL Coding. Also add some more questions in coding questions.
@KSRDatavizon2 жыл бұрын
Sure thanks for suggestions. We will upload more
@informationadda758 Жыл бұрын
The way u explained it ossum dude
@KSRDatavizon Жыл бұрын
Thanks !!!
@akp3410 Жыл бұрын
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
@roymitul Жыл бұрын
I am able to answer 19 questions
@KSRDatavizon Жыл бұрын
great, all the best
@sakshinaik052 жыл бұрын
Sir is it necessary to give a lengthy ans in an interview or I can give crisp and clear to the point ans
@KSRDatavizon2 жыл бұрын
Elaborate answers will give you good impression to panelist
@sujeetmishra6892 Жыл бұрын
Could you please make video on SSIS tutorials and interview questions for beginners to advanced level please. Once you get chance
@KSRDatavizon Жыл бұрын
Sure team, we will plan to make videos on MSBI topics too..
@kalyaninilugonda49202 жыл бұрын
Thankqq sooo much sir for this video and also plzz provide the solve the coding videos sir
@KSRDatavizon2 жыл бұрын
Sure Kalyani, will provide soon
@muralimohan33504 ай бұрын
Nice explanation.
@KSRDatavizon4 ай бұрын
Glad you liked it Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot
@sujeetmishra6892 Жыл бұрын
We'll explained. Thanks man!
@KSRDatavizon Жыл бұрын
Any time! Please subscribe our channel for regular updates
@mohanr4372 Жыл бұрын
👌
@KSRDatavizon Жыл бұрын
thank you, please subscribe our channel,
@SB-ln3ln7 ай бұрын
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
@midunsathiyamoorthy5935 ай бұрын
Thank you,
@KSRDatavizon5 ай бұрын
You are welcome , Please subscribe our channel for regular updates and it motivates us a lot
@Omi12987 Жыл бұрын
Outstanding
@KSRDatavizon Жыл бұрын
thank you so much
@awakenedsouls3206 Жыл бұрын
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 ?
@ashutoshrai2717 Жыл бұрын
Where is this question in this video
@sandipansarkar9211 Жыл бұрын
finished watching
@KSRDatavizon Жыл бұрын
Thank you, Please subscribe our channel for regular updates , all the best
@hncreations8176 Жыл бұрын
Thanks for the questions with answers❤
@KSRDatavizon Жыл бұрын
Thank you so much, Please subscribe our channel for regular updates
@vivekgoyal3545 Жыл бұрын
Any SQL classes sir? I want to learn from scratch any tutorial do u have please inform.
@KSRDatavizon Жыл бұрын
yes, please approach our team, for more details
@endalekinfe33914 ай бұрын
Thanks a lot
@KSRDatavizon4 ай бұрын
Thank you for your support! Please subscribe our channel for regular updates and it motivates us a lot
@rahulgautam5112 жыл бұрын
Great Video Sir
@dattatrayarathi10143 ай бұрын
Thqnk you so much for sharing a video. Its help me a lot to crack the interview. Easy to understand with the explanation 🙏
@sunilkatkar2915 Жыл бұрын
very usefull video
@KSRDatavizon Жыл бұрын
Thanks a lot
@awakenedsouls3206 Жыл бұрын
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 ?
@maheshtiwari2297 Жыл бұрын
You can simple do With cte as ( Select *, row_number() over(partition by Id order by Id) as rnk From temp) Delete from cte Where rnk 1
@financeandtax6016 Жыл бұрын
Thank you amazing contant
@KSRDatavizon Жыл бұрын
You're very welcome
@krishnamurthy79 Жыл бұрын
Very Nice Sir ...
@KSRDatavizon Жыл бұрын
Thank you so much sir , please subscribe our channel
@guilty_rasmus2 жыл бұрын
This video is a gold mine. Thanks you Sir.
@KSRDatavizon2 жыл бұрын
Glad it was helpful!
@shaiksk9078 ай бұрын
Hi Sir, as i understand once commit after transaction we can't rollback either Truncate or Delete or drop.
@KSRDatavizon5 ай бұрын
That's correct! Once a transaction is committed, you can't rollback changes made by Truncate, Delete or Drop operations.
@nomulavijaya7500 Жыл бұрын
Hello sir….Are these still good for Power BI Analyst Role or do you have any updated Questions Videos on SQL and POWER BI.
@KSRDatavizon Жыл бұрын
these question will help for data analyst role interviews and Will upload more soon
@EmDiAverageGamer2 жыл бұрын
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?
@KSRDatavizon2 жыл бұрын
Yes, definitely
@user-lg5ph7qp6t2 ай бұрын
GREAT
@KSRDatavizon2 ай бұрын
Thank you so much for your kind words!
@Sathvik_Gajjela Жыл бұрын
Appreciated
@KSRDatavizon Жыл бұрын
Thank you mam, please subscribe our channel, it motivates us.
@heetshah1881 Жыл бұрын
Hello can you share the coding video questions?
@KSRDatavizon Жыл бұрын
sure will plan shortly , please subscribe our channel for regular updates
@perfectionist66242 жыл бұрын
Hi sir.. waiting for most asked SQL queries interview QnA...
@KSRDatavizon2 жыл бұрын
Ma'am already we have a video on this: kzfaq.info/get/bejne/jKd_o7B5xM-8fXU.html
@manju19947 Жыл бұрын
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
@KSRDatavizon Жыл бұрын
All the best, Please subscribe our channel for regular updates, its motivate us a lot
@dvenki94922 жыл бұрын
Thanks for this Video, can you assist Same for Azure Data Factory, which helps me a lot.
@KSRDatavizon2 жыл бұрын
Thanks for suggestions. We will upload asap
@marcusfegnio1446 Жыл бұрын
HAVING Clause implements in column operation. WHERE Clause implements in row operations. You messed it up, sorry
@KSRDatavizon Жыл бұрын
having is used on aggregated column where as where is used on actual column
@nandanprasadam10 ай бұрын
❤
@KSRDatavizon5 ай бұрын
Thank you so much for your comment, please subscribe our channel for regular updates. it motivates us a lot
@lakshmimanasa72182 жыл бұрын
dml commands are not rollback,but delete can be roolback .
@KSRDatavizon2 жыл бұрын
its DDL not rollback
@vijayachandrareddysingared3271 Жыл бұрын
Hai sir I have a doubt that IN SSMS SQL WE CAN ROLL BACK SOME OF DDL STATEMENTS ALSO.
@KSRDatavizon Жыл бұрын
Hi, 👉Please ping us on WhatsApp wa.me/919916961234 to have a word with our trainer
@sunilkatkar2915 Жыл бұрын
power bi and power service topics upload videos sir