MySQL vs MongoDB

hey there everyone that they shear back again with another video and in this video we are talking about MySQL and MongoDB but we are not talking about the differences between MongoDB and MySQL instead we are comparing about the similarities between both of them now I'm a big adversary of comparing one topic to another one for example if you want to learn photoshop and if you already know illustrator it's always a good idea to compare both of them find out the similarities so that you can understand them both properly and in much more depth we're going to do a similar thing with MongoDB and MySQL both are the greatest rock star in their own field and this video is not about which one is best or which one is worst it's not all about them it's about comparing both of them and finding out similarities between them so that if you are coming up from the MySQL background or even if you have heard a little bit things about it it might be a greater transition into the DB so let's get started [Music] [Applause] [Music] so let's go ahead and try to find out the similarities between MySQL and MongoDB and you'll be surprised to know there are so many now of course both are coming up from completely different kind of database styles one I studied in my BTech and when I studied in my Master's again I loved both of them I worked in a variety of projects in both of them so there is no bias thing here I just wanted to give you the brief idea about all of them so on the right hand side we got MySQL here and on the left hand side we got MongoDB now one thing that always amuses me a little bit is all that we call MySQL as a database and MongoDB as a database both are being used to create databases now these databases can be from different project one for lentes 11 code online same can be done in same can be done in MySQL but again it's a little bit kind of a confusing that both are called called as database and we create databases using them so again a little bit personal thing in the world of MySQL we are pretty familiar with the term known as tables we create a lot of tables in MySQL but in the world of MongoDB we called them as collections and we have talked quite a lot in my CDs of MongoDB which is available free on YouTube and these are called as collections so you can compare equivalent of tables in MongoDB is collection another thing in the world of MySQL you are here quite a lot is indexes and in the MongoDB we also do have indexes but don't try don't get confused between the primary key and indexes indexes are completely different primary keys are completely different and we do have concept of indexes in MySQL as well as in MongoDB as well now since we are already talking about the primary Keys let's bring them up in the MySQL world we have the primary key and primary key consists of a huge impact in a linking of the tables and in a whole lot of other things and it has got like the highest conceptual thing in the prime in the MySQL world so similarly we do have primary key in the MySQL in the world of MongoDB we call them as underscore index the underscore is super important the underscore ID field is almost equivalent to primary key the world of MySQL another key concept that comes up quite a lot in the world of MySQL are rows we create a lot of rows once we have created the tables the only way to enter the data is creating a rows of whatever the fields we do require in the world of MongoDB we call them as beasts on document again beasts on is completely different from JSON it's almost equivalent to that syntax why is structure wise it's almost equivalent beasts on just got a few other additional functionality with Jason doesn't have so it's almost like Jason you can call it Jason there's no big deal in that so in the world of MySQL we have got rows while in the world of MongoDB we have got beasts on documents now that we have got tables we have got rows the only thing that's remaining up is to fill these rows with the equivalent of data and for that in the world of MySQL we call them as columns while in the world of MongoDB we call them as fields remember key value pairs that we were entering name hit age email my email there all of these are known as fields again Jason like structure but in the MySQL we call them as column and here we call them as field now coming up for the two very important operations that we usually perform in the world of MySQL and MongoDB again I do agree there are hundreds of such explanations but let's just start with a basic one in the MySQL world the join is or the very key fundamental concept and operation that we perform quite a lot in MongoDB also we perform similar operation we call them either embedding or linking these are almost exactly same as join but in the world of MongoDB we get more freedom and we can either embed our document in itself or we can just link the other document with this document so almost the same operations another fundamental concept that appears quite a lot in the world of MySQL is group by and we already know what is group by in the MySQL world and almost similar operation is there in the world of MongoDB also known as aggregation now these are the similarities between the MongoDB which will help you to transition from the world of MySQL to the world of DP but again we definitely can make a video on differences between MySQL and MongoDB as well and in case you want me to make another video in some kind of comparison chart or something I would love to do that post down in the comment section what we would like to see next in such comparison video I hope you have enjoyed this video because creating this video was so much fun I enjoyed it so much and explaining these concept is my speciality I always love to do and explain these topic in such a unique way and awesome way so that you can understand it nicely in case you have enjoyed this video hit that subscribe button and let me know in the comment section what more comparisons you would like to see on this channel through me so that's it for this video you know the drill you need to hit that like button so that I can get some boost and you also need to hit that subscribe button so that I can give you notification about what's my next video is coming up and what it's all about that's it for this video and make sure you visit learn code online dot in for more amazing courses and videos and that's it I'm going to surely catch you up in the next video [Music] but I guess with me now staring [Music]

Channel: Hitesh Choudhary

Views: 74,805

Keywords: Programming, LearnCodeOnline, mysql vs mongodb, sql vs no sql, comparing mysql with mongoDB

Id: Ke4G-c94VBM

Length: 6min 44sec (404 seconds)

Published: Tue Apr 09 2019