DEV Community

Cover image for SQL Concepts
Rutik Bhoyar
Rutik Bhoyar

Posted on

SQL Concepts

SQL(Structured Query Language)

A language used for relational database to query or get data out of the database. But what is data? and what is database?.

We know that data is collection of facts in the form of words, numbers,or even pictures. But this data needs to be secured or stored as data is most critical assets for any business. The answer is a database.

Database is a repository of data. In a relational database we can form relationship between two tables, so it is a repository of data.

Now let's dive little deep and understand the other concepts also.
Hence now question "what is dbms?" coming in mind because every time you hear about sql, the term dbms is associated with it.

So set of software tools for the data in the database is called a Database Management System or for short DBMS.

Next thing is RDBMS that is Relational Database Management System which is a set of software tools that controls the data such as access, organization, and storage.

Next post will be on Relational Database Concepts.

Top comments (0)