SQL vs. NoSQL Databases

SQL vs. NoSQL Databases, Introduction to NoSQL, Difference Between SQL and NoSQL Databases, and Examples for SQL and NoSQL Databases.

1. Introduction to NoSQL

. NoSQL is an approach to database design that can accomodate a wide variety of data models, including key-value, document, columnar and graph formats.

. NoSQL, which stand for "not only SQL," is an alternative to traditional relational databases in which data is placed in tables and data schema is carefully designed before the database is built.

. NoSQL databases are especially useful for working with large sets of distributed data.

2. Difference Between SQL and NoSQL Databases…

. In the world of database technology, there are two main types of databases: SQL and NoSQL—or, relational databases and non-relational databases.

. The difference speaks to how they’re built, the type of information they store, and how they store it. Relational databases are structured, like phone books that store phone numbers and addresses.

. Non-relational databases are document-oriented and distributed, like file folders that hold everything from a person’s address and phone number to their Facebook likes and online shopping preferences.

3. Examples for SQL and NoSQL Databases...

. Popular SQL databases and RDBMS’s

i. MySQL—the most popular open-source database, excellent for CMS sites and blogs.

ii. Oracle—an object-relational DBMS written in the C++ language. If you have the budget, this is a full-service option with great customer service and reliability. Oracle has also released an Oracle NoSQL database.

iii. IMB DB2—a family of database server products from IBM that are built to handle advanced “big data” analytics.

iv. Sybase—a relational model database server product for businesses primarily used on the Unix OS, which was the first enterprise-level DBMS for Linux.

v. MS SQL Server—a Microsoft-developed RDBMS for enterprise-level databases that supports both SQL and NoSQL architectures.

vi. MariaDB—an enhanced, drop-in version of MySQL.

vii. PostgreSQL—an enterprise-level, object-relational DBMS that uses procedural languages like Perl and Python, in addition to SQL-level code.
-------------------------
. Popular NoSQL Databases

i. MongoDB—the most popular NoSQL system, especially among startups. A document-oriented database with JSON-like documents in dynamic schemas instead of relational tables that’s used on the back end of sites like eBay, Foursquare.

. It’s open-source, so it’s free, with good customer service.

ii. Apache’s CouchDB—a true DB for the web, it uses the JSON data exchange format to store its documents; JavaScript for indexing, combining and transforming documents; and, HTTP for its API.

iii. HBase—another Apache project, developed as a part of Hadoop, this open-source, non-relational “column store” NoSQL DB is written in Java, and provides BigTable-like capabilities.

iv. Oracle NoSQL—Oracle’s entry into the NoSQL category.

v. Apache’s Cassandra DB—born at Facebook, Cassandra is a distributed database that’s great at handling massive amounts of structured data. Anticipate a growing application? Cassandra is excellent at scaling up. Examples: Instagram, Comcast, Apple, and Spotify.

[vinodreddy]

Very nice Mr GC Reddy. Thanks for sharing this vidoes. from vinod reddy.

[RajVeer_RV]

Thankyou so much for uploading Sir. These videos are really helpful

[RR_Vlogs]

Hi Sir,
Im willing to learn testing tools.i have new to this field i dont have any knowledge in programming as well as testing
kindly suggest me how to start testing tools for my bright future

[kirangiri]

Sir u should have given the link of
Which you have written in
Discribtion box...
We cant copy it...😪😪