Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For Edureka MySQL DBA training curriculum, Visit our Website: bit.ly/2B5EwLJ
@alexandrospanag4 жыл бұрын
jesus christ you took 15 minutes when my teacher took more than 6 hours and i still hadnt learned anything from! You are a genius sir thank you for the video!
@edurekaIN4 жыл бұрын
Thanks for the compliment! We are glad we could help. Do subscribe to our channel to stay posted on upcoming tutorials.
@DavidEspinosa214 жыл бұрын
1NF: 4:16 2NF: 5:37 3NF: 7:37 BCNF: 9:52
@shatakshipandey39422 жыл бұрын
When my professor was teaching I couldn't understand what was even the need for normalisation let alone itself but u made it clear in the very start. Now my all doubts are clear regarding this. Grateful that I came through this video. Helped alot 👍
@edurekaIN2 жыл бұрын
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
@StateEnemy013 жыл бұрын
I have a textbook that 'explains' this subject. That book could have been written in hieroglyphs and it would make more sense to me. Thank you so much for the very clear explanation! Helps me a lot!
@haniffaris89172 жыл бұрын
But wasn't the table in the 3NF example not yet in 2NF? Isn't Subject (Non-prime attribute) is partially dependent on Subject Id (candidate key)?
@sneharay602 жыл бұрын
The video was really very helpful to me. It's because of the presence of teachers like you that students can understand the topics instantly especially those who don't have tutors
@edurekaIN2 жыл бұрын
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@bhanupriya22442 жыл бұрын
I had left only 1hr for xam I jst saw this video twice nd written the same question, the explanation was very clear can understand easily
@edurekaIN2 жыл бұрын
We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !
@maryamfatima5882 Жыл бұрын
very clean and clear session
@edurekaIN Жыл бұрын
Glad you think so! Keep learning with us..
@mahimsd76454 жыл бұрын
Congratulations for 1 million subscribers ...
@pranavwagh93502 жыл бұрын
what is difference between 2NF and BCNF ?
@pavanputluru34174 жыл бұрын
What is the difference between 2nd and 3rd? By looking at the examples in the video both looks same. Please let me know thanks
@edurekaIN4 жыл бұрын
To make sure that the database must in 2NF, the database should be 1NF and should also have a single-column primary key. Also, to make sure that the database must in 3NF, the database should be in 2NF and must not have any transitive functional dependencies. If you want an example on Normalization, refer to the following article:www.edureka.co/blog/sql-tutorial/#normalization
@dakaninongpluh4556 Жыл бұрын
thank you sir ,very simple and clear explanation
@edurekaIN Жыл бұрын
You're welcome 😊 Glad it was helpful!!! Keep learning with us..
@vaishnaviv71133 жыл бұрын
It's my exam today and that was really helpful thank you very much
@navnathbhure37892 жыл бұрын
One of the best lecture video i have ever watched ..
@edurekaIN2 жыл бұрын
Glad it helped
@mayanksoni214 Жыл бұрын
And this is how I feel in love with the DBMS Subject.
@edurekaIN Жыл бұрын
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@kratikakothari68484 жыл бұрын
Great explanation in jus 13 minutes 🙌👏 Understood the whole concept
@mudassiribad2910 Жыл бұрын
Thank you sir very grateful explanation in simple method very helpful for me by these explanation i had cleared all the doubts regarding this concept
@edurekaIN Жыл бұрын
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@arshiya_838 ай бұрын
thank you so much for amazing session sir 🙂
@edurekaIN7 ай бұрын
Most welcome
@burcukaradag2975 Жыл бұрын
Thank you, you are awesome this is the fifth video that I ve been watching for normalizations, I just understood with your video, thank you very much
@edurekaIN Жыл бұрын
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@afsardesign2 жыл бұрын
Really it is very helpful for me to get clarity about this topic for my upcoming exam Thanks a lot for giving us knowledge 👍👍👏
@edurekaIN2 жыл бұрын
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@andrewkoh96784 жыл бұрын
I understand much clearer now, Thank you!!
@djgulston2 жыл бұрын
What a man! Brilliant explanation! Thank you for this!
@edurekaIN2 жыл бұрын
Thank you so much for the review ,we appreciate your efforts : ) We are glad that you have enjoyed your learning experience with us .Thank You for being a part of our Edureka team : ) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@pravallikamanepalli10612 жыл бұрын
Thank you edureka
@edurekaIN2 жыл бұрын
You're welcome 😊
@Vishnu-ix2di2 жыл бұрын
Thanx for the video. I got clarity on this topic by this video.
@edurekaIN2 жыл бұрын
You're most welcome :) Glad it was helpful !!
@aj7ttt3 жыл бұрын
when I need to understand some topic, I just search topic name + Edureka ✨
@edurekaIN3 жыл бұрын
Hey:) Thank you so much for your sweet words :) Really means a lot ! Glad to know that our content/courses is making you learn better :) Our team is striving hard to give the best content. Keep learning with us -Team Edureka :) Don't forget to like the video and share it with maximum people:) Do subscribe the channel:)
@dhaneshpt8641 Жыл бұрын
Thank you...
@jeevitham2052 жыл бұрын
Clear explanation is super Sir. We need more concept i.e. about keys db commands. How to write queries and also 4nf...
@edurekaIN2 жыл бұрын
It is great to know that our contents are helping you learn better and learn easy ! We are super glad to know and have learners like you with us. We'll definitely take your suggestion to the team and create content on this ! Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@himanshupande37073 жыл бұрын
awesome explanation...clear and precise..
@saltech20242 жыл бұрын
Great explanation!! This may come in handy and clearly understood the concept when you've got a project at hand
@edurekaIN2 жыл бұрын
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@sajidmanzar2 жыл бұрын
What about 4NF and 5NF? Are these two NF really needed in real scenario?
@hopeislife16513 жыл бұрын
Understood sir, thank you
@livefootballmondiale23022 жыл бұрын
very interesting and explicite and easy to understand
@edurekaIN2 жыл бұрын
Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
@lorenzoliswaniso5912 жыл бұрын
Thanks🙏🏽
@mahesh974133 жыл бұрын
Very Nice explanation tq.
@aniketrajapure8251 Жыл бұрын
Thank You
@mumbaikachallenge55262 жыл бұрын
Superb simple and short!❤️
@edurekaIN2 жыл бұрын
Thank you 🙂
@Peeves223 жыл бұрын
Amazing breakdown of a complex concept - thank you!
@shaikmohammed9981 Жыл бұрын
Good explanation👏🏻👏🏻👏🏻👏🏻
@edurekaIN Жыл бұрын
Thank you 😊 Glad it was helpful!!
@rainboww15152 жыл бұрын
Thank you
@amanbhargava27022 жыл бұрын
Thank you😊😊😊
@maneeshapathipati20842 жыл бұрын
Thank u sir it's very ...nice
@edurekaIN2 жыл бұрын
Most welcome 😊 Glad it was helpful!
@complexity88513 жыл бұрын
I wish I had this video when I was in College
@karrisateesh7938 Жыл бұрын
very good explanation.
@edurekaIN Жыл бұрын
Glad you think so!
@kapilkarki16962 жыл бұрын
Thank you for this beautiful and clear explanation bro
@edurekaIN2 жыл бұрын
Hi : ) We really are glad to hear this ! Truly feels good that our team is delivering and making your learning easier :) Keep learning with us .Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@matthewdodson94222 жыл бұрын
THANK YOU for the concise and clear examples!
@edurekaIN2 жыл бұрын
Glad it was helpful!
@masadamsahid Жыл бұрын
Thanks
@mohanreddy24042 жыл бұрын
I think no one can explain better than you..
@edurekaIN2 жыл бұрын
Thank you 😊 Glad it was helpful!
@user-ux4sp3ot2c Жыл бұрын
Very nice.
@franzbiberkopf91794 жыл бұрын
Thank you very much for this from Rome.
@flipflop51892 жыл бұрын
very informative, thank you for posting this!
@edurekaIN2 жыл бұрын
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@nvkchannel82012 жыл бұрын
thanks Sir...too good
@binoyaravind10252 жыл бұрын
Great session with examples
@edurekaIN2 жыл бұрын
Glad you liked it!
@Aspen-s3p2 жыл бұрын
My exams tommorow, this video really helped alot.
@edurekaIN2 жыл бұрын
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@anexusthanatos4021 Жыл бұрын
Great video!! 👍
@edurekaIN Жыл бұрын
Thanks for the visit
@sarmmadd2 жыл бұрын
vv good. explained ccoly. aprreciate it boss.
@edurekaIN2 жыл бұрын
We are very glad to hear that your a learning well with our contents :) continue to learn with us and don't forget to subscribe our channel so that you don't miss any updates !
@moulimallina75014 жыл бұрын
Tq edureka, tq professor
@surya.k77933 жыл бұрын
thank you
@vidyabukitgar4 жыл бұрын
Thank you so much sir nice explanation !!
@jishajustin95232 жыл бұрын
Good explanation. I got it.
@edurekaIN2 жыл бұрын
Thank you for you time in giving a feedback :) We are glad that you are learning from our videos! Stay connected with our channel :)
@Zed.18363 жыл бұрын
this was very helpful thank you for making this!
@jpoezi2 жыл бұрын
sir you are a genius
@priyanshu64652 жыл бұрын
jeez thankyou
@anshumanster3 жыл бұрын
Excellent
@aatmakumar46312 жыл бұрын
Nice class
@alvarobusquets2 жыл бұрын
Edureka is the best school 👍
@edurekaIN2 жыл бұрын
Good To know our videos are helping you learn better :) Stay connected with us and keep learning ! Do subscribe the channel for more updates : )
@jackieboi3214 жыл бұрын
Excellent video
@azmatkhan38953 жыл бұрын
Good explaination Sir...!
@edurekaIN3 жыл бұрын
Thank you so much for your review on our channel Great to hear that Edureka is helping you learn better . We’ll strive to make even better learning contents/courses in the future ! Do subscribe the channel for more updates : )
@delanocripps43392 жыл бұрын
Idea!! Keep going bro
@edurekaIN2 жыл бұрын
Thank you so much : ) We are glad to be a part of your learning journey. Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@pcgmotorsport92992 жыл бұрын
Thank you so much, awesome video
@edurekaIN2 жыл бұрын
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fulfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@marc45943 жыл бұрын
Thank you man, you are great!
@017gowthamarajaam82 жыл бұрын
thanks a lot
@gretelgomezrodriguez40064 жыл бұрын
Great explanation. Thank you!
@muhammadkamranjaved24243 жыл бұрын
Man you are great!!!
@edurekaIN3 жыл бұрын
Thank you for your review : ) We are glad that you found our videos /contents useful . We are also trying our best to further fullqfill your requirements and enhance your expirence :) Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@pavankumarreddykattameddi83853 жыл бұрын
Can u please explain bcnf and super key
@ayamohammed76554 жыл бұрын
Thank you !!
@shravyashetty31152 жыл бұрын
thank you so much
@edurekaIN2 жыл бұрын
You're welcome 😊 Stay connected with our channel and team :) . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@sowmyasunkara71364 жыл бұрын
Thank You sir.
@someshwarans2889 Жыл бұрын
awesome session sir but i need 4nf and 5nf..
@edurekaIN Жыл бұрын
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
@mohdzarrar27934 жыл бұрын
Great explanation.
@s.r.chockklingam39912 жыл бұрын
What's about 4nf & 5nf
@latieshsai5192 Жыл бұрын
sir pls put a video on cyber forensics sir the branch of future cyber security way that proves to be the correct way
@edurekaIN Жыл бұрын
Thanks for showing interest in Edureka kindly visit the channel for more videos our content creators are eagerly waiting for your suggestion to make new videos on your interest :) DO subscribe for the video update
@chodingninjas74153 жыл бұрын
best explanation
@edurekaIN3 жыл бұрын
We are super happy that Edureka is helping you learn better. Your support means a lot to us and it motivated us to create even better learning content and courses experience for you . Do subscribe the channel for more updates : ) Hit the bell icon to never miss an update from our channel : )
@gauravarora84054 жыл бұрын
difference between 2nd and 3rd normal form
@edurekaIN3 жыл бұрын
In 2NF non-prime attributes are allowed to be functionally dependent on non-prime attributes. In 3NF non-prime attributes are only allowed to be functionally dependent on Super key of relation. No partial functional dependency of non-prime attributes are on any proper subset of candidate key is allowed. Hope that solves your query.
@evnraja4 жыл бұрын
well explained
@anushanelevalli14072 жыл бұрын
🙏 srir
@badhavaththukaram95384 жыл бұрын
good 👍
@shivaprasad-kn3kw4 жыл бұрын
can a table have two primary keys
@edurekaIN4 жыл бұрын
We can have only one Primary Key on a table. Keeping this in consideration and to enforce database normalization (third normal form) databases don't allow multiple primary keys on a table. You can create primary key spanning multiple columns. You can also create a UNIQUE constraint on a NOT NULL column.
@vadlapudirajesh4183 Жыл бұрын
❤❤❤❤❤❤❤
@ekant19924 жыл бұрын
And then come NoSQL DB which difies all these ... tech world is bizzare..
@edurekaIN4 жыл бұрын
SQL and NoSQL are used to store different formats of databases. So, both of them stand good against each other and you have to choose which type of database can help you and your organization.
@harshitsrivastava99032 жыл бұрын
😇😇
@prajwalbhat2754 жыл бұрын
Nice sir
@kashyapdamodar73383 жыл бұрын
I couldn't get past the distraction caused by the instructor pronouncing Data as Deeeta. Seemed like a good tutorial otherwise, so truly its my loss.