How is data stored in sql database
ฝัง
- เผยแพร่เมื่อ 26 มี.ค. 2021
- How table data is stored in database | Database index structure | Index B tree structure | Database B tree | B tree in sql server | How is data stored in sql server
Notes and Slides
www.pragimtech.com/blog/sql-o...
SQL Server Tutorial for beginners
• SQL Server tutorial fo...
SQL Server Interview Questions and Answers
• SQL Server Interview Q...
SQL Server Performance Tuning and Query Optimization
• SQL Server Performance... - วิทยาศาสตร์และเทคโนโลยี
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
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
Lovely explanation. Literally needed this.
Thank you so much Sir. Eagerly waiting for the next video.
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.
If your content gets 10+Million views, I would still call it underrated. You deserver at least 100+ Million. Respect Sir
Wow, Finally Most awaited Topic...
I hope you cover almost all areas regarding the same.
Thanks.
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
I learned a lot from your video tutorials,Teaching is very clear and obviously! on every vacation,I will watch your videos
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.
Thanks a ton! U r a blessing to sql beginners!
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.
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.
This video helped me clear an interview. Thanks :)
Hi Sir,
I have following your videos from very long and have learnt a lot.
Thank you
Awesome and simplified content. :) Thanks Venkat :)
Awesome. Thanks for the new content!! ❤️
Still an 3rd year undergrad in computer science, I didn't know that database is a tree data structure this is eye opening.
Thank you, Mr.Venkat you are wonderful
Awesome!! Please continue your good work👍
You are back. Thanks.
Amazing content. Hope you can produce more videos on performance increasing.
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.
Before watching the video I like it. Because everyone know, there is something new we are going to get.
This is a good course.. Thanks for making this.
Thank you sir. Your way of teaching is truly awesome!
Hi Venkat..Thanks for making videos on performance tuning..Are these concepts of performance tuning same for Oracle pl/sql?
Love your Videos, please make more content related to the database.
Nicely Explained. Thanks
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??
Nice One. Waiting for next
Thank you so much for such wonderful explanation..
Thanks for details explanation Venkat. Please start course on ADF.
Great explanation venkat
You are doing good job in society
you are the best dear brother.
Thanks vankat. I am very interested to learn from the series.
Thank you, very informative
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?
Your angular playlist helped me lot.
That's great to know. Thank you for taking the time to let us know.
best video in YT!
Honestly this first time I now this.
Your videoes must be master classes.
Hello Mohammed - Thank you for the feedback. Means a lot indeed 🙂
Very Useful
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.
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.
extremely helpful video..
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).
Fascinating
subscribed, very much informative
Brilliant series
Hi Venkat, Are you offering any courses on advanced SQL server, tsql
very intutive
Super video very clear
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.
Very helpful 👌
Thank you so much sir 🙏🙏
Hi you really awesome explainer
Thank you sir!
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.
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.
thanks for great job
"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 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.
Thank you sir.
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
MR.venkat , first thank you for all tutorial but i need one question . when will introduce tutorial on xamrain
Hi Venkat could you please make a video on EXISTS VS IN
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 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.
Thank you!
very informative. thank u sir
You are very welcome Mahesh and thank you for the feedback. Hope you are finding our courses useful
Thank you so much. We need AWS tutorial and Devops Tutorial. Could you post?
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
Thank You
Please make a video on memory management architecture for sql server. Pls sir
Sir please cover store procedure in deep in sereis thanks lot....for this series
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.
Nice explanation, can you start Azure Data Bricks tutorial
Hi venkat sir. Pls put the video for data migration from excel into sql...
What if the primary key has got string values?
Each table have a node?
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.
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.
th-cam.com/video/kVogo0AbatM/w-d-xo.html
Hi sir. Can you pls make video on advances parys of angular like host bindings..
YESS
I wonder how data is inserted or deleted?
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....
👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽
Hi Sir, please create a video in table partition in sql server.
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
Can you please prove that in logs @5:04 than in a PowerPoint slide
Super Sir, Can you make videos about ADF..
Thank you Anji. Just to be sure, can you expand ADF. Thank you for your time.
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?
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
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.
th-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.
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.
th-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
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
how to know a table can store number of rows?limit of row in a table