One Pager Cheat Sheet

• In this tutorial, we'll understand the difference between SQL, which stands for Structured Query Language, and NoSQL by comparing their associated parameters and features, such as their support on Relational Database Management Systems (RDMS).
• Setting up tables and columns with appropriate data types and establishing relationships using primary keys and foreign keys is key to using SQL databases effectively.
• Different types of SQL databases such as MySQL, PostgresSQL, Oracle, and Microsoft SQL Server are available for use.
• NoSQL is a collection of diverse technologies that refer to databases that typically don't use SQL, store data in tables, care about relationships, provide ACID transactions or require formal data schemas.
• You do not have to use SQL queries in a NoSQL database, but they are optional.
• NoSQL technology includes various forms of data stores such as Document stores, Key-value databases, Graph databases, and Column-oriented databases which have no predefined schema and are optimized for different needs such as scalability, fault-tolerance, and analytics.
• Non-relational databases are schema-less and allow for data of any type to be stored, including nesting, with no predefined structure.
• SQL databases typically deal with structured data while NoSQL databases store unstructured, semi-structured and polymorphic data, making them useful for distributed, large-scale scenarios in addition to their respective advantages and disadvantages.
• Adding a record of data is generally easier in SQL due to its schema and structured data whereas NoSQL offers more flexibility but can be more difficult to work with.
• NoSQL databases rely on a non-structured storage system, while SQL databases use schemas to define the structure of data, making it easier to add records.