Wow, that's great news Khalid. Thank you for taking the time to share the good news. Made my day indeed. Good luck and all the very best with your new role.
@@Csharp-video-tutorialsBlogspot Thank you so much sir, this is all because of you. You are the best teacher, the way you are teaching is awesome 🥰 God bless you.
I have cleared 10 interviews by watching your videos and they all were very important for me . Can't describe how well you explain things and clear concepts
Thank you sir for starting the SQL performance Tuning series... Hopefully you cover all the concepts like lazy spooling, hash match, key lookup, partition elimination, Bad views etc.,
Wow....all these are very important SQL concepts Sriharsha. Thank you for asking. I will record and upload as soon as practically possible. Thank you for taking the time to list all these concepts.
Hi Venkat Thank you. I have leant most of microsoft technologies from your videos only. People who comes from non CS/IT background can easy from your video. Kudos to you 🤗 Could you please start a series which demonstrate some real life projects.
Good to see a new video. I listened to your SQL Server Tutorial playlist countless times during my commutes and I finally got a job as a SQL developer. Thanks in part to you.
Hi. I've been learning SQL to get a developer job. I have no prior experience and am from a different educational background. What do you suggest to get that first job as SQL Developer?
@@sulaimandanish4561 Some of things I emphasized in the interview were: 1. I passed the Microsoft exam for Writing SQL Server Queries for 2012/2014 2. My Excel skills, which you will be using constantly in conjunction with SSMS 3. I have SQL Server Development version along with Visual Studio on my home computer and am familiar with writing basic packages in SSIS and writing basic reports in SSRS 4. Watch countless videos and read articles by Venkat, Adam Machanic, Brent Ozar, Itzek Ben-Gan, Bert Wagner, etc and all the free material made available by Microsoft MVPs. And download their code examples. 5. Emphasize any data management you might have done in any job you have had in the past. It took me 3-1/2 years of self-study to move from IT break/fix support to SQL development but it was worth the effort.
You are very welcome Gagan. I will try and cover everything you need to help improve SQL query performance. Please let me know, if you have a specific SQL concept in mind that you want me to discuss in our upcoming SQL videos.
Thanks u sir... Keep share your knowledge. All of your videos are very useful for me. I am continuously referring your channel to increase my knowledge.
Thanks a lot for starting this. You are highly talented person. But my humble request is please do not stop doing Azure videos. Since two weeks I don't see any new videos on azure.
"SQL Server uses a B+-Tree index not the traditional B-Tree index. There are two major differences between traditiona B-Tree index and B+-Tree index: In a B+-Tree index, all of the data is in the leaf level pages. Only key values and pointers exist in the root and intermediate levels. In a B+-Tree index, there are pointers which point to the next and last page in the level. With each page pointing to the page ahead and behind you can do range scans without having to travel up and down the index levels. On Wikipedia here, you will find SQL Server is one of many modern database engines using B+, a reference has been cited in the page. When you read Microsoft documentation here, you know by the description how indexes work on SQL Server that B+ is used and not the traditional B-tree." - Alberto Morillo
Hi Veeran - You are very welcome. Absolutely, that's exactly the plan. In our upcoming SQL videos we will cover everything you need to improve the performance of SQL queries - Creating proper indexes, understanding query execution plans etc. Please let me know if you want me to cover a specific SQL concept that's on your mind. Thank you for taking the time to provide feedback.
You are very welcome Bill and thank you for taking the time to provide feedback. Means a lot. Very glad you are finding our videos easy to follow and understand. All the very best with everything you are doing.
Hi sir ur videos are so helpful and more detailed. Please Cover the topics of SQL server integration services (SSIS) and SQL server reporting services (SSRS).
Hi Venkat,Extremely happy with your videos.Could you please make a video on cpu n memory management.Also if there are particular wait types like resource semaphore,page latch io,sos scheduler yield what steps have to take to over come those??
Sir one request. Can you please schedule a live session where we can give our ideas ,since different people have different problems. Btw thank you for everything you have done to give employment to so many people.🙏🙏
Hello Saurabh - Live session is a good idea. In the mean time if you have specific questions, please feel free to email me on kudvenkat@gmail.com. Happy to help in any way I can. All the best with everything you are doing. Thank you for taking the time.
Hi Venkat, your videos are very insightful. do you think Partitioning (hash based) can improve query performance? this is for very large table having more than 100 million rows. or you think indexes are enough? or combination of partitioning and Indexes would be better approach?
Gr8 gr8 vid like always tnx alotttt i learned a lot from you and still sql server, c# asp. Net core web api... Please keep going Is sill a sql server advanced series? Can you lease in the future make tuts about Xamarin and when. NET 6 is released make a MAUI series And again tnx alotttt
Hi Sir, I'm a 31 Y.O. undergraduate and unable to get a job because of my graduation status. I'm an OCA with good SQL knowledge. I'm stuck with 20K salary for the past few years. I've learnt alot from you. Please help me.
Dear Venkat, I am windows application developer using C# and Sql server as a back end. I want to learnt full stack development. What is best learning path? I have ASP.net, CSS, and Html coding knowledge too. Plesae advice me the best path. Thanks
Sir thank you very much Please do a video on syntax and important rules while writing queries. Like for all types we use single quote and for int type with quote or without quote also executes ... Like this .. As you are more experienced you know some more rules.... I hope you will make videos on this . Thanks
Hello Sohail - Cross Apply and Outer Apply are very important and useful SQL concepts. Thank you for asking. These are actually discussed with an example in our SQL Server Tutorial for Beginners course. The following is the link for the video. Hope you will find it useful. ua-cam.com/video/kVogo0AbatM/v-deo.html
You are really amazing sir, just wanted to know are you going to launch more videos on azure? Also it will be very helpful if you can one video related to azure certification for dot net developer and how prepared for those.
Hi Kudvenkat. Thanks for the video. Can you please make a video to show how to insert into, select delete and update several one to many tables. For example a table student, teacher, address, phone and email. Both the teacher and the students can have several phone number email, phone and address. Thank you
Hello Dam - Yes, you are correct. By default a clustered index is automatically created on the primary key of the table. Hope this helps answer your question. All the very best with everything you are doing.
It took 5 years to get the expected answer for my question "
How is data stored in sql database". Thanks venkat.
So sorry to have kept you waiting Gopichandar. You know, time is the biggest constraint for all of us. Thank you for your patience and understanding.
@@Csharp-video-tutorialsBlogspot thanks venkat, we need you in using java instead of c#
I'm not specialized in SQL, it took me several years to have this question, then I got the answer right after searching 😄
Thank you so much, I learnt a lot from your tutorials and I am a software engineer now. Thumbs Up👍
Wow, that's great news Khalid. Thank you for taking the time to share the good news. Made my day indeed. Good luck and all the very best with your new role.
@@Csharp-video-tutorialsBlogspot Thank you so much sir, this is all because of you. You are the best teacher, the way you are teaching is awesome 🥰 God bless you.
Can you please help me in my final year project i am usin asp.net mvc with sql server as backend
I have cleared 10 interviews by watching your videos and they all were very important for me .
Can't describe how well you explain things and clear concepts
Yeah I hate SQL but managed to watch his video 😅
Wow.....10 interviews. That's amazing. Thank you Yashveer for taking the time to provide feedback. Means a lot.
Thank you sir for starting the SQL performance Tuning series... Hopefully you cover all the concepts like lazy spooling, hash match, key lookup, partition elimination, Bad views etc.,
Wow....all these are very important SQL concepts Sriharsha. Thank you for asking. I will record and upload as soon as practically possible. Thank you for taking the time to list all these concepts.
@@Csharp-video-tutorialsBlogspot hi sir ur video tutorials are damn good and very detailed.
Sir please make a series of SSIS and SSRS.
@@Csharp-video-tutorialsBlogspot Sir, please upload video on above mentioned topics
Hi Venkat Thank you. I have leant most of microsoft technologies from your videos only. People who comes from non CS/IT background can easy from your video. Kudos to you 🤗
Could you please start a series which demonstrate some real life projects.
Mr.kudvenkat your highly talented⭐
Thank you Asha. Means a lot. Made my day indeed. Can't ask for more 🙂
Thanks for the reply
Ur best forever no one can match you
If your content gets 10+Million views, I would still call it underrated. You deserver at least 100+ Million. Respect Sir
There is no word for you sir , the way you are teaching is awesome. I have learn a lot from you. Thank you so much.
Good to see a new video. I listened to your SQL Server Tutorial playlist countless times during my commutes and I finally got a job as a SQL developer. Thanks in part to you.
Hi. I've been learning SQL to get a developer job. I have no prior experience and am from a different educational background. What do you suggest to get that first job as SQL Developer?
@@sulaimandanish4561 Some of things I emphasized in the interview were:
1. I passed the Microsoft exam for Writing SQL Server Queries for 2012/2014
2. My Excel skills, which you will be using constantly in conjunction with SSMS
3. I have SQL Server Development version along with Visual Studio on my home computer and am familiar with writing basic packages in SSIS and writing basic reports in SSRS
4. Watch countless videos and read articles by Venkat, Adam Machanic, Brent Ozar, Itzek Ben-Gan, Bert Wagner, etc and all the free material made available by Microsoft MVPs. And download their code examples.
5. Emphasize any data management you might have done in any job you have had in the past.
It took me 3-1/2 years of self-study to move from IT break/fix support to SQL development but it was worth the effort.
This video helped me clear an interview. Thanks :)
Still an 3rd year undergrad in computer science, I didn't know that database is a tree data structure this is eye opening.
Lovely explanation. Literally needed this.
Thank you so much Sir. Eagerly waiting for the next video.
I learned a lot from your video tutorials,Teaching is very clear and obviously! on every vacation,I will watch your videos
Thanks for details explanation Venkat. Please start course on ADF.
Before watching the video I like it. Because everyone know, there is something new we are going to get.
Sir this series of tuning SQL server really really exciting.. and it add great to our knowledge... Thanks for your phenomenon efforts.. God bless u.
Honestly this first time I now this.
Your videoes must be master classes.
Hello Mohammed - Thank you for the feedback. Means a lot indeed 🙂
Wow, Finally Most awaited Topic...
I hope you cover almost all areas regarding the same.
Thanks.
Thanks sir for this advance topics of SQL. It will be very helpful in improving SQL query performance.
You are very welcome Gagan. I will try and cover everything you need to help improve SQL query performance. Please let me know, if you have a specific SQL concept in mind that you want me to discuss in our upcoming SQL videos.
Your angular playlist helped me lot.
That's great to know. Thank you for taking the time to let us know.
Thanks a ton! U r a blessing to sql beginners!
Hi Sir,
I have following your videos from very long and have learnt a lot.
Thank you
Thanks u sir... Keep share your knowledge. All of your videos are very useful for me. I am continuously referring your channel to increase my knowledge.
Thank you sir. Your way of teaching is truly awesome!
Love your Videos, please make more content related to the database.
Thank you, Mr.Venkat you are wonderful
Thanks a lot for starting this. You are highly talented person. But my humble request is please do not stop doing Azure videos. Since two weeks I don't see any new videos on azure.
Amazing content. Hope you can produce more videos on performance increasing.
You are doing good job in society
Awesome and simplified content. :) Thanks Venkat :)
Thank you so much for such wonderful explanation..
best video in YT!
Thanks vankat. I am very interested to learn from the series.
This is a good course.. Thanks for making this.
"SQL Server uses a B+-Tree index not the traditional B-Tree index. There are two major differences between traditiona B-Tree index and B+-Tree index:
In a B+-Tree index, all of the data is in the leaf level pages. Only key values and pointers exist in the root and intermediate levels.
In a B+-Tree index, there are pointers which point to the next and last page in the level.
With each page pointing to the page ahead and behind you can do range scans without having to travel up and down the index levels.
On Wikipedia here, you will find SQL Server is one of many modern database engines using B+, a reference has been cited in the page.
When you read Microsoft documentation here, you know by the description how indexes work on SQL Server that B+ is used and not the traditional B-tree."
- Alberto Morillo
Awesome!! Please continue your good work👍
Excellent explanation👏
you are the best dear brother.
Awesome. Thanks for the new content!! ❤️
You are back. Thanks.
Thank you so much sir 🙏🙏
Hi Venkat,
Thanks for your videos. I learnt many things by watching your videos. If possible please upload more videos on performance tuning.🙏
Hi Veeran - You are very welcome. Absolutely, that's exactly the plan. In our upcoming SQL videos we will cover everything you need to improve the performance of SQL queries - Creating proper indexes, understanding query execution plans etc. Please let me know if you want me to cover a specific SQL concept that's on your mind. Thank you for taking the time to provide feedback.
@@Csharp-video-tutorialsBlogspot If possible also make videos on the Execution plan and what operators we will see in it.
very intutive
Nice One. Waiting for next
Nicely Explained. Thanks
Thnx alot Brother to explain in very easy form
You are very welcome Bill and thank you for taking the time to provide feedback. Means a lot. Very glad you are finding our videos easy to follow and understand. All the very best with everything you are doing.
extremely helpful video..
Hi Venkat could you please make a video on EXISTS VS IN
Hi sir ur videos are so helpful and more detailed.
Please Cover the topics of SQL server integration services (SSIS) and SQL server reporting services (SSRS).
Thank you, very informative
Thanks alot for sharing valuable knowledge venkat. Keep doing !
You are very welcome Krishna and thank you for taking the time to comment. All the very best with everything you are doing.
@@Csharp-video-tutorialsBlogspot thanks for the response venkat. I wish you a lot of success in everything you do.
Brilliant series
Hi you really awesome explainer
Great explanation venkat
Thank you sir!
Hi Venkat,Extremely happy with your videos.Could you please make a video on cpu n memory management.Also if there are particular wait types like resource semaphore,page latch io,sos scheduler yield what steps have to take to over come those??
Sir one request. Can you please schedule a live session where we can give our ideas ,since different people have different problems.
Btw thank you for everything you have done to give employment to so many people.🙏🙏
Hello Saurabh - Live session is a good idea. In the mean time if you have specific questions, please feel free to email me on kudvenkat@gmail.com. Happy to help in any way I can. All the best with everything you are doing. Thank you for taking the time.
this man is a saint
That's a great honour Jeremy. Thank you. Just trying to share the knowledge I have acquired over the years. As you know, to teach is to learn.
Thank you sir.
Super video very clear
Very Useful
Fascinating
subscribed, very much informative
This really helped. Thank you
That's great to know Shedrack. Very glad you found it useful. Thank you for taking the time to provide feedback.
Thank you so much. We need AWS tutorial and Devops Tutorial. Could you post?
Very helpful 👌
Please make a video on memory management architecture for sql server. Pls sir
very informative. thank u sir
You are very welcome Mahesh and thank you for the feedback. Hope you are finding our courses useful
Hi Venkat, your videos are very insightful. do you think Partitioning (hash based) can improve query performance? this is for very large table having more than 100 million rows. or you think indexes are enough? or combination of partitioning and Indexes would be better approach?
Thank you!
thanks for great job
Gr8 gr8 vid like always tnx alotttt i learned a lot from you and still sql server, c# asp. Net core web api...
Please keep going
Is sill a sql server advanced series?
Can you lease in the future make tuts about Xamarin and when. NET 6 is released make a MAUI series
And again tnx alotttt
Thank You
Sir please cover store procedure in deep in sereis thanks lot....for this series
Hi Venkat..Thanks for making videos on performance tuning..Are these concepts of performance tuning same for Oracle pl/sql?
MR.venkat , first thank you for all tutorial but i need one question . when will introduce tutorial on xamrain
Hi Sir, I'm a 31 Y.O. undergraduate and unable to get a job because of my graduation status. I'm an OCA with good SQL knowledge. I'm stuck with 20K salary for the past few years. I've learnt alot from you. Please help me.
Hello, are you looking for a job?
😂
I'm OCA too, but not related to tech!
Hi venkat sir. Pls put the video for data migration from excel into sql...
Hi Venkat, Are you offering any courses on advanced SQL server, tsql
Is it good performance wisd to use Enumeration for indexing?
Thank you!
Dear Venkat, I am windows application developer using C# and Sql server as a back end. I want to learnt full stack development. What is best learning path? I have ASP.net, CSS, and Html coding knowledge too. Plesae advice me the best path. Thanks
Sir thank you very much
Please do a video on syntax and important rules while writing queries.
Like for all types we use single quote and for int type with quote or without quote also executes ...
Like this ..
As you are more experienced you know some more rules....
I hope you will make videos on this .
Thanks
Hi Shanmukha - Great suggestion. Thank you. Sure, I will record and upload as soon as I can.
@@Csharp-video-tutorialsBlogspot thanks sir ☺️
@@Csharp-video-tutorialsBlogspot sir same like for bool type
We compare with 'false' or 0 both work's....
Sharing is caring
Hi Venkat,
Can you explain more on OuterApply and CrossApply with many examples pls
Hello Sohail - Cross Apply and Outer Apply are very important and useful SQL concepts. Thank you for asking. These are actually discussed with an example in our SQL Server Tutorial for Beginners course. The following is the link for the video. Hope you will find it useful.
ua-cam.com/video/kVogo0AbatM/v-deo.html
YESS
Hi sir. Can you pls make video on advances parys of angular like host bindings..
Kudvenkat Please make video on Power BI
Hello Shibu - Thank you for the suggestion. We will try and cover Power BI in the future. Thank you for your patience and understanding.
@@Csharp-video-tutorialsBlogspot I waiting to learn and explore thanks for replying
Nice explanation, can you start Azure Data Bricks tutorial
You are really amazing sir, just wanted to know are you going to launch more videos on azure? Also it will be very helpful if you can one video related to azure certification for dot net developer and how prepared for those.
Thank you Amit. Yes, the plan is to cover most of azure concepts. Will resume Azure course soon. Thank you for your patience and unerstanding.
Yes @@Csharp-video-tutorialsBlogspot we are eagerly waiting for your Azure Full Course more videos.
Super Sir, Can you make videos about ADF..
Thank you Anji. Just to be sure, can you expand ADF. Thank you for your time.
I wonder how data is inserted or deleted?
Hi Sir, please create a video in table partition in sql server.
👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽
how to know a table can store number of rows?limit of row in a table
Hi Kudvenkat. Thanks for the video. Can you please make a video to show how to insert into, select delete and update several one to many tables. For example a table student, teacher, address, phone and email. Both the teacher and the students can have several phone number email, phone and address. Thank you
Hello Likilik - Absolutely, great SQL question indeed. Sure, I will record and upload soon.
@@Csharp-video-tutorialsBlogspot Thank youu so much. I also want you to know that you are my mentor. Much love from Haiti
Each table have a node?
Thank you Venkat ! Sexiest teacher in 2021 !
Hahaha....Thank you DJ.
What if the primary key has got string values?
Can you please prove that in logs @5:04 than in a PowerPoint slide
Venkat Sir or anyone can you ease clarify one small questikn. If we have a primary key in a table, a clustered index is created automatically on PK?
Hello Dam - Yes, you are correct. By default a clustered index is automatically created on the primary key of the table. Hope this helps answer your question. All the very best with everything you are doing.
@@Csharp-video-tutorialsBlogspot Thank you Venkat sir. Thank god I came to know your channel. One more question. Does each table have a node?