No video

Complete guide to Database Normalization in SQL

  Рет қаралды 164,573

techTFQ

techTFQ

Күн бұрын

Пікірлер: 391
@petruciucur
@petruciucur Жыл бұрын
There is no doubt, for me you are the best Relational Database Management System trainer. The way you explain really makes me understand. Thanks!
@techTFQ
@techTFQ Жыл бұрын
thanks buddy, glad you’ve liked my content
@Maya.1988
@Maya.1988 Жыл бұрын
@@techTFQ Hi any dedicated course is there .... on sql performance and sql admin in Udemy or anywhere I will make my company to buy🙏🔥
@vasuhii2250
@vasuhii2250 Жыл бұрын
Very clearly explained each and every point
@user-zl8hd8if7r
@user-zl8hd8if7r Ай бұрын
the one you are who clarifies the normalization without any doubts thank you so much sir
@mohammedshahil4898
@mohammedshahil4898 Жыл бұрын
One of the most difficult concept explained in the best way possible👌👏🏻 As always a very useful video🙌🏻 No doubt you’re the best SQL trainer out there.
@techTFQ
@techTFQ Жыл бұрын
Thank you bro 😎
@iamnoob7593
@iamnoob7593 Жыл бұрын
Hands Down , Best video on normalization in entire internet.
@greendaywithtrading7408
@greendaywithtrading7408 10 ай бұрын
You’re the best SQL trainer .you teach the thought process ,I think Normalization is a complex concept but after watching your video i feel it will be easy !!!! thank you very much for making it so easy to understand
@techTFQ
@techTFQ 8 ай бұрын
You're welcome ☺️
@sominramchiary5880
@sominramchiary5880 4 ай бұрын
Clear and straightforward explanation, all concept cleared on Normalization, Thank you so much buddy
@suganyanatarajan2661
@suganyanatarajan2661 Жыл бұрын
Best SQL trainer .. you teach the thought process as well which goes a long way! Thank you for all the great work.
@varsharani5601
@varsharani5601 11 ай бұрын
I used to think Normalization as a complex concept. But till the point, I reached in video yet, I am finding it very simple because of your explaining style. Thanks
@anuragshah3433
@anuragshah3433 Жыл бұрын
For those who are confused on transitive dependency in 3NF, if we just look at the output of 2NF, Order_ID -> Order Number and Order number -> Sales contact first name and Order number -> Sale contact second name hence there is a transitive dependency. It was not flagged in 2NF as Order ID -> Sales contact first name and Order Id -> Sales contact second name, hence these are completely dependent on pk as well.
@kunalkumar-hl6gv
@kunalkumar-hl6gv 11 ай бұрын
This is the best video on internet which talks about this topic so perfectly!!!!!!!!!!!!!!!!!!!!! you forced me to comment!!!!!!!!!!!!!!!!!!!!! you are the best out there !!!
@jameskelly3574
@jameskelly3574 2 ай бұрын
just "WOW". I have been struggling to understand normalization for my db class. You used a great visual example and I love how you copied the table from 1 form to the next so we could see the process building upon itself as we get to the higher levels of normalization. You just earned a sub and like. Thanks so much.
@ManojKumar-hy8wc
@ManojKumar-hy8wc Жыл бұрын
Don't stop providing free content bro. Some people really can't afford the bootcamp course. I know it takes lot of effort from you to create the content. But trust me people will always remember you for what you have done.
@RohithS-ig4hl
@RohithS-ig4hl Жыл бұрын
You try spoke facts!
@ManojKumar-hy8wc
@ManojKumar-hy8wc Жыл бұрын
@@RohithS-ig4hl?? You try spoke facts... what does that sentence mean?
@RohithS-ig4hl
@RohithS-ig4hl Жыл бұрын
@@ManojKumar-hy8wc what you said in the comment is true. "people will remember you for what you have done"
@pranajpatil903
@pranajpatil903 2 ай бұрын
I have learned SQL from different platforms but never understood this concept but for the first time i felt it was so easy. Thankyou so much sir for such great videos.
@Fashionsparklers
@Fashionsparklers Жыл бұрын
I found the best tutor to learn the Database and the it's content is very clear to understand. Thanks for the video.
@techTFQ
@techTFQ Жыл бұрын
Glad you liked the content
@shravyatharapatti
@shravyatharapatti 3 ай бұрын
Best way of explaining NF's,First time I understood the concepts clearly.
@parthibangopi8393
@parthibangopi8393 3 ай бұрын
I was very confused in this concept and have seen many videos and no one explained the way you explained. You are awesome. Expecting more videos related to SQL. Thank you
@maheshvaran3342
@maheshvaran3342 8 күн бұрын
Your way of explanation is awesome🙌, This is what I'm expecting. Thanks!
@abhishekpunia606
@abhishekpunia606 6 ай бұрын
"Mind is officially blown! 🤯 Thanks for simplifying Normalization in DBMS with real-world examples. You're a rockstar teacher! 🌟 #DBMSSimplified"
@satyabharadwaj7779
@satyabharadwaj7779 Жыл бұрын
Each time you post a video, I'd always feel that this is the session tailor made for me. This video goes into one of many straight-in and simple to grasp conceptual videos of yours @Thoufiq. If there's anything I can ask, please make videos with mini projects on topics like normalization on complex data. Once again, thanks for sharing such a valuable content!
@techTFQ
@techTFQ Жыл бұрын
Thank you Satya .. much appreciated.. and noted on the suggestion
@sivasrimakurthi206
@sivasrimakurthi206 Жыл бұрын
@@techTFQ I would be eagerly looking for it :-) every time, there is a video from you, it feels like a obligation for me to watch it :-) as I don't want to miss a valuable lesson that you teach. May god bless you and, keep rocking brother.
@techTFQ
@techTFQ Жыл бұрын
Thank you Siva.. very kind of you
@bharath8017
@bharath8017 3 ай бұрын
too good sir,been searching in various other channels for this content but I could not understand anything,but your content and explaination was too good that i can understand by just a single watch
@shadowitself
@shadowitself Жыл бұрын
as soon as I started my journey with sql databases I came across Ur channel every film proves that it was super good choice another great content THX
@jaychavhan6267
@jaychavhan6267 Жыл бұрын
Sir this is what I'm searching for from last couple of days .... Thank you so much 🙏🙏
@techTFQ
@techTFQ Жыл бұрын
Your welcome buddy
@joaofstock
@joaofstock Жыл бұрын
I have to say that I have made 3 courses with modules about data modeling and schemas, and this is the first time that I'm realling understanding how to build an ER Diagram. Many thanks for your explanation and all the best
@mohitdaxini3067
@mohitdaxini3067 Жыл бұрын
Too useful and seemed a relatable example rather than just reading out the definitions like other yt videos do when it comes to SQL normalisation topic...kudos 🏆
@techTFQ
@techTFQ Жыл бұрын
Thanks buddy, glad you like it
@dhanush98b11
@dhanush98b11 7 ай бұрын
Toufiq bro, I can say that you are the gem 💎 For teaching the sql concepts in the most understandable way. I'm working as plsql developer from 2 years without knowing anything about normalization. Thank you bhai for very informative contents on sql ❤.
@souravshome2602
@souravshome2602 Жыл бұрын
No doubt, you are the best sql trainer. After watching your video my all doubts about normalisation is cleared. Never miss your single video. Because of you I got to know lots of concepts about sql. Thank you Sir❤️.
@varshagoel5315
@varshagoel5315 6 ай бұрын
My Goddd!!!!! What an easy explanation of such complex subjects. Great work!!!
@542_jayalaxmi_cse-a2
@542_jayalaxmi_cse-a2 11 ай бұрын
Nice explanation sir I have just started to learn SQL u have cleared the way how to learn in the proper manner
@basavaprabhusherikar7737
@basavaprabhusherikar7737 11 ай бұрын
I had no idea about what is 1NF, 2NF, or anything related to it. But after watching this video I get the idea now. And also why is it good to have different tables, and what kind of anomalies we would be facing if not done. Thanks buddy! Really a very good tutorial. Very clear and detailed explanation.
@suyash7450
@suyash7450 11 ай бұрын
Normalization was topic that used to confuse me very time i saw so much content regarding NFs but getting confused more n more but now after watching ur video i am absolutely clear abut it ...
@Valture.
@Valture. Ай бұрын
Fantastic guide on database normalization! 🌟 This video breaks down complex concepts into easy-to-understand steps, making it accessible for both beginners and intermediate learners. The examples were clear and simple, helping me grasp the importance of each normalization form Kudos to the creator for such an informative and well-structured tutorial. Looking forward to more content like this!
@attilapekkaszabo-iv6tl
@attilapekkaszabo-iv6tl 8 ай бұрын
Brilliant, had this topic way back in Uni, but your explanation is 100x better. Great for refreshing my knowledge.
@techTFQ
@techTFQ 8 ай бұрын
Great to hear
@VaishnaviShinde-hh8sg
@VaishnaviShinde-hh8sg 3 ай бұрын
You are the best teacher.your all sql videos are best for learning. Your explanation throughout the videos is mindblowing. please make more videos on Sql
@quintonbart8452
@quintonbart8452 8 ай бұрын
Absolutley brilliant. I understood the concept immediately. You are an excellent trainer.
@techTFQ
@techTFQ 8 ай бұрын
Glad it was helpful
@poojabagane3691
@poojabagane3691 Жыл бұрын
One of the best video on Normalization I have ever seen... Thank you for this beautiful explanation I got clarification on Normalization in an unequivocal manner.!!!!
@hsudhdhud
@hsudhdhud 6 ай бұрын
Definitely this is one of the best best best best video from an organisation perspective.
@akashchristopher
@akashchristopher 5 ай бұрын
I love the way of your teaching. Crystal clear explanation.. Thank you Toufiq...
@mangeshc1265
@mangeshc1265 Жыл бұрын
The best explanation ever on concept of Normalization. The concept is perfectly understood. kudos!
@techTFQ
@techTFQ Жыл бұрын
Great to hear that
@sudhanshugrover2726
@sudhanshugrover2726 Жыл бұрын
Great explanation Thoufiq. Always a pleasure to watch your videos. I really like the way you channelize your thoughts in an easily comprehensible manner. The speed, clarity and content of your videos are absolutely perfect. Have watched other videos of yours and same opinion goes for them too. Coming to this one, i guess you knowingly kept the sales info till the 3rd step to explain transitive dependency, though you could've eliminated it at the same time you normalized Order/Prod/Cust info, since sales, just like customer, was also absolutely independent of candidate keys. Keep up the good work
@prajackW
@prajackW Жыл бұрын
No one can explain it better than you sir ... thank you very much for making it so easy to understand 🙏♥
@techTFQ
@techTFQ Жыл бұрын
Thanks buddy, much appreciated
@mianawais99
@mianawais99 2 ай бұрын
Best ever detailed and well explained video on DB normalization.
@garrettlassalle6544
@garrettlassalle6544 Жыл бұрын
Thank you for this video. After watching it, I understand it now. You explained it well.
@vignesan4197
@vignesan4197 Жыл бұрын
I love your way of explanation and your SQL series will give a clear idea about basic to advanced levels of SQL skills. Thanks!❤
@dineshvardam2176
@dineshvardam2176 Жыл бұрын
You are really great sir, you explained this complex concept in easiest way...
@mohs8789
@mohs8789 Жыл бұрын
All concepts Explained in really simple ,clear and crisp way.👍
@techTFQ
@techTFQ Жыл бұрын
Thank you 🙏🏼
@parandama4589
@parandama4589 Жыл бұрын
Your a master of RDBS concepts
@vickysreeramadas6386
@vickysreeramadas6386 2 ай бұрын
sir an awesome explanation just like one video whole concept of normalization cleared
@viveksingh524
@viveksingh524 5 ай бұрын
Finally today I learnt normalisation in easy way. Thanks a lot 😊
@minithyagraj6692
@minithyagraj6692 3 ай бұрын
Very well explained! This concept couldn't be made simpler. Thank you!!
@Joshua_t_
@Joshua_t_ Жыл бұрын
Great video. Working through the example database helps a lot.
@ajaychavan1268
@ajaychavan1268 10 ай бұрын
Yeah Tfq. I have no words . You are great come up with more complex sql queries . I am regular viewer hence . Love you from india
@techTFQ
@techTFQ 8 ай бұрын
Thank you very much 😊
@VishalKumar-sc9ep
@VishalKumar-sc9ep 11 ай бұрын
Hats off sir ❤ Now my concepts are crystal clear
@juberbashakhadumiya8527
@juberbashakhadumiya8527 Жыл бұрын
i have watched many normalization videos but your teaching made me to completely understand this concept. Thank you 😊 @Thoufiq bhai
@techTFQ
@techTFQ Жыл бұрын
Glad to know that Basha 👍
@triparnodas2269
@triparnodas2269 Жыл бұрын
You are doing a great job brother, most crystal clear explanation i have found on this topic normalisation, you are making SQL learning a cake walk for all the learners, kudos to you
@techTFQ
@techTFQ Жыл бұрын
Thank you Das .. so glad this helped
@santoshhulloli7625
@santoshhulloli7625 Жыл бұрын
Awesome explanation in a simple way. Superb sir keep it up & thank you so much
@techTFQ
@techTFQ Жыл бұрын
Glad you liked it bro
@santanuroy2121
@santanuroy2121 Жыл бұрын
Hello Thoufiq, as I told in Linkedin that I will watch Normalization... Yes, I watched now... As per I think this video is the most easiest to understand about RDBMS with Normalization those who have fear about Normalization... In the KZfaq, there is no other video content available to beat this video. I am happy and understood fully. Thanks Santanu Roy
@techTFQ
@techTFQ Жыл бұрын
Thank you Santanu 🙏🏼 Super glad you found this helpful
@travelnlearn
@travelnlearn 3 ай бұрын
Amazing video, I completely got entire concept in 1 video
@shorakhutte1887
@shorakhutte1887 Жыл бұрын
Very clearly explained. My doubts got clear. Thanks for providing valuable content.
@HvHv-qd5yu
@HvHv-qd5yu 26 күн бұрын
Excellent way of teaching hats off
@-TechLearning
@-TechLearning 2 ай бұрын
It was really amazing, 🤩 the way you explain the concept is simply awesome. I request you to please make video on same concept with a dataset in SQL and how we need to do in SQL with different queries
@deepkaan
@deepkaan 8 ай бұрын
Thanks for making this video. I was searching for this type of concept. Finally I came across your content.
@techTFQ
@techTFQ 8 ай бұрын
Glad it was helpful
@srinubathina7191
@srinubathina7191 6 ай бұрын
Thank You so much the way of your teaching is excellent sir
@bhupellygopikrishna3039
@bhupellygopikrishna3039 Жыл бұрын
Excellent Explanation, It Cleared every doubt in Normalization. Thanks
@Rajnikapoor-vm4mm
@Rajnikapoor-vm4mm Жыл бұрын
You are truly amazing sir, the way you describe each concept make it so clear and easy .... normalization is the topic which i always get to confuse but your explanation cleared all my doubts... thanks again
@micaelzekarias1537
@micaelzekarias1537 Жыл бұрын
Ur way of explaining things are so interesting. Keep it up. Love ur way of teaching. GBU
@Mind_hit
@Mind_hit Жыл бұрын
Thank you sir the way you explain everything is easy to understand for beginners.
@techTFQ
@techTFQ Жыл бұрын
Glad to know that buddy
@suriyars5662
@suriyars5662 Жыл бұрын
There is no second thought if a video comes by techtfq the thing is it will have some insights which make us even better in that topic so I watch all videos even when I know the concepts also
@bilalshahbazakmal2543
@bilalshahbazakmal2543 Жыл бұрын
Best Chanel for SQL
@techTFQ
@techTFQ Жыл бұрын
Thanks Bilal
@mohs8789
@mohs8789 Жыл бұрын
Yeah indeed.
@yordanosadigo
@yordanosadigo Жыл бұрын
No one explained this like you do....Thank you!
@AparajithaSaravanakumar
@AparajithaSaravanakumar 7 ай бұрын
Best normalisation explanation sir Thank you ❤
@neelamnainiwal6711
@neelamnainiwal6711 Ай бұрын
Well explained. Thank you so much sir. waiting for the videos on indexes, triggers and execution plan etc.
@ananyamitra6645
@ananyamitra6645 9 ай бұрын
you are the gem of a teacher. Thanks
@techTFQ
@techTFQ 8 ай бұрын
Welcome:)
@avinashk8585
@avinashk8585 Жыл бұрын
That's was a great explanation with good examples sir and i learn much about normalization from you.cheers 😀and thank you
@techTFQ
@techTFQ Жыл бұрын
Your welcome buddy .. glad you liked it
@MdNisarAhmed-de7vd
@MdNisarAhmed-de7vd Жыл бұрын
I have read about Normalisation many times from many different sources but never understood so clearly as I did watching your tutorial. Thank you! Keep teaching us ❤️‍🩹✌🏻
@user-tz6ds9uj4m
@user-tz6ds9uj4m 4 ай бұрын
You Simply nailed 👍. Simple and crisp. It would be have been nice if you could explain BCNF, 4NF and 5 NF. Your explanation damn good.
@Naru_NNN
@Naru_NNN Жыл бұрын
Thank you TFQ Such a useful content Make for a learners Once again thanks
@techTFQ
@techTFQ Жыл бұрын
Your well buddy
@hafizmoizmoiz6901
@hafizmoizmoiz6901 4 ай бұрын
Very informative tutorial. All my concepts are clear now. Keep it up ❤
@liberatingpanda7878
@liberatingpanda7878 Жыл бұрын
You should be a lecturer....Made me understood the concept better than my current prof who took 3 hrs and i did not understand sh*t
@manikantashet5921
@manikantashet5921 Жыл бұрын
Amazing explanation and clarity. Thank you!
@breserskcrimp9310
@breserskcrimp9310 Жыл бұрын
best video so far on normalization.
@joshuastates
@joshuastates Жыл бұрын
Great video, Thoufiq. Very clear explanations
@PrithamPranamyaReddy
@PrithamPranamyaReddy 11 ай бұрын
Such a nice way of teaching really the way u r teaching is very well understandable and too full knowledge about subject
@PatrickMuvunyi10
@PatrickMuvunyi10 Жыл бұрын
Thanks for making it crystal clear! Satisfied!
@spiritualthoughts5813
@spiritualthoughts5813 Жыл бұрын
That is very easy and well explained to understand for every one. Thank you Sir
@sher.5027
@sher.5027 Жыл бұрын
Very good I loved the video. The colored data was helpful to understand. Keep your data coloured it helps. And your clear speaking also helps.
@vijaygupta7066
@vijaygupta7066 3 ай бұрын
Till now I read many post articles but unable to understand but from your video I got proper understanding. On KZfaq you and Ankit bansal content are like breaking hard problems and explaining in simple manner
@naveenrawat-yc1op
@naveenrawat-yc1op Жыл бұрын
You are my best best best teacher for me Please teach some Python library like numpy,pandas,matplotlib
@josephaliyu1443
@josephaliyu1443 9 ай бұрын
Best explanation I've seen, thank you 🙏
@techTFQ
@techTFQ 8 ай бұрын
Welcome:)
@Nikhilg-rs7iv
@Nikhilg-rs7iv 4 ай бұрын
Wasted few days watching videos from other channels. Completely I recommend this guys channel anything related to SQL
@aroraaaditya
@aroraaaditya 4 ай бұрын
check jenny lectures bro on normalization makes you unsubscribe this channel
@dannycollins5698
@dannycollins5698 Жыл бұрын
This was a lot of fun and very helpful! You did an excellent job! Liked and subscribed
@harithamenon6384
@harithamenon6384 Жыл бұрын
This helps me to understand the concept clearly.Thank you so much sir!
@techTFQ
@techTFQ Жыл бұрын
Glad this helped
@makav3li665
@makav3li665 5 ай бұрын
Well curated and properly explained 👍
@konikiajaybabuchinu867
@konikiajaybabuchinu867 2 ай бұрын
its very useful to us and wonderful explanation thank you sir
@shashankemani1609
@shashankemani1609 Жыл бұрын
This is a great video with a very clear explanation. Thanks a lot!👏 Please try to make a video on data modelling and data warehousing. 🙏
@adityaf17
@adityaf17 10 ай бұрын
A full video on how someone should normalize the database😍
@david-mc8hc
@david-mc8hc Жыл бұрын
bravo! Very good examples and great/neat presentation! I have been struggling with this topic for quite sometime and now I can put it to rest. Thank you
@shabanabegum3302
@shabanabegum3302 10 ай бұрын
Thank you so much Toufiq! It is beautifully explained, thoroughly understood..
@user-ic8dn1xj5w
@user-ic8dn1xj5w 11 ай бұрын
Really. understood concept of database normalisation. Kindly make a similarlvideo regarding remaining normal forms
@sandeepmanjunath8004
@sandeepmanjunath8004 Жыл бұрын
Thank you looking forward for more sessions like this
@techTFQ
@techTFQ Жыл бұрын
Thanks buddy
@jameselechi6209
@jameselechi6209 6 ай бұрын
Bro burst my brain, you're too good abeg, I swr. After you na you.
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 1,9 МЛН
Practice SQL Interview Query | Big 4 Interview Question
14:47
Matching Picture Challenge with Alfredo Larin's family! 👍
00:37
BigSchool
Рет қаралды 49 МЛН
Чёрная ДЫРА 🕳️ | WICSUR #shorts
00:49
Бискас
Рет қаралды 6 МЛН
SPONGEBOB POWER-UPS IN BRAWL STARS!!!
08:35
Brawl Stars
Рет қаралды 23 МЛН
Running With Bigger And Bigger Feastables
00:17
MrBeast
Рет қаралды 169 МЛН
Database Normalization 1NF 2NF 3NF
10:26
Jesper Lowgren
Рет қаралды 159 М.
Database Normalization 1NF, 2NF, 3NF with Examples
34:32
Cloud Concepts By Chandra
Рет қаралды 1,9 М.
6 SQL Joins you MUST know! (Animated + Practice)
9:47
Anton Putra
Рет қаралды 145 М.
I Studied Data Job Trends for 24 Hours to Save Your Career! (ft Datalore)
13:07
Thu Vu data analytics
Рет қаралды 203 М.
1st, 2nd and 3rd Normal Form (Database Normalisation)
11:42
Learn Learn Scratch Tutorials
Рет қаралды 427 М.
🚨 YOU'RE VISUALIZING YOUR DATA WRONG. And Here's Why...
17:11
Adam Finer - Learn BI Online
Рет қаралды 100 М.
SQL Views Tutorial | VIEWS in SQL Complete Tutorial
43:20
techTFQ
Рет қаралды 267 М.
MSCD600 Normalization
19:25
CCIS Faculty
Рет қаралды 41 М.
Matching Picture Challenge with Alfredo Larin's family! 👍
00:37
BigSchool
Рет қаралды 49 МЛН