How is data stored in sql database

Подписаться 825 тыс.

Просмотров 171 тыс.

50% 1

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...

Наука

Опубликовано:

26 мар 2021

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 153

@gopichandarselvaraj5250 3 года назад

It took 5 years to get the expected answer for my question " How is data stored in sql database". Thanks venkat.

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@ypwygk652 2 года назад

@@Csharp-video-tutorialsBlogspot thanks venkat, we need you in using java instead of c#

@alonerock136 4 дня назад

I'm not specialized in SQL, it took me several years to have this question, then I got the answer right after searching 😄

@KhalidAfridi1 3 года назад

Thank you so much, I learnt a lot from your tutorials and I am a software engineer now. Thumbs Up👍

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@KhalidAfridi1 3 года назад

@@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.

@jalaluddin1753 3 года назад

Can you please help me in my final year project i am usin asp.net mvc with sql server as backend

@vinitakhatri3192 3 года назад

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.

@ulysses1904 3 года назад

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.

@sulaimandanish4561 3 года назад

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?

@ulysses1904 3 года назад

@@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.

@abhishekbajpai9920 3 года назад

If your content gets 10+Million views, I would still call it underrated. You deserver at least 100+ Million. Respect Sir

@shahabhaidar 3 года назад

Lovely explanation. Literally needed this. Thank you so much Sir. Eagerly waiting for the next video.

@sriharshav9908 3 года назад

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.,

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@jay-js3sx 3 года назад

@@Csharp-video-tutorialsBlogspot hi sir ur video tutorials are damn good and very detailed. Sir please make a series of SSIS and SSRS.

@wasimshah1951 3 года назад

@@Csharp-video-tutorialsBlogspot Sir, please upload video on above mentioned topics

@AmirHussainGaya 3 года назад

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.

@ashajyothi06 3 года назад

Mr.kudvenkat your highly talented⭐

@Csharp-video-tutorialsBlogspot 3 года назад

Thank you Asha. Means a lot. Made my day indeed. Can't ask for more 🙂

@sabnekarasha5381 3 года назад

Thanks for the reply Ur best forever no one can match you

@dhananjaytaher297 3 года назад

Wow, Finally Most awaited Topic... I hope you cover almost all areas regarding the same. Thanks.

@pramodmaurya6610 3 года назад

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.

@jackbeyant9116 3 года назад

I learned a lot from your video tutorials,Teaching is very clear and obviously! on every vacation,I will watch your videos

@jack35411 3 года назад

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

@orllop620 3 года назад

Yeah I hate SQL but managed to watch his video 😅

@Csharp-video-tutorialsBlogspot 3 года назад

Wow.....10 interviews. That's amazing. Thank you Yashveer for taking the time to provide feedback. Means a lot.

@nikunjchaudhary3018 3 года назад

Hi Sir, I have following your videos from very long and have learnt a lot. Thank you

@ramesh5643 3 года назад

Thanks a ton! U r a blessing to sql beginners!

@amitpurohit8816 Год назад

This video helped me clear an interview. Thanks :)

@aniltarimineni3093 3 года назад

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??

@khamakhaengineer 2 года назад

Awesome and simplified content. :) Thanks Venkat :)

@jkdarshni882 3 года назад

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.

@QbutNotTheQ 3 года назад

Awesome. Thanks for the new content!! ❤️

@dharmharley6871 2 года назад

Amazing content. Hope you can produce more videos on performance increasing.

@ajrizaldo4204 2 месяца назад

Still an 3rd year undergrad in computer science, I didn't know that database is a tree data structure this is eye opening.

@rahultripathi8865 3 года назад

Before watching the video I like it. Because everyone know, there is something new we are going to get.

@rizwanriz7455 3 года назад

Awesome!! Please continue your good work👍

@EveryMomMustWatch 3 года назад

Hi Venkat..Thanks for making videos on performance tuning..Are these concepts of performance tuning same for Oracle pl/sql?

@Mshamia 3 года назад

Thank you, Mr.Venkat you are wonderful

@orukundarafamily7954 2 года назад

Thank you sir. Your way of teaching is truly awesome!

@AtulSingh-do6vu 3 года назад

This is a good course.. Thanks for making this.

@anbumani6083 3 года назад

You are back. Thanks.

@SAROJJENAasync 3 года назад

Nice One. Waiting for next

@KiyanshKiya 5 месяцев назад

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?

@jay-js3sx 3 года назад

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).

@shuvo9131 3 года назад

Thanks vankat. I am very interested to learn from the series.

@mohitbutola1140 26 дней назад

Love your Videos, please make more content related to the database.

@saraswathimopidevi8958 4 дня назад

Thanks for details explanation Venkat. Please start course on ADF.

@vinayagamoorthyb7729 3 года назад

Great explanation venkat

@amitamit6564 3 года назад

You are doing good job in society

@rukmininaik987 3 года назад

Thank you so much for such wonderful explanation..

@malojiijolam 7 месяцев назад

Nicely Explained. Thanks

@govindtumati430 3 года назад

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.

@syedfaizullahghori127 3 года назад

Thank you, very informative

@turhansaltas9284 3 года назад

you are the best dear brother.

@rixathe8thcolor 3 года назад

Brilliant series

@gaganupadhyay2175 3 года назад

Thanks sir for this advance topics of SQL. It will be very helpful in improving SQL query performance.

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@magebharath1739 3 года назад

Super video very clear

@mohammedk.h.f3016 3 года назад

Honestly this first time I now this. Your videoes must be master classes.

@Csharp-video-tutorialsBlogspot 3 года назад

Hello Mohammed - Thank you for the feedback. Means a lot indeed 🙂

@13shashikant 3 года назад

Very helpful 👌

@GunaNidhiPokhrel 2 года назад

Very Useful

@Nithin_Coorg 2 года назад

best video in YT!

@PradeepYadav-fg2yg 2 года назад

extremely helpful video..

@akashmakde2683 3 года назад

Your angular playlist helped me lot.

@Csharp-video-tutorialsBlogspot 3 года назад

That's great to know. Thank you for taking the time to let us know.

@jordisarrato331 Год назад

Fascinating

@mohanjangid6 3 года назад

subscribed, very much informative

@UECSaikrishnavaranasi 2 года назад

very intutive

@BBRR442 23 дня назад

Thank you sir!

@krishna6296 3 года назад

Thanks alot for sharing valuable knowledge venkat. Keep doing !

@Csharp-video-tutorialsBlogspot 3 года назад

You are very welcome Krishna and thank you for taking the time to comment. All the very best with everything you are doing.

@krishna6296 3 года назад

@@Csharp-video-tutorialsBlogspot thanks for the response venkat. I wish you a lot of success in everything you do.

@ShivamKendre-fc3su 3 месяца назад

Thank you so much sir 🙏🙏

@grigorkhachatryan1389 3 года назад

thanks for great job

@jeswer9 Год назад

"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

@VaibhavPatil-rx7pc 11 месяцев назад

Hi you really awesome explainer

@michelchaghoury870 3 года назад

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

@veerandarla9147 3 года назад

Hi Venkat, Thanks for your videos. I learnt many things by watching your videos. If possible please upload more videos on performance tuning.🙏

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@veerandarla9147 3 года назад

@@Csharp-video-tutorialsBlogspot If possible also make videos on the Execution plan and what operators we will see in it.

@sisaytadesse3947 2 года назад

Thank you sir.

@siddardhamadala6522 3 года назад

Hi Venkat, Are you offering any courses on advanced SQL server, tsql

@administrator706 3 года назад

Thank you!

@babumalang586 3 года назад

Thank you so much. We need AWS tutorial and Devops Tutorial. Could you post?

@ravindrawakodikar4246 3 года назад

Thank You

@sunny73555 3 года назад

Hi Venkat could you please make a video on EXISTS VS IN

@ahmeddeyab8792 3 года назад

MR.venkat , first thank you for all tutorial but i need one question . when will introduce tutorial on xamrain

@shedrack8237 3 года назад

This really helped. Thank you

@Csharp-video-tutorialsBlogspot 3 года назад

That's great to know Shedrack. Very glad you found it useful. Thank you for taking the time to provide feedback.

@billthomas5529 3 года назад

Thnx alot Brother to explain in very easy form

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@saurabhkumar-lp6de 3 года назад

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.🙏🙏

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@siddharthapandey2711 3 года назад

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.

@Mahesh-ox6sn 3 года назад

very informative. thank u sir

@Csharp-video-tutorialsBlogspot 3 года назад

You are very welcome Mahesh and thank you for the feedback. Hope you are finding our courses useful

@AnilKumar-bd2yt 3 года назад

Please make a video on memory management architecture for sql server. Pls sir

@navneetmishra8423 3 года назад

Sir please cover store procedure in deep in sereis thanks lot....for this series

@sravankumar1767 3 года назад

Nice explanation, can you start Azure Data Bricks tutorial

@jeremyvillar7899 3 года назад

this man is a saint

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@vigneshdharani9565 3 года назад

Hi venkat sir. Pls put the video for data migration from excel into sql...

@KhalidAfridi1 3 года назад

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

@nameoname6702 3 года назад

Hi sir. Can you pls make video on advances parys of angular like host bindings..

@AmitTiwari-us3gh 3 года назад

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.

@Csharp-video-tutorialsBlogspot 3 года назад

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.

@DEEPAKYADAV-rp6rh 3 года назад

Yes @@Csharp-video-tutorialsBlogspot we are eagerly waiting for your Azure Full Course more videos.

@rajansonvane488 2 года назад

Sharing is caring

@surajverma6883 3 года назад

Hi Sir, please create a video in table partition in sql server.

@dam9487 2 года назад

Each table have a node?

@shanmukhapatil7131 3 года назад

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

@Csharp-video-tutorialsBlogspot 3 года назад

Hi Shanmukha - Great suggestion. Thank you. Sure, I will record and upload as soon as I can.

@shanmukhapatil7131 3 года назад

@@Csharp-video-tutorialsBlogspot thanks sir ☺️

@shanmukhapatil7131 3 года назад

@@Csharp-video-tutorialsBlogspot sir same like for bool type We compare with 'false' or 0 both work's....

@sohailsyed5243 3 года назад

Hi Venkat, Can you explain more on OuterApply and CrossApply with many examples pls

@Csharp-video-tutorialsBlogspot 3 года назад

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. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-kVogo0AbatM.html

@UECSaikrishnavaranasi 2 года назад

YESS

@innocentobie5327 3 года назад

👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽👏🏽

@aniketmishra1990 3 года назад

What if the primary key has got string values?

@anjim8507 3 года назад

Super Sir, Can you make videos about ADF..

@Csharp-video-tutorialsBlogspot 3 года назад

Thank you Anji. Just to be sure, can you expand ADF. Thank you for your time.

@fifilulu 3 месяца назад

I wonder how data is inserted or deleted?

@croydon21H 3 года назад

Can you please prove that in logs @5:04 than in a PowerPoint slide

@shibubhai5790 3 года назад

Kudvenkat Please make video on Power BI

@Csharp-video-tutorialsBlogspot 3 года назад

Hello Shibu - Thank you for the suggestion. We will try and cover Power BI in the future. Thank you for your patience and understanding.

@shibubhai5790 3 года назад

@@Csharp-video-tutorialsBlogspot I waiting to learn and explore thanks for replying

@AmarKumar-vo2bv 2 года назад

how to know a table can store number of rows?limit of row in a table

@sidieudelphin1685 3 года назад

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

@Csharp-video-tutorialsBlogspot 3 года назад

Hello Likilik - Absolutely, great SQL question indeed. Sure, I will record and upload soon.

@sidieudelphin1685 3 года назад

@@Csharp-video-tutorialsBlogspot Thank youu so much. I also want you to know that you are my mentor. Much love from Haiti

@sreekanth6180 3 года назад

Hello Venkat sir, Have you stopped doing sessions on Azure ? If so Could you please restart that sir!!!

@Csharp-video-tutorialsBlogspot 3 года назад

Hello Sree - Vey sorry about that. I will resume it soon. Thank you for your patience.

@sreekanth6180 3 года назад

Thanks Venkat eagerly awaiting for those videos especially on ACS and AKS

@dam9487 2 года назад

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?

@Csharp-video-tutorialsBlogspot 2 года назад

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.

@dam9487 2 года назад

@@Csharp-video-tutorialsBlogspot Thank you Venkat sir. Thank god I came to know your channel. One more question. Does each table have a node?

@djjiang3718 3 года назад

Thank you Venkat ! Sexiest teacher in 2021 !

@Csharp-video-tutorialsBlogspot 3 года назад

Hahaha....Thank you DJ.

@vinodgupthachokkarapu6479 3 года назад

Heyyy broo,how to improve storedpocedure execution fast?

@Csharp-video-tutorialsBlogspot 3 года назад

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. ru-vid.com/group/PL6n9fhu94yhXg5A0Fl3CQAo1PbOcRPjd0 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.