title
SQL vs NoSQL - Difference B/W SQL & NoSQL Databases | MySQL vs MongoDB Tutorial | Edureka

description
🔥 MYSQL DBA Certification Training: https://www.edureka.co/search This Edureka video on SQL vs NoSQL will discuss the differences between SQL and NoSQL. It also discusses the differences between MySQL and MongoDB. The following topics will be covered in this video: 1:11 What is SQL? 3:34 What is NoSQL? SQL vs NoSQL 6:35 Type of database 7:33 Schema 8:21 Database Categories 10:21 Complex Queries 11:20 Hierarchical Data Storage 12:05 Scalability 12:37 Language 13:22 Online Processing 15:22 Base Properties 18:02 External Support 19:37 What is MySQL? 22:02 What is MongoDB? MySQL vs MongoDB: 23:25 Query Language 25:07 Flexibility of Schema 26:37 Relationships 27:33 Security 28:21 Performance 29:10 Support 29:28 Key Features 30:16 Replication 31:17 Usage 32:05 Active Community 32:45 Demo Subscribe to our channel to get video updates. Hit the subscribe button above: https://goo.gl/6ohpTV Join Edureka’s Meetup community and never miss any event – YouTube Live, Webinars, Workshops etc. https://bit.ly/2EfTXS1 #edureka #edurekasql #sqlvsnosql#mysqlvsmongodb#sql#nosql#mysql#mongodb -------------------------------------------------------------------------------------------------------- Instagram: https://www.instagram.com/edureka_learning/ Facebook: https://www.facebook.com/edurekaIN/ Twitter: https://twitter.com/edurekain LinkedIn: https://www.linkedin.com/company/edureka SlideShare: https://www.slideshare.net/edurekaIN ------------------------------------------------------------------------------------------------------- How does it work? 1. This is a 4 Week Instructor-led Online Course. 2. The course consists of 24 hours of online classes, 25 hours of assignment, 20 hours of project 3. We have a 24x7 One-on-One LIVE Technical Support to help you with any problems you might face or any clarifications you may require during the course. 4. You will get Lifetime Access to the recordings in the LMS. 5. At the end of the training, you will have to complete the project based on which we will provide you with a Verifiable Certificate! - - - - - - - - - - - - - - About the Course MySQL DBA Certification Training trains you on the core concepts & advanced tools and techniques to manage data and administer the MySQL Database. It includes hands-on learning on concepts like MySQL Workbench, MySQL Server, Data Modeling, MySQL Connector, Database Design, MySQL Command line, MySQL Functions etc. End of the training you will be able to create and administer your own MySQL Database and manage data. - - - - - - - - - - - - - - Who should go for this course? This course can be beneficial for people having the below professional background: Database Developers Application Developers Database Designers Database Administrators - - - - - - - - - - - - - - Project In the project you will be creating a Database using MySQL on SALARY MANAGEMENT SYSTEM :- • Employee list to be maintained having id, name, designation, experience • Salary details having employee id, current salary • Salary in hand details having employee id, CTC salary, pf deduction or any other deduction and net salary to be given and also maintain details of total savings of employee • Salary increment to be given by next year if any depending upon constraints • Deduction in monthly salary if any depending upon any discrepancy in work and amount to be deducted. - - - - - - - - - - - - - - Got a question on the topic? Please share it in the comment section below and our experts will answer it for you. For more information, Please write back to us at sales@edureka.co or call us at IND: 9606058406 / US: 18338555775 (toll free).

detail
{'title': 'SQL vs NoSQL - Difference B/W SQL & NoSQL Databases | MySQL vs MongoDB Tutorial | Edureka', 'heatmap': [{'end': 284.108, 'start': 210.528, 'weight': 1}, {'end': 565.153, 'start': 509.77, 'weight': 0.719}, {'end': 1031.31, 'start': 955.245, 'weight': 0.914}], 'summary': "Compares sql and nosql databases, highlighting sql's structured query language, nosql's schema-less nature, and provides quantifiable data about mysql and mongodb, including support, years in existence, and specific capabilities for large datasets and high throughput operations.", 'chapters': [{'end': 303.8, 'segs': [{'end': 98.09, 'src': 'embed', 'start': 69.157, 'weight': 0, 'content': [{'end': 72.988, 'text': "So let's get started with this session by understanding what is sequel.", 'start': 69.157, 'duration': 3.831}, {'end': 78.433, 'text': 'SQL is a standard language which stands for structured query language.', 'start': 73.909, 'duration': 4.524}, {'end': 83.477, 'text': 'SQL is the core of relational database and is used for accessing and managing the database.', 'start': 78.433, 'duration': 5.044}, {'end': 91.344, 'text': 'So this language basically helps you to retrieve the data from a database whose structure is completely made of tables with rows and columns,', 'start': 83.898, 'duration': 7.446}, {'end': 98.09, 'text': 'and these tables are interlinked with each other with specific values which can be retrieved from these tables with the help of queries as it is.', 'start': 91.344, 'duration': 6.746}], 'summary': 'Sql is a standard language for accessing and managing relational databases.', 'duration': 28.933, 'max_score': 69.157, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk69157.jpg'}, {'end': 293.896, 'src': 'heatmap', 'start': 210.528, 'weight': 1, 'content': [{'end': 213.339, 'text': "So guys, I hope you've understood what sequel is now.", 'start': 210.528, 'duration': 2.811}, {'end': 215.929, 'text': "Let's just understand what is no sequel.", 'start': 213.399, 'duration': 2.53}, {'end': 220.671, 'text': 'No sequel, or most commonly known as not only sequel database,', 'start': 216.568, 'duration': 4.103}, {'end': 225.615, 'text': 'provides a mechanism for storage and retrieval of data and is the next generation database.', 'start': 220.671, 'duration': 4.944}, {'end': 232.36, 'text': 'This kind of database has no specific schema and does not have tables with rows and columns storing data values,', 'start': 226.035, 'duration': 6.325}, {'end': 235.042, 'text': 'but can definitely handle large amount of data.', 'start': 232.36, 'duration': 2.682}, {'end': 242.348, 'text': 'So if you consider the example on the screen, we have an employee database which has two collections that is the employee and the projects collection.', 'start': 235.403, 'duration': 6.945}, {'end': 246.509, 'text': 'Now each of these collections have documents which are basically the data values.', 'start': 242.828, 'duration': 3.681}, {'end': 248.749, 'text': 'So if you just want to understand these terms,', 'start': 246.789, 'duration': 1.96}, {'end': 253.85, 'text': 'then you can just consider the collections to be your tables and the documents to be your fields in the tables.', 'start': 248.749, 'duration': 5.101}, {'end': 258.091, 'text': 'So if you compare a sequel database and a no sequel database, for example,', 'start': 254.191, 'duration': 3.9}, {'end': 263.313, 'text': "let's just say we have an employee database where you know there's an employee table with around 10 columns, right?", 'start': 258.091, 'duration': 5.222}, {'end': 265.033, 'text': 'That is basically the 10 fields.', 'start': 263.493, 'duration': 1.54}, {'end': 267.034, 'text': 'Now in the NoSQL database.', 'start': 265.453, 'duration': 1.581}, {'end': 274.12, 'text': 'what will happen is the employee table itself will be taken as a collection and each of these fields will be considered as documents.', 'start': 267.034, 'duration': 7.086}, {'end': 284.108, 'text': 'Now, the most interesting part of NoSQL is that these kind of databases do not have to use the same schema for the presence of multiple documents in one collection.', 'start': 274.661, 'duration': 9.447}, {'end': 288.011, 'text': 'So, since NoSQL has dynamic schema, that means that you know,', 'start': 284.468, 'duration': 3.543}, {'end': 293.896, 'text': 'multiple documents can be present in a single collection and also each collection can have different documents.', 'start': 288.011, 'duration': 5.885}], 'summary': 'Nosql databases store data with dynamic schema, enabling storage of multiple documents in a single collection.', 'duration': 83.368, 'max_score': 210.528, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk210528.jpg'}], 'start': 11.448, 'title': 'Database face-off: sql vs nosql', 'summary': "Compares sql and nosql databases, highlighting sql's structured query language for managing well-structured databases and nosql's schema-less nature and ability to handle large data volumes.", 'chapters': [{'end': 303.8, 'start': 11.448, 'title': 'Database face-off: sql vs nosql', 'summary': "Discusses the comparison between sql and nosql databases, emphasizing sql's structured query language for retrieving and managing data from well-structured databases, and nosql's next-generation database with no specific schema and the ability to handle large amounts of data.", 'duration': 292.352, 'highlights': ['SQL is a standard language for accessing and managing relational databases, enabling data retrieval through structured query language and maintaining various types of relationships such as one-to-one, one-to-many, many-to-many, and self-referencing relationships. SQL enables retrieval and manipulation of data from well-structured databases and maintenance of relationships between tables.', 'NoSQL databases have no specific schema and do not use tables with rows and columns, instead they use collections and documents to store data, allowing dynamic schema and the presence of multiple documents in one collection with different structures. NoSQL databases handle large amounts of data and allow dynamic schema with the presence of multiple documents in one collection.']}], 'duration': 292.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk11448.jpg', 'highlights': ['SQL enables retrieval and manipulation of data from well-structured databases and maintenance of relationships between tables.', 'NoSQL databases handle large amounts of data and allow dynamic schema with the presence of multiple documents in one collection.']}, {'end': 905.344, 'segs': [{'end': 343.582, 'src': 'embed', 'start': 304.18, 'weight': 0, 'content': [{'end': 309.583, 'text': "So that's how guys you can play around with collections and documents in NoSQL database apart from this.", 'start': 304.18, 'duration': 5.403}, {'end': 314.125, 'text': 'Let me just also tell you that you know, there is no specific query language present in NoSQL.', 'start': 309.783, 'duration': 4.342}, {'end': 319.127, 'text': 'So, basically, the language that you use to retrieve data is completely infrastructure based.', 'start': 314.685, 'duration': 4.442}, {'end': 322.188, 'text': 'that is basically how you store your data and where you store your data.', 'start': 319.127, 'duration': 3.061}, {'end': 327.171, 'text': 'Lastly, there are no or very few relationships present in a no sequel database,', 'start': 322.709, 'duration': 4.462}, {'end': 334.334, 'text': 'as you do not have a predefined schema but you do have a dynamic schema in which we can put all the required information in a collection right?', 'start': 327.171, 'duration': 7.163}, {'end': 343.582, 'text': 'When you have a dynamic schema and you have the option of putting all the required information in a single collection and the collection can differ in the same schema itself.', 'start': 334.754, 'duration': 8.828}], 'summary': 'Nosql databases have no specific query language, few relationships, and dynamic schemas.', 'duration': 39.402, 'max_score': 304.18, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk304180.jpg'}, {'end': 407.778, 'src': 'embed', 'start': 383.846, 'weight': 2, 'content': [{'end': 390.969, 'text': 'complex queries, hierarchical data storage, scalability, language, online processing, base properties and external support.', 'start': 383.846, 'duration': 7.123}, {'end': 396.348, 'text': "Let's get into the detail with the first comparison factor that is type of database.", 'start': 391.844, 'duration': 4.504}, {'end': 404.535, 'text': 'Now, when we compare these databases based on this factor, let me just tell you that you know sequel is essentially called a relational database,', 'start': 397.049, 'duration': 7.486}, {'end': 407.778, 'text': 'and it organizes structured data fields into defined columns.', 'start': 404.535, 'duration': 3.243}], 'summary': 'Comparison of databases: sql is a relational database for structured data.', 'duration': 23.932, 'max_score': 383.846, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk383846.jpg'}, {'end': 565.153, 'src': 'heatmap', 'start': 509.77, 'weight': 0.719, 'content': [{'end': 518.955, 'text': 'the sequel databases can have n number of tables related to each other and each table can have M number of rows and columns storing data in each cell of the data.', 'start': 509.77, 'duration': 9.185}, {'end': 527.902, 'text': 'Now. similarly, if we talk about the NoSQL databases, the NoSQL databases have mainly four categories of databases, that is, document database,', 'start': 519.455, 'duration': 8.447}, {'end': 532.926, 'text': 'the key value stores to graph stores and the white column stores coming to the document database.', 'start': 527.902, 'duration': 5.024}, {'end': 538.571, 'text': 'Now this kind of database pairs each key with a complex data structure known as a document.', 'start': 533.186, 'duration': 5.385}, {'end': 543.375, 'text': 'it can contain many different key value pairs or the key error pairs, or even the nested documents.', 'start': 538.571, 'duration': 4.804}, {'end': 545.176, 'text': 'Coming to the key value stores.', 'start': 543.775, 'duration': 1.401}, {'end': 547.939, 'text': 'These are the simplest form of NoSQL database.', 'start': 545.437, 'duration': 2.502}, {'end': 555.945, 'text': 'So every single item in the database is stored as an attribute name or a key together with its value now coming to the craft stores.', 'start': 548.219, 'duration': 7.726}, {'end': 560.809, 'text': 'The craft stores are basically used to store the information about networks such as the social connections.', 'start': 556.065, 'duration': 4.744}, {'end': 565.153, 'text': 'Now the craft stores mainly include the Neo4j and the hypergraph TV.', 'start': 561.13, 'duration': 4.023}], 'summary': 'Sql databases can have n tables with m rows and columns, while nosql databases have 4 categories: document, key-value, graph, and wide-column stores.', 'duration': 55.383, 'max_score': 509.77, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk509770.jpg'}, {'end': 712.56, 'src': 'embed', 'start': 682.503, 'weight': 3, 'content': [{'end': 689.746, 'text': 'Now when we compare the databases based on this factor, let me tell you that the sequel databases are not best fit for hierarchical data storage.', 'start': 682.503, 'duration': 7.243}, {'end': 696.97, 'text': 'Now. this is because, as the number of tables increase, the complexity of relating them to each other also keeps increasing.', 'start': 690.207, 'duration': 6.763}, {'end': 704.593, 'text': 'now, in such a scenario, you cannot relate humongous amount of tables with n number of columns to each other right, but coming to no sequel database.', 'start': 696.97, 'duration': 7.623}, {'end': 712.56, 'text': 'the no sequel database fits better for hierarchical data storage, as it follows the key value pair way of storing data, similar to the chase on data.', 'start': 704.593, 'duration': 7.967}], 'summary': 'Sql databases are not ideal for hierarchical data storage due to increasing complexity, while nosql databases are better suited for it.', 'duration': 30.057, 'max_score': 682.503, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk682503.jpg'}, {'end': 772.516, 'src': 'embed', 'start': 737.604, 'weight': 5, 'content': [{'end': 739.024, 'text': 'on a single server.', 'start': 737.604, 'duration': 1.42}, {'end': 742.727, 'text': 'on the other hand, the no sequel databases are horizontally scalable.', 'start': 739.024, 'duration': 3.703}, {'end': 749.491, 'text': 'You can do load balancing by adding more servers to your cluster so that with the help of these servers you can handle large traffic.', 'start': 743.147, 'duration': 6.344}, {'end': 756.511, 'text': 'So on the note of scalability sequel is vertically scalable and no sequel is horizontally scalable next.', 'start': 750.049, 'duration': 6.462}, {'end': 765.294, 'text': "We'll be comparing these databases based on language the sequel databases have a specific language and it does not vary from database to database.", 'start': 756.591, 'duration': 8.703}, {'end': 772.516, 'text': 'So basically the sequel databases use the structured query language for defining and manipulating the data, which is very powerful.', 'start': 765.714, 'duration': 6.802}], 'summary': 'Sql databases are vertically scalable, while nosql databases are horizontally scalable for better handling of large traffic.', 'duration': 34.912, 'max_score': 737.604, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk737604.jpg'}, {'end': 864.623, 'src': 'embed', 'start': 840.198, 'weight': 6, 'content': [{'end': 849.285, 'text': 'So if I have to just explain these terms OLTP and OLAP for you, then OLTP is basically characterized by large number of short online transactions,', 'start': 840.198, 'duration': 9.087}, {'end': 851.046, 'text': 'such as insert, update and delete.', 'start': 849.285, 'duration': 1.761}, {'end': 856.42, 'text': 'The main emphasis for OLTP systems is to put on a very fast query processing,', 'start': 851.559, 'duration': 4.861}, {'end': 864.623, 'text': 'maintain data Integrity in multi-axis environments and an effectiveness measured by number of transactions per second in OLTP databases.', 'start': 856.42, 'duration': 8.203}], 'summary': 'Oltp emphasizes fast query processing and data integrity, measured by transactions per second.', 'duration': 24.425, 'max_score': 840.198, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk840198.jpg'}], 'start': 304.18, 'title': 'Nosql vs. sql databases', 'summary': 'Compares nosql and sql databases, emphasizing differences such as absence of query language and predefined schema in nosql, dynamic schema, lack of relationships, and suitability for hierarchical data storage and scalability.', 'chapters': [{'end': 424.729, 'start': 304.18, 'title': 'Nosql database comparison', 'summary': 'Highlights the differences between nosql and sql databases, including the absence of a query language and predefined schema in nosql, the ability to handle dynamic schema and lack of relationships, and the comparison of database types based on structured data fields and relationships.', 'duration': 120.549, 'highlights': ['NoSQL databases lack a predefined schema and query language, relying on infrastructure-based language for data retrieval. Lack of predefined schema and query language', 'NoSQL databases allow dynamic schema with few or no relationships, enabling the storage of required information in a single collection. Dynamic schema, few or no relationships', 'Comparison of database types based on structured data fields and relationships, where SQL is a relational database organizing structured data into defined columns and tables with relationships. Comparison of structured data fields and relationships in SQL and NoSQL databases']}, {'end': 905.344, 'start': 424.729, 'title': 'Comparison of sql and nosql databases', 'summary': 'Compares sql and nosql databases, highlighting that sql databases use a structured schema and language for complex queries, while nosql databases are non-relational with dynamic schemas and are suitable for hierarchical data storage and scalability.', 'duration': 480.615, 'highlights': ['SQL databases use a structured schema and language for complex queries, while NoSQL databases are non-relational with dynamic schemas. SQL databases require a predefined schema for structured data, while NoSQL databases have a dynamic schema for unstructured data, and are categorized into document databases, key value stores, graph stores, and wide column stores.', 'NoSQL databases are suitable for hierarchical data storage and scalability, while SQL databases are not best fit for hierarchical data storage. NoSQL databases fit better for hierarchical data storage and are horizontally scalable, while SQL databases are not best fit for hierarchical data storage as the complexity of relating tables increases with the number of tables.', 'SQL databases are vertically scalable, while NoSQL databases are horizontally scalable. SQL databases are vertically scalable, while NoSQL databases are horizontally scalable, allowing for load balancing by adding more servers to the cluster.', 'OLTP and OLAP: SQL databases are used for OLTP, while NoSQL databases are used for OLAP. SQL databases are used for online transactional processing (OLTP), emphasizing fast query processing and data integrity, while NoSQL databases are used for online analytical processing (OLAP), characterized by relatively low volume of transactions and complex queries.']}], 'duration': 601.164, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk304180.jpg', 'highlights': ['NoSQL databases lack a predefined schema and query language, relying on infrastructure-based language for data retrieval.', 'NoSQL databases allow dynamic schema with few or no relationships, enabling the storage of required information in a single collection.', 'Comparison of database types based on structured data fields and relationships, where SQL is a relational database organizing structured data into defined columns and tables with relationships.', 'NoSQL databases are suitable for hierarchical data storage and scalability, while SQL databases are not best fit for hierarchical data storage.', 'NoSQL databases fit better for hierarchical data storage and are horizontally scalable, while SQL databases are not best fit for hierarchical data storage as the complexity of relating tables increases with the number of tables.', 'SQL databases are vertically scalable, while NoSQL databases are horizontally scalable.', 'OLTP and OLAP: SQL databases are used for OLTP, while NoSQL databases are used for OLAP.']}, {'end': 1447.696, 'segs': [{'end': 1031.31, 'src': 'heatmap', 'start': 923.139, 'weight': 0, 'content': [{'end': 930.484, 'text': 'a sequel databases emphasize on the asset properties, that is, the atomicity, consistency, isolation and durability,', 'start': 923.139, 'duration': 7.345}, {'end': 936.609, 'text': 'whereas the no sequel database follows the cap theorem, that is, the consistency, availability and partition tolerance.', 'start': 930.484, 'duration': 6.125}, {'end': 941.513, 'text': "So let's talk about both of them one by one, starting with the asset properties.", 'start': 937.09, 'duration': 4.423}, {'end': 946.077, 'text': 'asset properties mainly stand for atomicity, consistency, isolation and durability.', 'start': 941.513, 'duration': 4.564}, {'end': 951.401, 'text': 'Now, atomicity basically refers to the transactions that are completely done or failed,', 'start': 946.497, 'duration': 4.904}, {'end': 954.844, 'text': 'where the transaction refers to a single logical operation of data.', 'start': 951.401, 'duration': 3.443}, {'end': 959.208, 'text': 'Now, this basically means that you know, even if one part of the transaction phase,', 'start': 955.245, 'duration': 3.963}, {'end': 963.612, 'text': 'the entire transaction phase and the database state is left unchanged.', 'start': 959.208, 'duration': 4.404}, {'end': 969.176, 'text': 'coming to consistency, the consistency ensures that data must meet all the validation rules.', 'start': 963.612, 'duration': 5.564}, {'end': 969.957, 'text': 'in simple words,', 'start': 969.176, 'duration': 0.781}, {'end': 974.421, 'text': 'You can just say that you know, your transaction never leaves the database without completing its state.', 'start': 969.977, 'duration': 4.444}, {'end': 982.087, 'text': 'Coming to isolation, the main goal for isolation is basically the concurrency control and finally the durability.', 'start': 974.981, 'duration': 7.106}, {'end': 988.812, 'text': 'the durability means that you know if a transaction has been committed, it will occur whatever may come in between, such as the power loss,', 'start': 982.087, 'duration': 6.725}, {'end': 990.453, 'text': 'crash or any sort of error.', 'start': 988.812, 'duration': 1.641}, {'end': 997.078, 'text': 'So guys that was about the asset properties that is basically the atomicity consistency isolation and durability.', 'start': 990.873, 'duration': 6.205}, {'end': 998.958, 'text': 'Coming to the cap theorem,', 'start': 997.578, 'duration': 1.38}, {'end': 1006.66, 'text': 'the cap theorem or the Eric Brewers theorem states that you know we can only achieve at most two out of three guarantees for a database.', 'start': 998.958, 'duration': 7.702}, {'end': 1010.341, 'text': 'that is basically the consistency, availability and partition tolerance.', 'start': 1006.66, 'duration': 3.681}, {'end': 1018.563, 'text': 'So here the consistency means that you know all the nodes in the network see the same data at the same time or the reader gets most recently written data.', 'start': 1010.701, 'duration': 7.862}, {'end': 1020.444, 'text': 'Coming to availability.', 'start': 1019.003, 'duration': 1.441}, {'end': 1026.588, 'text': 'availability is the guarantee that every request receives a response about whether it is successful or failed,', 'start': 1020.444, 'duration': 6.144}, {'end': 1031.31, 'text': 'and the more number of users a system can cater to a better is the availability.', 'start': 1026.588, 'duration': 4.722}], 'summary': 'Sequel databases emphasize acid properties, while nosql databases follow cap theorem for consistency, availability, and partition tolerance.', 'duration': 40.473, 'max_score': 923.139, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk923139.jpg'}, {'end': 1026.588, 'src': 'embed', 'start': 998.958, 'weight': 1, 'content': [{'end': 1006.66, 'text': 'the cap theorem or the Eric Brewers theorem states that you know we can only achieve at most two out of three guarantees for a database.', 'start': 998.958, 'duration': 7.702}, {'end': 1010.341, 'text': 'that is basically the consistency, availability and partition tolerance.', 'start': 1006.66, 'duration': 3.681}, {'end': 1018.563, 'text': 'So here the consistency means that you know all the nodes in the network see the same data at the same time or the reader gets most recently written data.', 'start': 1010.701, 'duration': 7.862}, {'end': 1020.444, 'text': 'Coming to availability.', 'start': 1019.003, 'duration': 1.441}, {'end': 1026.588, 'text': 'availability is the guarantee that every request receives a response about whether it is successful or failed,', 'start': 1020.444, 'duration': 6.144}], 'summary': 'Cap theorem: only achieve 2 out of 3 guarantees for a database: consistency, availability, and partition tolerance.', 'duration': 27.63, 'max_score': 998.958, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk998958.jpg'}, {'end': 1295.04, 'src': 'embed', 'start': 1269.744, 'weight': 3, 'content': [{'end': 1276.15, 'text': 'MySQL supports powerful mechanisms to ensure that only authorized users have access to the databases.', 'start': 1269.744, 'duration': 6.406}, {'end': 1278.452, 'text': 'next, talking about robust transactional support.', 'start': 1276.15, 'duration': 2.302}, {'end': 1285.495, 'text': 'MySQL holds the asset properties, that is basically the atomicity, consistency, isolation and durability properties,', 'start': 1279.012, 'duration': 6.483}, {'end': 1288.157, 'text': 'and allows distributed multi-version support.', 'start': 1285.495, 'duration': 2.662}, {'end': 1295.04, 'text': 'and talking about low total cost of ownership, MySQL make sure that you need reduces the licensing costs and hardware expenditures.', 'start': 1288.157, 'duration': 6.883}], 'summary': 'Mysql ensures secure access, robust transactions, acid properties, and low total cost of ownership.', 'duration': 25.296, 'max_score': 1269.744, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1269744.jpg'}, {'end': 1345.766, 'src': 'embed', 'start': 1322.466, 'weight': 7, 'content': [{'end': 1331.556, 'text': 'MongoDB is a non-relational database with stores data as documents in a binary representation called BSON, that is basically binary JSON.', 'start': 1322.466, 'duration': 9.09}, {'end': 1337.843, 'text': 'this kind of database stores related information together for fast query access to the MongoDB query language.', 'start': 1331.556, 'duration': 6.287}, {'end': 1345.766, 'text': 'The features of MongoDB are, as you can see on my screen, that is, indexing, replication, ad hoc query, schema list and sharding.', 'start': 1338.243, 'duration': 7.523}], 'summary': 'Mongodb is a non-relational database storing data as bson documents, enabling fast query access with features like indexing, replication, ad hoc query, schema list, and sharding.', 'duration': 23.3, 'max_score': 1322.466, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1322466.jpg'}, {'end': 1394.349, 'src': 'embed', 'start': 1364.954, 'weight': 4, 'content': [{'end': 1369.717, 'text': "It's very flexible because it's schema-less database and is written in C++.", 'start': 1364.954, 'duration': 4.763}, {'end': 1376.642, 'text': 'and talking about sharding, MongoDB uses sharding to enable deployments with large datasets and high throughput operations.', 'start': 1369.717, 'duration': 6.925}, {'end': 1383.326, 'text': 'So guys, these are the mainly five features of MongoDB that is indexing replication ad-hoc query schema-less and sharding.', 'start': 1377.042, 'duration': 6.284}, {'end': 1387.747, 'text': "So there's now that you know what my sequel is and what Mongo TV is.", 'start': 1383.806, 'duration': 3.941}, {'end': 1394.349, 'text': "let's compare these two databases based on the grounds that you can see on the screen that is, the query language to flexibility of schema,", 'start': 1387.747, 'duration': 6.602}], 'summary': 'Mongodb is schema-less, uses sharding for large datasets, and has 5 main features: indexing, replication, ad-hoc query, schema-less, and sharding.', 'duration': 29.395, 'max_score': 1364.954, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1364954.jpg'}], 'start': 905.344, 'title': 'Sql vs nosql databases', 'summary': 'Compares sql and nosql databases, emphasizing on their properties, stability, guarantees, and features. it highlights differences in asset properties, cap theorem, and specific features such as indexing, replication, ad-hoc query, schema-less, and sharding. additionally, it provides quantifiable data about mysql and mongodb, including their support, years in existence, and specific capabilities for large datasets and high throughput operations.', 'chapters': [{'end': 1061.193, 'start': 905.344, 'title': 'Sql vs nosql comparison', 'summary': 'Compares sql and nosql databases, highlighting the key differences in their properties such as asset properties and cap theorem, emphasizing on their stability and guarantees for a database.', 'duration': 155.849, 'highlights': ['SQL databases emphasize on asset properties (ACID), while NoSQL databases follow the CAP theorem (Consistency, Availability, Partition Tolerance). Emphasizes the fundamental divergent properties of SQL and NoSQL databases.', 'Asset properties include atomicity, consistency, isolation, and durability, ensuring that transactions are completed or failed as a whole, meet validation rules, manage concurrency, and are committed despite interruptions. Explains the key components of asset properties in SQL databases, emphasizing their impact on data integrity and transaction management.', 'The CAP theorem states that a database can achieve at most two out of three guarantees: consistency, availability, and partition tolerance. Highlights the fundamental trade-offs in distributed systems as per the CAP theorem, emphasizing the limitations in providing all three guarantees simultaneously.']}, {'end': 1447.696, 'start': 1061.193, 'title': 'Sql vs nosql comparison', 'summary': 'Compares the features and support of sql and nosql databases. sql databases like mysql offer comprehensive application development, scalability, high availability, and robust transactional support, while nosql databases like mongodb provide features such as indexing, replication, ad-hoc query, schema-less and sharding. mysql is backed by oracle, has been in existence for over 40 years, and offers 24/7 support, while mongodb is a non-relational database storing data as documents in a binary representation called bson, which supports sharding for large datasets and high throughput operations.', 'duration': 386.503, 'highlights': ['MySQL provides comprehensive application development, scalability, and high availability, and robust transactional support. MySQL offers features like comprehensive application development, scalability, and high availability, which are essential for large-scale deployments.', "MongoDB provides features such as indexing, replication, ad-hoc query, schema-less, and sharding. MongoDB's features such as indexing, replication, ad-hoc query, schema-less, and sharding make it suitable for handling large datasets and high throughput operations.", 'MySQL is backed by Oracle and has been into existence for more than 40 years, offering 24/7 support. The fact that MySQL is backed by Oracle, has a long history, and provides 24/7 support showcases its reliability and support from an established vendor.', 'MongoDB is a non-relational database storing data as documents in a binary representation called BSON. The unique storage format of MongoDB as documents in BSON distinguishes it as a non-relational database.']}], 'duration': 542.352, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk905344.jpg', 'highlights': ['SQL databases emphasize on asset properties (ACID), while NoSQL databases follow the CAP theorem (Consistency, Availability, Partition Tolerance).', 'The CAP theorem states that a database can achieve at most two out of three guarantees: consistency, availability, and partition tolerance.', 'Asset properties include atomicity, consistency, isolation, and durability, ensuring that transactions are completed or failed as a whole, meet validation rules, manage concurrency, and are committed despite interruptions.', 'MySQL provides comprehensive application development, scalability, and high availability, and robust transactional support.', 'MongoDB provides features such as indexing, replication, ad-hoc query, schema-less, and sharding.', 'MySQL is backed by Oracle and has been into existence for more than 40 years, offering 24/7 support.', 'The fact that MySQL is backed by Oracle, has a long history, and provides 24/7 support showcases its reliability and support from an established vendor.', 'MongoDB is a non-relational database storing data as documents in a binary representation called BSON.']}, {'end': 1699.149, 'segs': [{'end': 1479.813, 'src': 'embed', 'start': 1448.268, 'weight': 6, 'content': [{'end': 1449.79, 'text': 'So to make you understand better.', 'start': 1448.268, 'duration': 1.522}, {'end': 1451.692, 'text': "I've considered the example on the screen.", 'start': 1449.91, 'duration': 1.782}, {'end': 1458.478, 'text': 'So to insert the data into the employees table in the sequel query, you just have to type in insert into employees.', 'start': 1452.052, 'duration': 6.426}, {'end': 1462.482, 'text': 'That is basically your table name and insert into is your sequel syntax.', 'start': 1458.518, 'duration': 3.964}, {'end': 1469.469, 'text': 'and then you mentioned the column names, that is, the employee ID and employee age, and then you use the sequel syntax, that is, the values,', 'start': 1462.482, 'duration': 6.987}, {'end': 1471.171, 'text': 'and mention the values for the fields.', 'start': 1469.469, 'duration': 1.702}, {'end': 1473.612, 'text': 'So, to just insert data into the table.', 'start': 1471.671, 'duration': 1.941}, {'end': 1479.813, 'text': 'you mentioned insert into employees employee ID, employee age values and then you mentioned the values.', 'start': 1473.612, 'duration': 6.201}], 'summary': "To insert data into the employees table in sql, use 'insert into employees' followed by column names and values.", 'duration': 31.545, 'max_score': 1448.268, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1448268.jpg'}, {'end': 1537.044, 'src': 'embed', 'start': 1512.185, 'weight': 5, 'content': [{'end': 1517.929, 'text': 'Let me tell you that you know, before you can store anything in my sequel, you need to clearly define tables and columns,', 'start': 1512.185, 'duration': 5.744}, {'end': 1520.491, 'text': 'and every row in the table should have the same column.', 'start': 1517.929, 'duration': 2.562}, {'end': 1525.415, 'text': "Now, this is basically because there isn't much space for flexibility in the manner of storing data.", 'start': 1520.951, 'duration': 4.464}, {'end': 1532.02, 'text': 'If you follow normalization, for example, if you have an employee database, you need to create a table which can hold the date of employees.', 'start': 1525.495, 'duration': 6.525}, {'end': 1537.044, 'text': 'Now this table can have many attribute values such as the employee ID employee name and so on.', 'start': 1532.44, 'duration': 4.604}], 'summary': 'In sql, defining tables and columns is essential for data storage and normalization. for an employee database, a table with attributes like employee id and name is required.', 'duration': 24.859, 'max_score': 1512.185, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1512185.jpg'}, {'end': 1571.143, 'src': 'embed', 'start': 1544.592, 'weight': 0, 'content': [{'end': 1551.239, 'text': "so you can directly drop a couple of documents within a collection and it isn't necessary to have any relations between those documents.", 'start': 1544.592, 'duration': 6.647}, {'end': 1558.847, 'text': 'Now the only restriction with MongoDB is that you need to frequently optimize your schema based on how the application will be accessing the data.', 'start': 1551.659, 'duration': 7.188}, {'end': 1562.311, 'text': 'Now Mongo TV stores the data in the JSON type manner.', 'start': 1559.387, 'duration': 2.924}, {'end': 1565.916, 'text': 'So, if you consider the previous example, there is the employee table.', 'start': 1562.672, 'duration': 3.244}, {'end': 1571.143, 'text': 'the data in Mongo TV would be stored, as you know employee ID and then we have to mention the employee ID.', 'start': 1565.916, 'duration': 5.227}], 'summary': 'In mongodb, documents can be directly stored in a collection without needing relations. schema optimization is essential. data is stored in json format.', 'duration': 26.551, 'max_score': 1544.592, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1544592.jpg'}, {'end': 1626.091, 'src': 'embed', 'start': 1598.497, 'weight': 1, 'content': [{'end': 1602.479, 'text': 'Now when we talk about relationships MySQL supports the join operations.', 'start': 1598.497, 'duration': 3.982}, {'end': 1606.841, 'text': 'So to explain you in simple terms join makes the relational database relational.', 'start': 1602.599, 'duration': 4.242}, {'end': 1613.905, 'text': 'So basically the join allows the user to link the data from two or more tables in a single query with the help of the select command.', 'start': 1607.141, 'duration': 6.764}, {'end': 1619.368, 'text': 'So, for example, if you want to retrieve the data from the employee in the projects table based on the matching column,', 'start': 1614.265, 'duration': 5.103}, {'end': 1626.091, 'text': 'you can easily obtain the desired data by applying any type of joins just the inner, left, right or full, based on your need.', 'start': 1619.368, 'duration': 6.723}], 'summary': 'Mysql supports join operations to link data from multiple tables in a single query.', 'duration': 27.594, 'max_score': 1598.497, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1598497.jpg'}, {'end': 1687.943, 'src': 'embed', 'start': 1660.809, 'weight': 4, 'content': [{'end': 1667.974, 'text': 'it basically authenticates a user and facilitates it with the user privileges on a particular database, such as create, select, insert,', 'start': 1660.809, 'duration': 7.165}, {'end': 1668.915, 'text': 'update and so on.', 'start': 1667.974, 'duration': 0.941}, {'end': 1670.976, 'text': 'Now coming to MongoDB.', 'start': 1669.455, 'duration': 1.521}, {'end': 1675.358, 'text': 'MongoDB uses a role-based access control with a flexible set of privileges.', 'start': 1670.976, 'duration': 4.382}, {'end': 1680.3, 'text': 'its security features basically include the authentication, auditing and authorization.', 'start': 1675.358, 'duration': 4.942}, {'end': 1687.943, 'text': 'not only this, but it is also possible to use the transport layer security and the secure socket layer for encryption purposes in MongoDB.', 'start': 1680.3, 'duration': 7.643}], 'summary': 'Authentication and privileges in mongodb include role-based access control and security features such as authentication, auditing, authorization, and encryption using transport layer security and secure socket layer.', 'duration': 27.134, 'max_score': 1660.809, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1660809.jpg'}], 'start': 1448.268, 'title': 'Query language differences and schema flexibility, mongodb schema and data storage, and mysql vs mongodb: relationships and security', 'summary': "Discusses the differences in query language between mysql and mongodb, emphasizing the syntax for inserting data and schema flexibility; it also covers mongodb's schema design flexibility, need for schema optimization, and json data storage, as well as the differences in relationships and security features between mysql and mongodb, including support for join operations, privilege-based security, multi-dimensional data types, and role-based access control.", 'chapters': [{'end': 1525.415, 'start': 1448.268, 'title': 'Query language differences and schema flexibility', 'summary': 'Discusses the differences in query language between my sequel and mongodb, highlighting the syntax for inserting data and the flexibility of schema in both databases.', 'duration': 77.147, 'highlights': ['The syntax for inserting data into the employees table in sequel query involves mentioning the table name, column names, and values, illustrating the difference in query language between my sequel and MongoDB.', 'In my sequel, there is less flexibility in the manner of storing data as tables and columns need to be clearly defined with each row having the same columns, contrasting with the flexibility of schema in MongoDB.']}, {'end': 1597.997, 'start': 1525.495, 'title': 'Mongodb schema and data storage', 'summary': 'Discusses the flexibility of mongodb schema design, which allows for unrestricted schema design and no need for relationships between documents, while emphasizing the need for frequent schema optimization based on data access patterns and storing data in json format.', 'duration': 72.502, 'highlights': ['MongoDB allows for unrestricted schema design and no need for relationships between documents, providing flexibility in data storage.', 'Frequent schema optimization is necessary in MongoDB based on data access patterns to ensure efficient performance.', 'Data in MongoDB is stored in JSON format, allowing for flexible document storage within collections.']}, {'end': 1699.149, 'start': 1598.497, 'title': 'Mysql vs mongodb: relationships and security', 'summary': "Discusses the differences between mysql and mongodb in terms of relationships and security, highlighting mysql's support for join operations and privilege-based security model, and mongodb's support for multi-dimensional data types and role-based access control with flexible privileges and security features including authentication, auditing, and authorization.", 'duration': 100.652, 'highlights': ['MySQL supports join operations, enabling users to link data from multiple tables in a single query, while MongoDB supports multi-dimensional data types and the embedding of documents.', 'MySQL uses a privilege-based security model, facilitating user privileges on a particular database, while MongoDB uses role-based access control with authentication, auditing, authorization, and encryption capabilities.', "MySQL authentication includes user privileges such as create, select, insert, update, while MongoDB's security features include transport layer security and secure socket layer for encryption, ensuring access is restricted to intended clients."]}], 'duration': 250.881, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1448268.jpg', 'highlights': ['MongoDB allows for unrestricted schema design and no need for relationships between documents, providing flexibility in data storage.', 'MySQL supports join operations, enabling users to link data from multiple tables in a single query, while MongoDB supports multi-dimensional data types and the embedding of documents.', 'Frequent schema optimization is necessary in MongoDB based on data access patterns to ensure efficient performance.', 'Data in MongoDB is stored in JSON format, allowing for flexible document storage within collections.', 'MySQL uses a privilege-based security model, facilitating user privileges on a particular database, while MongoDB uses role-based access control with authentication, auditing, authorization, and encryption capabilities.', 'In my sequel, there is less flexibility in the manner of storing data as tables and columns need to be clearly defined with each row having the same columns, contrasting with the flexibility of schema in MongoDB.', 'The syntax for inserting data into the employees table in sequel query involves mentioning the table name, column names, and values, illustrating the difference in query language between my sequel and MongoDB.', "MySQL authentication includes user privileges such as create, select, insert, update, while MongoDB's security features include transport layer security and secure socket layer for encryption, ensuring access is restricted to intended clients."]}, {'end': 1950.103, 'segs': [{'end': 1764.632, 'src': 'embed', 'start': 1737.395, 'weight': 3, 'content': [{'end': 1740.376, 'text': 'you know which database is faster, because you know only your demands,', 'start': 1737.395, 'duration': 2.981}, {'end': 1746.04, 'text': 'your data and your infrastructure can tell what you need and which database can provide you the output faster.', 'start': 1740.376, 'duration': 5.664}, {'end': 1748.642, 'text': 'So guys that was about performance next.', 'start': 1746.42, 'duration': 2.222}, {'end': 1751.143, 'text': "We'll be comparing these databases based on support.", 'start': 1748.682, 'duration': 2.461}, {'end': 1758.988, 'text': 'Well, both of them offer excellent support 24 7 for security fixes maintenance releases bug fixes patches and updates.', 'start': 1751.583, 'duration': 7.405}, {'end': 1764.632, 'text': 'So there is as such no difference between both of them based on this parameter as both of them offer good support.', 'start': 1759.368, 'duration': 5.264}], 'summary': 'Comparison of databases based on performance and support is inconclusive as both offer excellent support 24/7.', 'duration': 27.237, 'max_score': 1737.395, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1737395.jpg'}, {'end': 1803.917, 'src': 'embed', 'start': 1779.98, 'weight': 0, 'content': [{'end': 1788.144, 'text': 'provides text searching and indexing, also allows query caching, provides integrated replication support and also provides different storage engines.', 'start': 1779.98, 'duration': 8.164}, {'end': 1792.888, 'text': 'So guys, these were the key features of my sequel, not talking about MongoDB.', 'start': 1788.704, 'duration': 4.184}, {'end': 1800.575, 'text': 'MongoDB supports auto sharding, comprehensive secondary indexes in memory speed, native application and embedded data model support.', 'start': 1792.888, 'duration': 7.687}, {'end': 1803.917, 'text': 'So these were few features of my sequel and MongoDB.', 'start': 1801.035, 'duration': 2.882}], 'summary': 'Mysql features: text searching, indexing, query caching, replication support. mongodb features: auto sharding, secondary indexes, in-memory speed.', 'duration': 23.937, 'max_score': 1779.98, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1779980.jpg'}, {'end': 1882.033, 'src': 'embed', 'start': 1854.177, 'weight': 1, 'content': [{'end': 1859.54, 'text': 'So each member of the replica set can have the role of primary or secondary at any point in the process,', 'start': 1854.177, 'duration': 5.363}, {'end': 1865.462, 'text': 'and the read and writes are done on the primary replica by default and then replicated to the secondary replicas.', 'start': 1859.54, 'duration': 5.922}, {'end': 1867.924, 'text': 'So, guys, this was about the replication.', 'start': 1865.883, 'duration': 2.041}, {'end': 1874.387, 'text': 'MySQL supports the master slave replication and the MongoDB supports built-in replication, sharding and Auto elections.', 'start': 1867.924, 'duration': 6.463}, {'end': 1878.81, 'text': "Next we'll be comparing these tools based on usage now for this factor.", 'start': 1874.967, 'duration': 3.843}, {'end': 1882.033, 'text': "I'm going to tell you where you can use my sequel and MongoDB.", 'start': 1878.89, 'duration': 3.143}], 'summary': 'Mongodb supports built-in replication, sharding, and auto elections. mysql supports master-slave replication. both are used in different scenarios.', 'duration': 27.856, 'max_score': 1854.177, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1854177.jpg'}, {'end': 1960.55, 'src': 'embed', 'start': 1931.015, 'weight': 2, 'content': [{'end': 1937.857, 'text': 'So they offer a developer zone on the mysql website and the community for mysql is I would say much better than that of MongoDB.', 'start': 1931.015, 'duration': 6.842}, {'end': 1940.858, 'text': 'So, if you want to support both of them, offer good support.', 'start': 1938.177, 'duration': 2.681}, {'end': 1946.1, 'text': 'but yes, if you talk about active community, then mysql has a better active community than compared to MongoDB.', 'start': 1940.858, 'duration': 5.242}, {'end': 1950.103, 'text': "So guys now that I've told you so much about my sequel in MongoDB.", 'start': 1946.62, 'duration': 3.483}, {'end': 1960.55, 'text': 'Let me just shift to my my sequel workbench and MongoDB compass so that I show you how you can create tables and databases in my sequel and how you can create databases and collections in MongoDB.', 'start': 1950.423, 'duration': 10.127}], 'summary': 'Mysql has a better active community than mongodb, offering developer support and tools for creating tables and databases.', 'duration': 29.535, 'max_score': 1931.015, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1931015.jpg'}], 'start': 1699.609, 'title': 'Mysql vs mongodb: performance & support', 'summary': "Compares mysql and mongodb's performance, highlighting that mongodb is much faster in handling large unstructured data. mysql offers better support and a more active community, while mongodb excels in key features, replication, and usage for unstructured data and high write loads.", 'chapters': [{'end': 1758.988, 'start': 1699.609, 'title': 'Mysql vs mongodb: performance & support', 'summary': 'Compares the performance of mysql and mongodb, highlighting that mongodb is much faster than mysql in dealing with large unstructured data due to its ability to handle such data and allow users to query in a manner more sensitive to workload. both databases offer excellent 24/7 support for security fixes, maintenance releases, bug fixes, patches, and updates.', 'duration': 59.379, 'highlights': ["MongoDB is much faster than MySQL in dealing with large unstructured data MongoDB's ability to handle large unstructured data makes it much faster than MySQL, allowing users to query in a manner more sensitive to workload.", 'Both databases offer excellent 24/7 support for security fixes, maintenance releases, bug fixes, patches, and updates Both MySQL and MongoDB provide round-the-clock support for various essential updates and fixes, ensuring reliable maintenance and security.']}, {'end': 1950.103, 'start': 1759.368, 'title': 'Comparison: mysql vs mongodb', 'summary': 'Compares mysql and mongodb based on support, key features, replication, usage, and active community. mysql offers better support and a more active community, while mongodb excels in key features, replication, and usage for unstructured data and high write loads.', 'duration': 190.735, 'highlights': ['MySQL offers better support and a more active community than MongoDB. MySQL provides good support and has a better active community compared to MongoDB.', 'MongoDB excels in key features such as auto sharding, comprehensive secondary indexes, and native application and embedded data model support. MongoDB offers key features like auto sharding, comprehensive secondary indexes, and native application and embedded data model support.', "MongoDB's built-in replication, sharding, and auto elections allow for horizontal scaling and automatic failover, while MySQL supports master slave replication and multi-source replication. MongoDB's built-in replication, sharding, and auto elections enable horizontal scaling and automatic failover, while MySQL supports master slave replication and multi-source replication.", 'MySQL is best suited for data with tables and rows, small data sets, frequent updates, strong dependency on multi-door transactions, and modifying large volumes of records, whereas MongoDB is best for unstructured data, large datasets, high write loads, high availability, and location-based data. MySQL is suitable for data with tables and rows, small data sets, frequent updates, multi-door transactions, and modifying large volumes of records. MongoDB is best for unstructured data, large datasets, high write loads, high availability, and location-based data.']}], 'duration': 250.494, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1699609.jpg', 'highlights': ['MongoDB excels in key features like auto sharding, comprehensive secondary indexes, and native application and embedded data model support.', "MongoDB's built-in replication, sharding, and auto elections enable horizontal scaling and automatic failover, while MySQL supports master slave replication and multi-source replication.", 'MySQL offers better support and a more active community compared to MongoDB.', 'Both databases offer excellent 24/7 support for security fixes, maintenance releases, bug fixes, patches, and updates.']}, {'end': 2327.229, 'segs': [{'end': 1997.504, 'src': 'embed', 'start': 1972.449, 'weight': 1, 'content': [{'end': 1977.651, 'text': 'So guys, this is how your MySQL workbench looks now to show you how you can use my sequel.', 'start': 1972.449, 'duration': 5.202}, {'end': 1979.152, 'text': "I've already written the commands.", 'start': 1977.771, 'duration': 1.381}, {'end': 1981.052, 'text': "So I'm just going to tell you how you can use them.", 'start': 1979.172, 'duration': 1.88}, {'end': 1982.533, 'text': 'So to create a database.', 'start': 1981.393, 'duration': 1.14}, {'end': 1987.195, 'text': "I've used to query create database and I've mentioned the database name that is employee info.", 'start': 1982.653, 'duration': 4.542}, {'end': 1994.882, 'text': 'So this is a sequel language guys where you know create and database are the sequel syntax and employee info is the data parameter.', 'start': 1987.978, 'duration': 6.904}, {'end': 1997.504, 'text': "So I'm going to just execute this particular query now.", 'start': 1994.902, 'duration': 2.602}], 'summary': "Using mysql workbench to create a database named employee info using the 'create database' query.", 'duration': 25.055, 'max_score': 1972.449, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1972449.jpg'}, {'end': 2082.36, 'src': 'embed', 'start': 2054.226, 'weight': 3, 'content': [{'end': 2060.63, 'text': 'So we have written a query as insert into employee employee ID, first name, last name, age, email ID, phone number,', 'start': 2054.226, 'duration': 6.404}, {'end': 2063.452, 'text': "address values and then I've mentioned the values right?", 'start': 2060.63, 'duration': 2.822}, {'end': 2065.513, 'text': "So I'm going to just execute this particular query.", 'start': 2063.692, 'duration': 1.821}, {'end': 2070.335, 'text': 'So once the query has been executed you can clearly see that you know data has been inserted into the table.', 'start': 2065.833, 'duration': 4.502}, {'end': 2076.819, 'text': "So I'll just go to the employee info table go to the tables option go to employee and then I'm going to just look into the table.", 'start': 2070.616, 'duration': 6.203}, {'end': 2082.36, 'text': 'So when I just check into the option of view you can clearly see that, you know, our first record has been inserted.', 'start': 2077.339, 'duration': 5.021}], 'summary': 'Executed query successfully, inserting first record into employee info table.', 'duration': 28.134, 'max_score': 2054.226, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk2054226.jpg'}, {'end': 2139.232, 'src': 'embed', 'start': 2108.675, 'weight': 2, 'content': [{'end': 2112.058, 'text': 'and once you go to my cluster, you get an option of create database right?', 'start': 2108.675, 'duration': 3.383}, {'end': 2113.579, 'text': "So I'm just going to create a database.", 'start': 2112.078, 'duration': 1.501}, {'end': 2122.407, 'text': "So let's say I mention it to be employee info and then over here since I've told you database has collections and then collections have documents.", 'start': 2113.799, 'duration': 8.608}, {'end': 2126.97, 'text': 'So basically a group of documents is collections and a group of collections is a database.', 'start': 2122.647, 'duration': 4.323}, {'end': 2129.072, 'text': "I'm going to mention my first collection name.", 'start': 2127.371, 'duration': 1.701}, {'end': 2130.193, 'text': "Let's say, you know employee.", 'start': 2129.132, 'duration': 1.061}, {'end': 2133.229, 'text': "and then I'm going to just click on create database.", 'start': 2131.028, 'duration': 2.201}, {'end': 2139.232, 'text': 'So once I click on create database, you can clearly see that you know, my database has been created that is employee info.', 'start': 2133.669, 'duration': 5.563}], 'summary': 'Creating a database named employee info with a collection named employee.', 'duration': 30.557, 'max_score': 2108.675, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk2108675.jpg'}, {'end': 2283.176, 'src': 'embed', 'start': 2232.147, 'weight': 0, 'content': [{'end': 2239.869, 'text': 'So guys it was just a short demo on you know, how you can use my sequel workbench and MongoDB compass to handle structured data and unstructured data.', 'start': 2232.147, 'duration': 7.722}, {'end': 2247.572, 'text': 'So, folks, with this we come to an end of this face-off between my sequel and MongoDB, and I hope you understood all the points now.', 'start': 2240.329, 'duration': 7.243}, {'end': 2254.834, 'text': 'knowing so much about my sequel and MongoDB would have definitely raised a question on your mind whether to use MongoDB or my sequel for your businesses.', 'start': 2247.572, 'duration': 7.262}, {'end': 2258.156, 'text': 'So, guys, well, there is no clear winner between both of them.', 'start': 2255.374, 'duration': 2.782}, {'end': 2263.26, 'text': 'the choice of database completely depends upon the schema of your database and how you wish to access it.', 'start': 2258.156, 'duration': 5.104}, {'end': 2271.366, 'text': 'Nevertheless, you can use my sequel when you have a fixed schema high transaction, low maintenance data security with a limited budget and MongoDB.', 'start': 2263.681, 'duration': 7.685}, {'end': 2275.169, 'text': 'while you have an unstable schema, no specific database administrator.', 'start': 2271.366, 'duration': 3.803}, {'end': 2278.452, 'text': 'high availability cloud computing involved with inbuilt sharding.', 'start': 2275.169, 'duration': 3.283}, {'end': 2281.354, 'text': 'So guys this is when you use my sequel and MongoDB.', 'start': 2278.912, 'duration': 2.442}, {'end': 2283.176, 'text': "There's no clear between both of them.", 'start': 2281.654, 'duration': 1.522}], 'summary': 'Comparison between mysql and mongodb for structured and unstructured data. no clear winner, choice depends on database schema and access needs.', 'duration': 51.029, 'max_score': 2232.147, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk2232147.jpg'}], 'start': 1950.423, 'title': 'Database management and comparison in mysql and mongodb', 'summary': "Covers creating databases and executing queries in mysql and mongodb, and compares their suitability based on database schema, access needs, and business requirements, highlighting mysql's suitability for fixed schema, high transaction, low maintenance data security with a limited budget, and mongodb's suitability for unstable schema, high availability cloud computing with inbuilt sharding.", 'chapters': [{'end': 2162.444, 'start': 1950.423, 'title': 'Database management in mysql and mongodb', 'summary': 'Demonstrates the process of creating databases and tables in mysql and mongodb, including executing queries and visualizing the data using mysql workbench and mongodb compass.', 'duration': 212.021, 'highlights': ['The chapter demonstrates the process of creating databases and tables in MySQL and MongoDB. The chapter covers the creation of databases and tables in both MySQL and MongoDB, providing a comprehensive understanding of database management.', 'Executing queries and visualizing the data using MySQL Workbench and MongoDB Compass. The chapter explains the execution of queries in MySQL to create databases, tables, and insert data, along with visualizing the created databases and collections using MySQL Workbench. Additionally, it showcases the process of creating databases and collections using MongoDB Compass.', "Executing queries to create a database and table in MySQL. The demonstration includes executing queries to create a database and table in MySQL, with the specific example of creating an 'employee info' database and an 'employee' table.", "Creating a database and collection in MongoDB. The process of creating a database 'employee info' and a collection 'employee' in MongoDB is illustrated, providing a clear understanding of the database and collections creation process in MongoDB.", 'Inserting data into the table and visualizing the results. The chapter includes the insertion of data into the table within the MySQL database and visualizing the inserted record, offering practical insight into data management and visualization.']}, {'end': 2327.229, 'start': 2162.484, 'title': 'Comparing mysql and mongodb', 'summary': 'Explains how to use mysql workbench and mongodb compass to handle structured and unstructured data, and concludes that the choice between mysql and mongodb depends on the database schema, access needs, and business requirements, with mysql suitable for fixed schema, high transaction, low maintenance data security with a limited budget, and mongodb suitable for unstable schema, no specific database administrator, high availability cloud computing involved with inbuilt sharding.', 'duration': 164.745, 'highlights': ['The chapter explains how to use MySQL Workbench and MongoDB Compass to handle structured and unstructured data The transcript describes the process of using MySQL Workbench and MongoDB Compass to create a database, collection, and documents, providing a practical demonstration of working with structured and unstructured data.', 'The choice between MySQL and MongoDB depends on the database schema, access needs, and business requirements It is mentioned that the suitability of MySQL or MongoDB depends on factors such as database schema, access needs, and business requirements, impacting the decision-making process for selecting the appropriate database.', 'MySQL is suitable for fixed schema, high transaction, low maintenance data security with a limited budget The transcript highlights that MySQL is recommended for use cases involving a fixed schema, high transaction volumes, low maintenance data security, and limited budget, offering a specific use case for choosing MySQL over MongoDB.', 'MongoDB is suitable for unstable schema, no specific database administrator, high availability cloud computing involved with inbuilt sharding The suitability of MongoDB is emphasized for scenarios with an unstable schema, absence of a specific database administrator, involvement of high availability cloud computing, and the need for inbuilt sharding, providing a specific use case for choosing MongoDB over MySQL.']}], 'duration': 376.806, 'thumbnail': 'https://coursnap.oss-ap-southeast-1.aliyuncs.com/video-capture/QwevGzVu_zk/pics/QwevGzVu_zk1950423.jpg', 'highlights': ['The chapter covers the creation of databases and tables in both MySQL and MongoDB, providing a comprehensive understanding of database management.', 'The chapter explains the execution of queries in MySQL to create databases, tables, and insert data, along with visualizing the created databases and collections using MySQL Workbench.', "The process of creating a database 'employee info' and a collection 'employee' in MongoDB is illustrated, providing a clear understanding of the database and collections creation process in MongoDB.", 'The chapter includes the insertion of data into the table within the MySQL database and visualizing the inserted record, offering practical insight into data management and visualization.', 'The transcript describes the process of using MySQL Workbench and MongoDB Compass to create a database, collection, and documents, providing a practical demonstration of working with structured and unstructured data.', 'The suitability of MySQL or MongoDB depends on factors such as database schema, access needs, and business requirements, impacting the decision-making process for selecting the appropriate database.', 'MySQL is recommended for use cases involving a fixed schema, high transaction volumes, low maintenance data security, and limited budget, offering a specific use case for choosing MySQL over MongoDB.', 'The suitability of MongoDB is emphasized for scenarios with an unstable schema, absence of a specific database administrator, involvement of high availability cloud computing, and the need for inbuilt sharding, providing a specific use case for choosing MongoDB over MySQL.']}], 'highlights': ['MySQL is backed by Oracle and has been into existence for more than 40 years, offering 24/7 support.', 'MongoDB provides features such as indexing, replication, ad-hoc query, schema-less, and sharding.', 'MySQL supports join operations, enabling users to link data from multiple tables in a single query, while MongoDB supports multi-dimensional data types and the embedding of documents.', 'MySQL offers better support and a more active community compared to MongoDB.', 'The chapter covers the creation of databases and tables in both MySQL and MongoDB, providing a comprehensive understanding of database management.', "The process of creating a database 'employee info' and a collection 'employee' in MongoDB is illustrated, providing a clear understanding of the database and collections creation process in MongoDB.", 'The chapter includes the insertion of data into the table within the MySQL database and visualizing the inserted record, offering practical insight into data management and visualization.', 'The suitability of MySQL or MongoDB depends on factors such as database schema, access needs, and business requirements, impacting the decision-making process for selecting the appropriate database.']}