I hv heard ur lectures from 2012 nd today due to ur great explainations i have my own software development company in kashmir. thank you so much sir ..
the very best and most complete tutorials I have ever seen. It is like taking a full course over a subject. your work is highly appreciated! By the way, I hope you have time to upload some videos about WPF applications... Thanks a lot man!
I was looking for tutorials on Normalization and I came across this video. I must say you do a very good job at explaining this concept and I appreciate this. Thanks!
I enjoyed watching this video and recommend to others Host explains the content very clearly and looks knowledgeable. Thanks for educating the community and appreciate your volunteership. Thanks a lot
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
very very help full thank u ,it helps a lot when we have such vedios lot of time for goining to institute every day for example if ur far away from institute u hav to travel for hour up hour down for an hour class thanku buddy
we sometimes add redundant data for historical reasons. if we have an order and orderItem and a price then we can calculate the order total cost. If the item price changes, then the total order cost of an old order will be calculated with the new price which will be incorrect. we need to keep the total order cost (calculated) in the table to keep historical data even though it is redundant. hope this helps.
Hi Venkat, I am very happy after watching this videos about normalization and also please Share video about BCNF as well, It will be the great help for me, if you upload. Thanks, Sandesh Reddy
Hi Reynaldo, the description of this video contains the link for "SQL Server Tutorial Playlist", where you can find all the videos in logical sequence. However, you can also search youtube with the following keywords - "Second normal form and third normal form Part 53". Hope you will find it useful. Good Luck. Venkat.
@kudvenkat: in the very first table of the video, i can update departmentHead to 'steve' wherever departmentName is 'IT' using the query 'update set deptHead='steve' where deptName= 'IT'. why do you need to apply normalization here then? its already working that way, isnt it?
+Bishwaroop Chakraborty Yes You can Could Do so..But Just Imagine How Much Time It Would Take to Update all The departmentHead To 'Steve'...Just Assume if There are 3k to 5k Rows
Thank you for the video. Does that mean that in your last example, the table with DeptId and Employee, it satisfies the condition of having a primary key because the primary key consist of the DeptId+Employee column? Meaning it is a composite primary key?
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful. I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you ruclips.net/user/kudvenkatplaylists?view=1&sort=dd If you need DVDs or to download all the videos for offline viewing please visit www.pragimtech.com/kudvenkat_dvd.aspx Slides and Text Version of the videos can be found on my blog csharp-video-tutorials.blogspot.com Tips to effectively use my youtube channel. ruclips.net/video/y780MwhY70s/видео.html If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel. ruclips.net/user/kudvenkat If you like these videos, please click on the THUMBS UP button below the video. May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them. Good Luck Venkat
I would say "Sam,Mike,Shan" is not "naturally atomic" in that being as there is a pattern you can technically in a programming sense separate by commas and then update but the code behind would be unnecessarily inefficient. But so far very nice.
Great video! Just wondering, in the two tables at the end, the second one does not have a primary key which is one of the requirements for 1st normal form. Am I misunderstanding or is it just a mistake?
+gold bouchet Your most welcome. This means a lot. I am very glad you found the videos useful. Dot Net & SQL Server training videos for web developers ruclips.net/user/kudvenkatplaylists?view=1&sort=dd You can order DVDs for offline viewing using the link below www.pragimtech.com/Order.aspx Code Samples & Slides are on my blog csharp-video-tutorials.blogspot.com Tips to effectively use our channel ruclips.net/video/y780MwhY70s/видео.html To receive email alerts, when new videos are uploaded, please subscribe to our channel ruclips.net/user/kudvenkat Please click that THUMBS UP button below the video, if you like the videos Thanks a million for sharing these resources with your friends Best Venkat
at @7:44 another example would be, if IT dept is closed and record deleted, all 3 employees will also get deleted, same case if IT department is updated to some other department.
I think the example given in the end of this video is wrong. We dont need to split the table into dept and employee to make it in 1NF. If we just have Dept_Id, Dept_Name, Emp_Id, Emp_Name, it is still in 1NF as each column is atomic, and there is repetition of group of columns and each row is unique. Example is given is actually in 2NF. Venkat, do you disagree on that?
We can update 50,000 DeptHead names using where condition in Update statement like Update TableName set DeptHead = 'Shafi Shaik' where DeptName = 'IT' .. What about this is this wrong regarding to update name
"THis is part 52 about SQL Server" I watch this video like good episode of television serial..
Thank U Venkat!
Normalization ,my university took me 2 hours to understand. Kudvenkat took me 10 minute (speed:1.5). very excellent lesson . Thank Kudvenkat
I hv heard ur lectures from 2012 nd today due to ur great explainations i have my own software development company in kashmir. thank you so much sir ..
the very best and most complete tutorials I have ever seen. It is like taking a full course over a subject. your work is highly appreciated! By the way, I hope you have time to upload some videos about WPF applications... Thanks a lot man!
thank you very much!! ur work is very much appreciated!
I was looking for tutorials on Normalization and I came across this video. I must say you do a very good job at explaining this concept and I appreciate this.
Thanks!
outstanding methodology, no extra material and to the point description.
this is the best intro to normalization i have seen so far - and i've seen about 2 dozen. thank you. i am hoping the follow ups are just as good.
Awesome Mr. Venkat your tutorials are great..best and easiest to understand
I enjoyed watching this video and recommend to others
Host explains the content very clearly and looks knowledgeable.
Thanks for educating the community and appreciate your volunteership.
Thanks a lot
I was trying to understand this concept right from my graduation.
But I understood it here.
You are amazing...
Thank you very much for taking time to give feedback. In the description of this video, I have included the link for ASP .NET, C#, and SQL Server playlists. All the videos are arranged in logical sequence in these playlists, which could be useful to you. Please share the link with your friends who you think would also benefit from them. If you like these videos, please click on the THUMBS UP button below the video. For email alerts, when new videos are uploaded, you may subscribe to my channel.
Best tutorial videos I have ever seen so far. Very helpful.
That's true!!!
great explanation with nice example.. I got back to sql after years and this got me back on track
Thank you so much Venkat you made my carrier
I am surprised Mr. Venkat. What ever the question I typed in You tube regarding SQL. Your video one of that. Thank You...
Thank you so much! I now fully appreciate the importance of data normalization!
very very help full thank u ,it helps a lot when we have such vedios lot of time for goining to institute every day for example if ur far away from institute u hav to travel for hour up hour down
for an hour class thanku buddy
Venkat You are the best trainer. you helped me in many tutorials..
So thanks for every things you have done for the students!
Awesome, You are the best teacher , I have come across so far.....Kudos venkat
Thank u so much Venkat . This tutorials r really helpful to me . I like Ur style of briefing each and every topic .
we sometimes add redundant data for historical reasons. if we have an order and orderItem and a price then we can calculate the order total cost. If the item price changes, then the total order cost of an old order will be calculated with the new price which will be incorrect. we need to keep the total order cost (calculated) in the table to keep historical data even though it is redundant. hope this helps.
Hi Venkat,
I am very happy after watching this videos about normalization and also please Share video about BCNF as well, It will be the great help for me, if you upload.
Thanks,
Sandesh Reddy
Thanks for the explanation.Excellent and awesome video.
your videos are ultimate
Thank you very much sir....,your teaching style is superb.
Great Teacher ..of this era
This was very helpfull. You are extremely good at explaining!
very good video but please also make video of BCNF Form, 4th form and 5th form.i will be very thankful to u.
Hi Reynaldo, the description of this video contains the link for "SQL Server Tutorial Playlist", where you can find all the videos in logical sequence. However, you can also search youtube with the following keywords - "Second normal form and third normal form Part 53". Hope you will find it useful. Good Luck. Venkat.
@kudvenkat: in the very first table of the video, i can update departmentHead to 'steve' wherever departmentName is 'IT' using the query 'update set deptHead='steve' where deptName= 'IT'. why do you need to apply normalization here then? its already working that way, isnt it?
+Bishwaroop Chakraborty Yes You can Could Do so..But Just Imagine How Much Time It Would Take to Update all The departmentHead To 'Steve'...Just Assume if There are 3k to 5k Rows
Thanks for the explanation.i clearly understood the process.
Nice tutorial, easy and understandable.... Thank you..
Hey Venkat. Thank you so much for your videos. But still have a question. How we have to write a query to break table? Or I missed something....
Thank you for the video. Does that mean that in your last example, the table with DeptId and Employee, it satisfies the condition of having a primary key because the primary key consist of the DeptId+Employee column? Meaning it is a composite primary key?
Thank you very much for clarify this important topic :)
Thank you very much for taking time to give feedback. This means a lot. I am very glad you found the videos useful.
I have organised all the Dot Net & SQL Server videos in to playlists, which could be useful to you
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
If you need DVDs or to download all the videos for offline viewing please visit
www.pragimtech.com/kudvenkat_dvd.aspx
Slides and Text Version of the videos can be found on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use my youtube channel.
ruclips.net/video/y780MwhY70s/видео.html
If you want to receive email alerts, when new videos are uploaded, please subscribe to my youtube channel.
ruclips.net/user/kudvenkat
If you like these videos, please click on the THUMBS UP button below the video.
May I ask you for a favor. I want these tutorials to be helpful for as many people as possible. Please share the link with your friends and family who you think would also benefit from them.
Good Luck
Venkat
Hi Venkat , Thanks for the videos, Can you please make tutorials on SQL disaster recovery and High availability options?
Thank you. This was great explanation.
very very good explanation of all videos.
You are the best sir
Very helpful series.
thanks, very informative video.
Thanks for your knowledge sharing.. thanks a lot
Thank you venkat
nice one, thanx a lot this was helpful
Helpful Tutorials Thanks a lot
thanks sir. love da way u explain :)
best in youtube thx
great video ,but about DML queries performance ,normalization could make them slower because of joins
Can we think that data is repeated in DeptID column so breaking rule of 1st NF here itself ?
i was going to watch this on another channel but im faithful to kudvenkat
AWESOME
AWESOME
How I can assist you?
I would say "Sam,Mike,Shan" is not "naturally atomic" in that being as there is a pattern you can technically in a programming sense separate by commas and then update but the code behind would be unnecessarily inefficient. But so far very nice.
Great video! Just wondering, in the two tables at the end, the second one does not have a primary key which is one of the requirements for 1st normal form. Am I misunderstanding or is it just a mistake?
+Jonas Smith Sure You can Add A Primary Key to Uniquely Identify Each Employee.But For The Sake of Convenience He has Avoided it
thank you very much for sharing.
+gold bouchet Your most welcome. This means a lot. I am very glad you found the videos useful.
Dot Net & SQL Server training videos for web developers
ruclips.net/user/kudvenkatplaylists?view=1&sort=dd
You can order DVDs for offline viewing using the link below
www.pragimtech.com/Order.aspx
Code Samples & Slides are on my blog
csharp-video-tutorials.blogspot.com
Tips to effectively use our channel
ruclips.net/video/y780MwhY70s/видео.html
To receive email alerts, when new videos are uploaded, please subscribe to our channel
ruclips.net/user/kudvenkat
Please click that THUMBS UP button below the video, if you like the videos
Thanks a million for sharing these resources with your friends
Best
Venkat
at @7:44 another example would be, if IT dept is closed and record deleted, all 3 employees will also get deleted, same case if IT department is updated to some other department.
Do you have the follow up for 2nf and 3nf? Thanks.
Thanks for the video
+kudvenkat Do you have videos About
Data raadplegen in SQL
Like (where ,join ,inner join, select, Group by and having...)
Thanks
what if I write query for update tblemp set depthead=`steve` where depdhead=`john` than we need or not normalization
very good explanation
Wo baat alag hai !
Thanks Dear
I think the example given in the end of this video is wrong. We dont need to split the table into dept and employee to make it in 1NF. If we just have Dept_Id, Dept_Name, Emp_Id, Emp_Name, it is still in 1NF as each column is atomic, and there is repetition of group of columns and each row is unique. Example is given is actually in 2NF. Venkat, do you disagree on that?
How can I download ppts of all lectures?
Shit...you've got great videos. You're really a great teacher :)
can you please make a video on BCNF and 4th normal form
great
We can update 50,000 DeptHead names using where condition in Update statement like Update TableName set DeptHead = 'Shafi Shaik' where DeptName = 'IT' .. What about this is this wrong regarding to update name
Thanks
good
@kudvenkat Duplicate data and redundant data are two different things
NOW I HAVE CLEARED WITH NORMAL FORM CONCEPTS WHICH WAS NEVER CLEARED DURING ENGINEERING AND I WAS THINKING THAT IT MUST BE A WASTED TOPIC
watching in 2018
I was trying to understand this concept right from my graduation.
But I understood it here.