Best Video on SQL I watched. Appreciated your effort. I watched the video on 2x speed and you gave the clarifications very well. Cannot stop my self to comment. I want to add one one thing Delete and truncate. Delete just delete the rows and new value inserted will be from the next incremented value. Truncate reset the index as well. new value inserted will be from 1
thanks for this video like all of them were my doubts and chock points and thanks for clearing the concept this video cant get more relevant than this tysm!!
RDBMS means where data is stored in tabular form and various tables have relationship among them. E.x. Cassandra stores data as tables but is NOT an RDBMS.
Hello sir your teaching is excellent but, can you explain in English so that other language Students also get better understanding on concept,so please sir I am requesting you explain also in English .
Informative and Concise. explain how to answer if I used a trigger in my project in my interview? I know definition is not enough to crack the interview, they want to know how I used i my project.
kya aap automation sikha sakate hai...??? aur manual ,API,unix, HPALM,JIRA,IB project,test scenario,test case writing, in sub topic ke bhi imp Q.with ans ke liye seperate topicwise vedio bnayenge..? and i request u plz HPALM an JIRA ,test case writing and test scenario kaise bnaye ye achhe se sikha dijiye.
Sir....! If I'm not wrong varchar and varchar2 both sizes are not same. varchar datatype is used to store upto 2000 character where as varchar2 datatype is used to store upto 4000 characters in their particular memory allocation.
Your second highest sal query will not execute becuse u r applying aggregate function like max(sal) with name ,while name is not agg function you have to write 1 more query for that at outer side
11th question answer is wrong like in that command we cannot print name and max(salary ) at time. in aggregated query without group by it does not work
Sir, Will you be able to provide solution for below question? We have two records and five columns. Actually there is Duplicate record in that two records but one column is having different name for two records. So, my question is how to write a SQL query to remove that duplicate record in the Dashboard?
Itna saar gyan pela....aur last me sirf 1 second me thank you bolke video end.
you turely know the value of time for people....salute to you.
1. DBMS & RDBMS
2. Primary Key
3. Foreign Key
4. Constraints & their types.
5. Diff types of SQL commands
6. Diff b/w Delete, Drop & Truncate
7. Diff b/w Group by & Order by
8. Types of Joins
9. Nested subquery vs Correlated subquery
10. Pattern Matching
11. Find 2nd or Nth highest salary
12. SQL vs MySQL(noSQL)
13. Varchar vs Varchar2
14. Triggers
15. ACID properties
Thanks dear 😊
Thank you❤
Tq
madam 12 th question is SQL vs NoSQL sir have also corrected the question
and MySQL is software for SQL
@@satyamthakur-8 dalle
I have watched this man during my Btech (2017-2021) cleared all my exams now preparing for an interview of SQL
Recently gave a written exam in sql and the questions were based on the topics you mentioned above. Thankyou for your guidance.
Very intresting , in 15 min you cover all most all important topics of SQL
Really nice refresher before my Interview. Thank you so much !
Best Video on SQL I watched. Appreciated your effort. I watched the video on 2x speed and you gave the clarifications very well. Cannot stop my self to comment.
I want to add one one thing
Delete and truncate. Delete just delete the rows and new value inserted will be from the next incremented value.
Truncate reset the index as well. new value inserted will be from 1
Excellent class...I am appreciate you sir because u r not take too much to explanation ..it is very good
Sir , you are awesome . I've never seen such an easy explanation of SQL concepts. Thanks a bunch! :)
mamu
A best teacher in you tube world to teach in very easy way .
Forgotten to comment, coming back, it was fantastic session, well summerised, very thankful to you sir❤
Ap kamal ho ❤ hamny to BSCS kia hi apky tutorials dekh dekh k h
Thank You So Much for this wonderful video....🙏🙏🙏
Sir please start a series on important questions for all subjects..
Very needed
good
@@manishasagar4767 hiiii
@@fmpodcast1916🎉🎉🎉❤❤😂🎉😂🎉😂😂😂🎉🎉😂🎉😢❤😢😢😢😢😢😢😢❤😢😢❤🎉😂😂❤😂😂😢❤😢😢🎉😢😢😢😢
@@manishasagar4767kay apko job mili
Outstanding explanation in a very understandable language
In 11th question you can order in descending order ACC to salary can use offset
and limit to get the 2nd highest salary
DSA For the Data related Role :
ruclips.net/p/PLqGLh1jt697wQTamFvXx_Odlm-Wg3zbxq&si=2etKcz_Z3Sn937t7
Awesome lecture
Please make vdos for these subjects
1. Computer Graphics
2. Cloud Computing
3. Blockchain fundamentals
aap beech me khade ho jate ho, fir kuch dikhta nahi hai, itna acchha aap explain karte ho fir ek bar read karna to jaruri hai na
😂😂😂😂😂😂😂
😂😂😂 True
Sahi baat hai
Andha hai kya
sir ,this is so good video that helps and guide for learning more😃😃😃😃
This is really great Thank you ❤
thanks for this video like all of them were my doubts and chock points and thanks for clearing the concept this video cant get more relevant than this tysm!!
My most favorite channel 🤩🤩
Nice Explanation , thank you sir !
Really very nice explaination
very helpful
Excellent boss 👏👏👏👏
Leetcode Top 50 Interview Problems - SQL Playlist
ruclips.net/p/PLsgq4reKtSzyEoZh2_Leks0CxfQb-zfPw
Thank you so much dear. Awesome
Awesome thank you so much sir
Your teaching method is excellent 🥰😍🥰
sir you are best❤🇧🇩
Very well explained Sir 🙏
Very helpful information
Wonderful explanation, thank you so much
Thanks a lot very good explanation
Thank you Sir for excellent content 👏
These 15 minutes video can save us in interview
Very easily explained. Thank you!
Sir please SQL CODING questions bhi krva do for interview 🙏
yess Sirr much need of query questions
nicely exapined
Thank You Sir
Thanks its helps a lot!!!
RDBMS means where data is stored in tabular form and various tables have relationship among them. E.x. Cassandra stores data as tables but is NOT an RDBMS.
Thanks sir....... 😊
You are just awesome sir.. 🙌 tysm.. 💫
Thank you :)
Thanks sir
Thanks bro!❤
Very well explained. Thank you
Thank you so much sir this video really helped for me in my interview
Thanks bro!! today i cleared my interview!!please also add wildcard entry and joins.
kis company mai ? or kya question pucha gya aapse?
Tqsmmmmmm🤩💕
Great Explanation
thank you so much sir, please make similar videos on cn and os as well
Very Easy explanation
Nice
Very nice 👍
Hello sir your teaching is excellent but, can you explain in English so that other language Students also get better understanding on concept,so please sir I am requesting you explain also in English .
Are u from pakistan😅,
Informative and Concise. explain how to answer if I used a trigger in my project in my interview? I know definition is not enough to crack the interview, they want to know how I used i my project.
hi sir pls include diff b/w rank and dense rank also.it is a very imp question asked in interviews
Awesome sir
kya aap automation sikha sakate hai...??? aur manual ,API,unix, HPALM,JIRA,IB project,test scenario,test case writing, in sub topic ke bhi imp Q.with ans ke liye seperate topicwise vedio bnayenge..? and i request u plz HPALM an JIRA ,test case writing and test scenario kaise bnaye ye achhe se sikha dijiye.
Good afternoon sir. Sir kya ap problem solving thought 'c' ka practical ke tyari bhi kar do
Please
brilliant! pls keep it up !
thank you
super awesome
thankyu bro
Nice video
Gud explanation 👍🏼👍🏼👈
sir u left indexing, diff between function and procedures, what is a procedure
Sir....! If I'm not wrong varchar and varchar2 both sizes are not same. varchar datatype is used to store upto 2000 character where as varchar2 datatype is used to store upto 4000 characters in their particular memory allocation.
Yes ...ur right
Yes
Just awesome sir🙏👍
very helpfl thanks a lot
Sir.. your videos are so useful 🙏
Please suggest some books for MCQ for Rajasthan Programmer. Syllabus --- Networking, Data structure
sir abhi ye wala dekh ke viva diya achha gaya sir
Tysm
4:52 Auto Increment is also CONSTRAINTS
Great Video!
Thank you for sharing the imp video
Your second highest sal query will not execute becuse u r applying aggregate function like max(sal) with name ,while name is not agg function you have to write 1 more query for that at outer side
agreed, he providing wrong information he must check things first if they are executing or not.
I am learning from your videos do u have any files or ppt that contain SQL interview questions can u share that ,it would be helpful for me
Good session
Sooo helpful sir
Best ever
11th question answer is wrong like in that command we cannot print name and max(salary ) at time.
in aggregated query without group by it does not work
12:45 its not a good approach you should use offset and limit order bt to solve. This
Thank u sir!!
Sir please make practice video on SQL so can gain practical knowledge about queries that are going to ask in interviews
Sir, please make video on imp questions of operating system
Dear sir can u write a query daily base interest of account add a particular table when amount come in account daily not same
Love from LPU👌
SQL interview questions and answers
ruclips.net/p/PLqGLh1jt697xtgiGwGUTFpOctT82ANdJZ&si=gisoiCt3_Q0Ibpgs
informative video
In interviews they ask scenario type questions... like find no of duplicates, delete duplicates, 7th highest salary...
which company?
Sir pls make one video on Linux interview que. and PLSQL
Just add one more point of normalization here. Thanks you're the best guide to a cs student !
Sir, Will you be able to provide solution for below question?
We have two records and five columns. Actually there is Duplicate record in that two records but one column is having different name for two records. So, my question is how to write a SQL query to remove that duplicate record in the Dashboard?
Then use that column which is having different name
very nice..