SQL
Part 1: Basic terminologies
Hello everyone, when I was fresher I faced many issues while learning many topics. I surfed through many PDFs, tutorials, websites and YouTube videos to learn. Yes, eventually I learnt those and reached at a level where I can explain others so they can learn easily and clear their concepts. My main aim is to write short blogs on various topics and technologies such that readers can find it easy to learn and able to understand quickly.
In this blog, I am going to explain you some basic terminologies related SQL and Database. I hope you find it helpful.
What is SQL?
SQL is a programming language used and designed for managing data which lies in a relational database management system. When there is structured data, SQL becomes very useful. SQL stands for Structured Query Language and it is a domain specific language, i.e. it is specially designed for retrieval and management of data inside of a relational database.
By using SQL, we can store, manipulate and retrieve data in a relational database.
Note: until now, you have already read “relational database” a few times. So, before diving into actual SQL concepts, I’ll briefly explain RDBMS(Relational Database Management System).
As you can see RDBMS made of two words,
- Relational
- Database Management System
Database
RDBMS means, a database which is relational. A database, which has relations with other database. When we think of a database then the first thing that comes to the mind is a set of related and organized data. There might be one or multiple tables in a database. For an example, think of a furniture shop. In this database, there might be multiple tables such as employee table, sell-purchase table, product table and so on.
As you can see, there are multiple tables where each table contains well organized data. All this structure is known as a database. In a normal case these all tables might be in spreadsheet format but as you know how rapidly data grows, at the current growth rate we would be require a software which can manage all this data.
To access this organized data we use a database management studio consisting of an integrated set of computer software which allows us to interact with one or more databases. Also, DBMS gives us the ability to enter, store and retrieve large quantities of data by providing various functions.
I hope till here you are clear on the database and DBMS. But still if you are not clear then you can ask questions in the comment section.
In next blog, I will go through RDBMS and explain it to you.
Thanks for reading.
