1 / 26

SQL vs NoSQL | Difference Between SQL And NoSQL | SQL And NoSQL Tutorial | SQL T

In this presentation, you will learn the major differences between SQL vs NoSQL. You will understand the basics of SQL and NoSQL, the popular SQL and No SQL databases, and the companies using them. <br>

Simplilearn
Download Presentation

SQL vs NoSQL | Difference Between SQL And NoSQL | SQL And NoSQL Tutorial | SQL T

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What’s in It for You? • What is SQL? • What is Relational Database? • What is NoSQL? • What is Non-Relational Database? • Comparison between SQL and NoSQL • When to use SQL and NoSQL • Companies using SQL and NoSQL

  2. What is SQL?

  3. Click here to watch the video

  4. What is SQL? SQL is a standard programming language used for operating Relational Databases Database Management System is an application software which is used to perform various operations on data Relational Database Structured Query Language All the processes are protected and secured, even data consistency is maintained during multiple users

  5. Popular Relational Database System

  6. What is NoSQL?

  7. What is NoSQL? NoSQL is a non–relational database, which does not process data in tabular form used in relational database Ṇon-Relational Database A Non-Relational database system encompasses a wide range of database technologies that can store structured, semi-structured, unstructured and polymorphic data Not Only SQL or Not SQL

  8. Popular Non Relational Database System

  9. Comparison between SQL and NoSQL

  10. NoSQL databases are called as Non-Relational or Distributed Databases SQL databases are called RDBMS or Relational Databases Definition

  11. Structured Query Language is the standard language NoSQL possess no declarative query language Query Language

  12. NoSQL databases can be document based, key-value pairs, graph databases SQL databases are table-based databases Type

  13. NoSQL databases are horizontally scalable SQL databases are vertically scalable Scalability

  14. NoSQL Databases comes into play where queries are not complex SQL databases comes into play for complex query intensive environment Usage

  15. There are open source SQL databases PostgreSQL, MySQL and there are commercial ones like Oracle Database Since the inception, NoSQL databases are open source Open-Source

  16. ACID MODEL • Atomicity • Consistency • Isolation • Durability • BASE Model • Basically Available • Soft State • Eventually Consistent Principle

  17. When to use SQL?

  18. When to use SQL? SQL is used to carry operations on RDBMS • SQL comes into practice when analysing behavioural related and customized sessions • SQL is used when creating custom dashboards SQL is preferred while executing complex queries

  19. When to use NoSQL?

  20. When to use NoSQL? • NoSQL Databases are preferred when ACID support is not required • Used when Traditional RDBMS is not enough • NoSQL is used when the data needs a flexible schema • Used when constraints and validation logic are not required to be implemented in the databases

  21. Companies using SQL

  22. Companies using SQL

  23. Companies using NoSQL

  24. Companies using NoSQL

More Related