I'm working since 3 years as a developer and i thought I'm a Superman in development. But going through this video i can say that i got very much & best technical knowledge... We implements thousands of things from theory but doesn't know their technical definitions and basic. Thank you Manish Sir for this best content. I still remember my struggling days in Mumbai before 4 years ago and at that time too I was referring your videos on C#. At that time I even don't have a money to spend on the courses. But I took benifits from your RUclips channel. Today there are many channels on YT but at that time you was only one who were helping us... I must say that for all developers who come from middle & low class, you are super hero for all of us .... Thank You Sir!!
For quick review. char takes 1 byte per character N in char takes 2 bytes per character Index = increase search performance , balance tree structure, nodes and leaf nodes Index types = Clustered and Non-Clustered Indexes Function = For computations, Only select is allowed, can be call by select and where and from stored procedures, should have 1 input with a return value. type can be scalar and table valued Stored Procedures = CRUD ops, can not be called from select/where/other functions, can have single or multiple outputs, exec Triggers = logic which can be execture after CRUD on any table Trigger Types = after (do something on CRUD) and instead of (do some instead of CRUD or any query) Identity = Auto incremented value of a column, seed Transaction = treat series of activities as one logic unit begin try begin tran insert into table1(column) values(value) insert into table2(column) values(value) commit tran end try begin catch rollback end catch Inner join = Matching records from both tables Left join = All records from table on left side of join and only matching records from right side table of join. Right join = All records from table on right side of join and only matching records from left side table of join. full outer join = all records from both tables are extracted and in case of non matching null is shown cross join = cartesian product, every record of left table is multiplied with right table
You are awesome. I have 6 years of experience in sql server but regarding normal forms and indexes I only knew the definition and never understood the actual concept. After watching this video I have clear understanding and I’ll never forget. You have awesome teaching skills. Thank you so much
So correct, Damn!!! such professors would have made me score 100% during College days. Its not about the student is dumb or intelligent, everyone is intelligent, provided Professors do their job correctly like this person. I doubt any student will ever fail in this kinda lecture.
OLTP - Online Transaction Processing for normalization OLAP - Oonline Analytics Processing for denormalization 1st - Atomic values 2nd - Partial dependency 3rd - Transient dependency 2N - not null, number char -fixed size, varchar - variable size nchar - non English char store unicode 2byte per char index - 2 types: clustered index vs nonclustuered index function vs procedure trigger 2 types: after and instead
Before watching this, I went through many videos and got a little information but this video gave a broader idea in very simple terms. It must be recommended to everyone who is going for an interview for database developer or business intelligence developer.
Thank you 😊sir 🙏you really understood what problems present students are facing and having and knowing partial information. Knowledge is everywhere but it's not enough and complete. Thank you very much of explaning in detail effort of each query. 🙏
Hi Sir, your sql videos are really understandable. I learnt a lot from SQL videos...Thanks a lot!!!! can you please put a video regarding Unix shell scripting..I dont have any idea on UNIX shell scripting.. I like to learn from your video for easy understanding.
Hello Sir, Thank you for the great video . its really helpful for Developers like me. I have a question? On Q13, you mentioned like Non-clustered index depends on Clustered index to locate the data. What if a table has No Clustered index (Or a primary key) ? I think in that case , data is stored in an unordered structure called heap and Non clustered index stores a pointer which refers to the heap storage. Please correct if i am wrong..
Excellent tutorial, thank you! I would expect a question or two about set operators, too. Maybe a good question would be "What's the difference between UNION and UNION ALL?"
I observed something that my attention span as heavly reduced. Your content was really meaningful but my focus was getting diverted. It took my 2 hours to finish this video whereas initially I used to easily focus on watching 3+ hours lectures. Anyway, keep up the good work.
In my opinion you mixed there questions from so different levels of knowledge. Some of them about hard fundamentals are new for me with my fifteen years experience some are so trivial that I think everyone who worked more than half of week can answer it. Especially question 14.
Hey there, excited to discover your channel I am a newbie sql learner with simple enquiry. What is the component of SQL Server Replication? What is it applied for, or what is its basic functionalities in the sql server? Thanks for taking care of this.
Hello sir, thank you vey much for this video it really help me. one question for you (or for anyone for that matter) what is the difference between a join and a Sub-query, i still don`t get it. Gracias
SQL Step by Step - ruclips.net/video/uGlfP9o7kmY/видео.html
SQL Server Joins : ruclips.net/video/KTvYHEntvn8/видео.html
Software Architecture Interview Questions : ruclips.net/video/AtTgcbLOqMM/видео.html
20 MSBI Interview Questions : ruclips.net/video/Nw_sHEKnOUE/видео.html
10+ Power BI Interview Questions : ruclips.net/video/Cozc9WNBRt4/видео.html
Angular Step by Step Tutorial for Beginners : ruclips.net/video/-9VcW7MBDs8/видео.html
25 Angular Interview Questions : ruclips.net/video/-jeoyDJDsSM/видео.html
35 Important JavaScript Interview Questions : ruclips.net/video/Zb4dPi7CANU/видео.html
30 Important C# Interview Questions : ruclips.net/video/BKynEBPqiIM/видео.html
25+ OOPS Interview Questions : ruclips.net/video/u99wAoBjDvQ/видео.html
25 Important ASP.NET Interview Questions : ruclips.net/video/pXmMdmJUC0g/видео.html
20 MySQL Interview Questions : ruclips.net/video/9hfjC-BpY20/видео.html
20 PHP Interview Questions : ruclips.net/video/1bpNSynUrl8/видео.html
5 MSBI Interview Questions : ruclips.net/video/5E815aXAwYQ/видео.html
🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈🙈🙈🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈😊🙈🙈🙈😊🙈🙈🙈😊🙈🙈😊😊😊🙈😊🙈🙈🙈🙈🙈😊😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊😊😊🙈😊🙈😊😊🙈😊🙈🙈🙈🙈😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈🙈😊😊🙈😊😊😊😊😊🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈😊🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈🙈😊🙈🙈😊🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊😊🙈🙈🙈🙈🙈🙈😊🙈🙈🙈🙈🙈😊😊
Need more interview videos on SQL DBA
I share this to my linked in acc but as of now i didnt get any pdf
@@pradeepb4625 PDF will be sent to you after verifying the shared post. thanks.
@@questpondvideos yes i got it, later i check👍
I'm working since 3 years as a developer and i thought I'm a Superman in development. But going through this video i can say that i got very much & best technical knowledge... We implements thousands of things from theory but doesn't know their technical definitions and basic. Thank you Manish Sir for this best content.
I still remember my struggling days in Mumbai before 4 years ago and at that time too I was referring your videos on C#. At that time I even don't have a money to spend on the courses. But I took benifits from your RUclips channel. Today there are many channels on YT but at that time you was only one who were helping us... I must say that for all developers who come from middle & low class, you are super hero for all of us .... Thank You Sir!!
For quick review.
char takes 1 byte per character
N in char takes 2 bytes per character
Index = increase search performance , balance tree structure, nodes and leaf nodes
Index types = Clustered and Non-Clustered Indexes
Function = For computations, Only select is allowed, can be call by select and where and from stored procedures, should have 1 input with a return value. type can be scalar and table valued
Stored Procedures = CRUD ops, can not be called from select/where/other functions, can have single or multiple outputs, exec
Triggers = logic which can be execture after CRUD on any table
Trigger Types = after (do something on CRUD) and instead of (do some instead of CRUD or any query)
Identity = Auto incremented value of a column, seed
Transaction = treat series of activities as one logic unit
begin try
begin tran
insert into table1(column) values(value)
insert into table2(column) values(value)
commit tran
end try
begin catch
rollback
end catch
Inner join = Matching records from both tables
Left join = All records from table on left side of join and only matching records from right side table of join.
Right join = All records from table on right side of join and only matching records from left side table of join.
full outer join = all records from both tables are extracted and in case of non matching null is shown
cross join = cartesian product, every record of left table is multiplied with right table
Please explain CRUD
thanks bhai
Create, Read, Update Delete@@a2zguide216
You are awesome. I have 6 years of experience in sql server but regarding normal forms and indexes I only knew the definition and never understood the actual concept. After watching this video I have clear understanding and I’ll never forget. You have awesome teaching skills. Thank you so much
This video is so much better than all my college lectures combined. Thanks :)
So correct, Damn!!! such professors would have made me score 100% during College days. Its not about the student is dumb or intelligent, everyone is intelligent, provided Professors do their job correctly like this person. I doubt any student will ever fail in this kinda lecture.
I had my full stack interview today and 90% of questions were from your videos 🙏🙏 thank you very much sir your videos really helped me ❤️❤️
Hey girl where r u frm...
OLTP - Online Transaction Processing for normalization
OLAP - Oonline Analytics Processing for denormalization
1st - Atomic values
2nd - Partial dependency
3rd - Transient dependency
2N - not null, number
char -fixed size, varchar - variable size
nchar - non English char store unicode 2byte per char
index - 2 types: clustered index vs nonclustuered index
function vs procedure
trigger 2 types: after and instead
the instructor is very clear and audible.
This video is such a gem ...never understood any concept rather tried to remember to give answer in interview..kudos to you Sir
Before watching this, I went through many videos and got a little information but this video gave a broader idea in very simple terms. It must be recommended to everyone who is going for an interview for database developer or business intelligence developer.
This video is amazing for SQL beginners to condense their SQL knowledge for interviews. Thank yo so much!
One of the best video Frome 2 months of my RUclips search.. waiting for part 2..
if this channel exisited when i did my bachelors, I would have gotten a first class lol.
❤❤
i have share this 2 years back but I haven't any PDF from You but this knowledge very use full for all
so many questions for so many years have been answered here. Thanks so much!
this is probably the best SQL video ive ever seen on youtube holy shit
The basics are very smartly explained. Good knowledge. ❤
Got very much & best technical knowledge though I am into development for 2 Years. Techniques and way of presentation is superb.
Nepal in example made me so connected. Thank you for such a great collection.
If I crack interview with the help of ur questions I really Very Thankful to you...BTW nice information.
Thank you 😊sir 🙏you really understood what problems present students are facing and having and knowing partial information. Knowledge is everywhere but it's not enough and complete. Thank you very much of explaning in detail effort of each query. 🙏
Yes!! Thank you for making this video. Very helpful to us
Very clear and practical explanations, pls send the link for other parts of sql questions and answers sir.!
SQL Server Interview Q&A Part 1 to Part 6 you can avail from here - www.questpond.com/sql-server-interview-questions-and-answers/cid72
very well explanined, and also memorize techniques like APT, NN and inbetween to be motivated 3 PPP...more to go...so good
Thank You :)
Excellent content. Please post the Part 2 and Part 3 links.
Precisely explained.!!
Where can i find the part two of this video
SQL Server Interview Q&A videos are available under subscription - www.questpond.com/sql-server-interview-questions-and-answers/cid72
One another difference between primary and unique key is clustered and non-clustered index respectively
A key by its definition is a unique attribute that identifies a tuple. Here what are you referring to is unique constraint I guess.
@@safsafovski7384 sir, in both keys of course, constraints are applied but how data is managed, is the difference
Happy teacher's day sir. Jai Hind
Watched whole video....this is gold.
great video to go through the Sql within 1 hour . Covered all the parts except functions . Thanks
I love this vidoe thanks alot I'm presently taking classes on SQL server DBA
Very very well explained :)
Amazing content...best video I've ever seen on SQL....13 questions were asked by my interviewer from this video.
Hi Sir,
your sql videos are really understandable. I learnt a lot from SQL videos...Thanks a lot!!!!
can you please put a video regarding Unix shell scripting..I dont have any idea on UNIX shell scripting..
I like to learn from your video for easy understanding.
Super sir this video is very important for the interview question thank you sir
Beautiful explanation. You are graceful.
Very good job. Nice vid. Right to the point with clear and objective answers. Cheers from Portugal 🇵🇹
Thank u so much shiv koirala sir for share the SQL interview questions series.👍
Good and clean explanation.with perfect examples.great job
Tq this is like a revision for my interview on SQL basic part
Amazing explanation sir. A big Thank You! Pleasemake more videos on queries for interview as a Data Scientist and Data Analyst profile specifically.
I have never seen such great voice and great lecture thank you so much sir
Happy Teachers Day !! Shiv Sir.. Your Angular Interview Qns and Azure CI/CD are blessing.
Can you please share Azure CI/CD videos of Shiv sir?
@@tejap7308 +1, please share the link of Azure CI/CD video
Excellent lecture. Thankyou for this :)
Hello Sir, Thank you for the great video . its really helpful for Developers like me. I have a question? On Q13, you mentioned like Non-clustered index depends on Clustered index to locate the data. What if a table has No Clustered index (Or a primary key) ? I think in that case , data is stored in an unordered structure called heap and Non clustered index stores a pointer which refers to the heap storage. Please correct if i am wrong..
I think then it refers to RID (Row ID), right?
Great tutorial! Thanks for the video! I wish you have also covered relationships in SQL. But either way, this is a gem
Great content, except that you can have more than one column be a primary key on the table.
Superb explanation,bestvideo
Excellent tutorial, thank you! I would expect a question or two about set operators, too. Maybe a good question would be "What's the difference between UNION and UNION ALL?"
Union won't display duplicates where as unionall does
@@sandeepkumar-rk7sc ll
Jpoojoooj
Iojip
@@kathayatlakshmi8753 ??
Union all includes duplicate data also
very interested teaching way
Best SQL video I have ever watched
Simply superb...
No words to say you are awesome your way of presentation is very excellent!!!!!!!!!!!!!!!!
I observed something that my attention span as heavly reduced. Your content was really meaningful but my focus was getting diverted. It took my 2 hours to finish this video whereas initially I used to easily focus on watching 3+ hours lectures.
Anyway, keep up the good work.
In my opinion you mixed there questions from so different levels of knowledge. Some of them about hard fundamentals are new for me with my fifteen years experience some are so trivial that I think everyone who worked more than half of week can answer it. Especially question 14.
You are an excellent teacher Sir. Thank you
Hey there, excited to discover your channel
I am a newbie sql learner with simple enquiry.
What is the component of SQL Server Replication? What is it applied for, or what is its basic functionalities in the sql server?
Thanks for taking care of this.
Thanku so much sir for amazing content. You way of explanation is best I must say.
Thank you sir for explaining in easy everyone will understand.
Very easy to understanding
Thank you , very well explained, stay happy sir.
Detailed explanation sir... find it useful.. Thank you :)
Thank you for such in depth defination it helps alot of people 🙏
thanks for the best explanations.
Thank you making videos like this, it is helping me alot. thank you
Very good explanation.. the way you teaching is very interesting.. Thank you!!
this was very helpful for beginners its awesome, easy to understand. Thank you
Concisely presented and very helpful
Thanks for the upload.
Wow..give 5 🌟 amazing explanation
awesome! thank you! and good luck to us reviewing for technical interviews xD
I have shared and mailed you the screenshots, waiting for the wounderfull QA pdf since 2 days :-)
Very nice video. 💯 To the point, no nonsense.
Thanks a lot for the explaining so well sir
wonderfull. Completely clear explanations...LOVE IT.
Wow, you are really clear!
Awesome and very much informative video
Sir really excellent explain everything Also you motivated us in this video thankyou so much for your informative video.
Hello sir, thank you vey much for this video it really help me.
one question for you (or for anyone for that matter) what is the difference between a join and a Sub-query, i still don`t get it.
Gracias
most azure services are introduced in private preview before introduced in public preview, and then in general availability
Good job
Thank you, so much for the beautiful session
very good , thank you very much for this free class.
Great Explanation, Thank you very much.
thank you sir this video was very helpful
really thanks a lot, there is a lot of useful information and tip&tricks and you made them very simple 😁
Very good explanation
Waiting for the next parts. Thankyou so much for the amazing video.
Awesome Preparation sir!!!
Nice video. It's very satisfying to listening
very helpful video, thank you ❤
Excellent material, thank you.
can you please explain the differnece between when to use union and when to use join
Loved your teaching methods!! Crisp and to the point ! Thankyou so very much sir❤❤❤
Thank you so much sir for superb video
Hi sir, ur sql interview questions are very helpful. Thank you for posting. Plz post python interview questions.
It is really helpful for me, thanks
Love that motivation :) Evrything is fair in 'Getting Job' and War :)
Well explained 🙏
wow awesome sir
This is sooo informative. I thank you so much👍
Excellent in Content and Explanation !
Salute, Guruji!