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.
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.
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.
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.
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.
"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
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.
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 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.
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?
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??
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
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 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.
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
Hi Vinod - Great question. Thank you for asking. Your timing for this question can't better. Just a few days ago I've started a series on SQL Server Performance Tuning and Query Optimization. The following is the link to the playlist. ua-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html As part of this course we will discuss everything you need to know to tune and improve performance of SQL queries and stored procedures. Hope this helps. If you like reading than watching videos, you can find the associated text articles on our blog at the following link. www.pragimtech.com/blog/sql-optimization/ Hope you will find this SQL course useful.
Hello Sagar - This video is part of SQL Server Interview Questions and Answers playlist. The following is the link to the playlist. Hope you will find it useful. ua-cam.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html
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
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
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
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.
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.
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.
This video helped me clear an interview. Thanks :)
Lovely explanation. Literally needed this.
Thank you so much Sir. Eagerly waiting for the next video.
Wow, Finally Most awaited Topic...
I hope you cover almost all areas regarding the same.
Thanks.
Honestly this first time I now this.
Your videoes must be master classes.
Hello Mohammed - Thank you for the feedback. Means a lot indeed 🙂
I learned a lot from your video tutorials,Teaching is very clear and obviously! on every vacation,I will watch your videos
Still an 3rd year undergrad in computer science, I didn't know that database is a tree data structure this is eye opening.
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.
Hi Sir,
I have following your videos from very long and have learnt a lot.
Thank you
Before watching the video I like it. Because everyone know, there is something new we are going to get.
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!
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.
Thanks for details explanation Venkat. Please start course on ADF.
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!
"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 and simplified content. :) Thanks Venkat :)
you are the best dear brother.
You are doing good job in society
Excellent explanation👏
Amazing content. Hope you can produce more videos on performance increasing.
Love your Videos, please make more content related to the database.
best video in YT!
You are back. Thanks.
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.
Awesome!! Please continue your good work👍
Thank you so much for such wonderful explanation..
This is a good course.. Thanks for making this.
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.
Nice One. Waiting for next
Thanks vankat. I am very interested to learn from the series.
Hi Venkat could you please make a video on EXISTS VS IN
Awesome. Thanks for the new content!! ❤️
Great explanation venkat
Thank you so much sir 🙏🙏
extremely helpful video..
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.
Hi Venkat, Are you offering any courses on advanced SQL server, tsql
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.
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.
Nicely Explained. Thanks
very intutive
Hi you really awesome explainer
Brilliant series
Is it good performance wisd to use Enumeration for indexing?
Thank you!
subscribed, very much informative
Very helpful 👌
Super video very clear
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, very informative
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.
Very 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?
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??
very informative. thank u sir
You are very welcome Mahesh and thank you for the feedback. Hope you are finding our courses useful
Sharing is caring
Please make a video on memory management architecture for sql server. Pls sir
Thank you sir!
Thank you so much. We need AWS tutorial and Devops Tutorial. Could you post?
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 Venkat..Thanks for making videos on performance tuning..Are these concepts of performance tuning same for Oracle pl/sql?
Fascinating
thanks for great job
Thank you sir.
Can you please prove that in logs @5:04 than in a PowerPoint slide
Sir please cover store procedure in deep in sereis thanks lot....for this series
Each table have a node?
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
What if the primary key has got string values?
Hi venkat sir. Pls put the video for data migration from excel into sql...
MR.venkat , first thank you for all tutorial but i need one question . when will introduce tutorial on xamrain
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....
I wonder how data is inserted or deleted?
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?
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
Hello Venkat sir,
Have you stopped doing sessions on Azure ? If so Could you please restart that sir!!!
Hello Sree - Vey sorry about that. I will resume it soon. Thank you for your patience.
Thanks Venkat eagerly awaiting for those videos especially on ACS and AKS
Thank you!
Hi sir. Can you pls make video on advances parys of angular like host bindings..
Thank you Venkat ! Sexiest teacher in 2021 !
Hahaha....Thank you DJ.
how to know a table can store number of rows?limit of row in a table
Heyyy broo,how to improve storedpocedure execution fast?
Hi Vinod - Great question. Thank you for asking. Your timing for this question can't better. Just a few days ago I've started a series on SQL Server Performance Tuning and Query Optimization. The following is the link to the playlist.
ua-cam.com/play/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0.html
As part of this course we will discuss everything you need to know to tune and improve performance of SQL queries and stored procedures. Hope this helps. If you like reading than watching videos, you can find the associated text articles on our blog at the following link.
www.pragimtech.com/blog/sql-optimization/
Hope you will find this SQL course useful.
👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽
Thank You
Super Sir, Can you make videos about ADF..
Thank you Anji. Just to be sure, can you expand ADF. Thank you for your time.
This video under which playlist?
Hello Sagar - This video is part of SQL Server Interview Questions and Answers playlist. The following is the link to the playlist. Hope you will find it useful.
ua-cam.com/play/PL6n9fhu94yhXcztdLO7i6mdyaegC8CJwR.html
Nice explanation, can you start Azure Data Bricks tutorial
Hi Sir, please create a video in table partition in sql server.
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