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 RU-vid channel 👉Please ping on WhatsApp wa.me/9916961234
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..
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.
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 🙏
All the best Pranav, please do watch other Power Bi interview videos here ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-hqEoRn5ciXQ.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-AUV6stwRNQM.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-1Hgh3BMQ_TU.html ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-WM7RSMzKrZ8.html
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
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 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 👍👍🙏🙏
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 soon suhail, thank you for the feedback, please do share in your network. Please watch our End to End project here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-ahQrhyKmxGI.html
You are most welcome, please do share and subscribe our channel. here is the link for more SQL videos - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-VZG2woFjI_4.html
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).
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 🙏🙏🙏🙏
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.
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 ?
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 ?
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
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