Categories Database, MySQL, NoSQL, SQLPosted on

What is SQL?

Hi, a database is a collection of data stored in a format that can easily be accessed. 

In order to manage the databases we use a DataBase Management System (DBMS), we connect to the DBMS and give it instructions for querying or modify data, the DBMS execute our instructions and send results back. 

There is a lot of database management systems out there, and they are classified in 2 categories:

Relational (SQL)

We stored data in tables that are linked to each other using relationships. 

Each table stores data about a specific type of object.

SQL is the language that we use to work with these Relational DataBase Management Systems (RDBMS). 

We use SQL to query or modify our data. 

Populars RDBMS are: 

Each RDBMS has a different flavor of SQL, but all of this implementations (RDBMS) are very similar and are based on the standard SQL specification. 

So we need to learn the SQL code bases in that way we can understand difference RDBMS. 

NoSQL (non relational)

In this case we don’t have tables or relationships, these databases are different from relational databases. NoSQL systems don’t understand SQL, they have their own query language. 

SQL or SEQUEL, which is the pronunciation? 

SQL was originally developed at IBM in the 70s and back then it was initially called SEQUEL short term for Structured English Query Language, but they change the acronym to SQL, because SEQUEL was trademark of the UK-based Hawker Siddeley aircraft company.

So the pronunciation is SQL.

Credits Mosh 

By Cristina Rojas.