What is SQL with its types (What is SQL in Hindi)

Through today’s article we will give you Full knowledge of what is SQL Will give In this article you What is SQL, Full form of SQL, Types of SQL, Features of SQL, SQL Commands, Uses of SQL and Advantages and Disadvantages of SQL will get to know about.

You spend a lot on the internet everyday Website You must have seen and used many applications, in many of these applications you must have created your account. All these details are stored in the database of the application or website, these databases are operated by SQL itself.

By the way computer There are many types of languages ​​to manage databases but the most popular language among all is SQL.

If you don’t know about database then just tell for your information that when large quantity data If it is stored and kept in a server, then it is called database.

What is SQL with its types (What is SQL in Hindi)

Without taking much of your time, come back to our topic and start this article. What Is SQL In Hindi,

What is SQL

SQL whose Full Form (full name) is Structured Query Language, it is a type of computer language by which data is managed in the Relation Database Management System (RDBMS). Database can be accessed and manipulated with the help of SQL.

SQL is a standard language, in which commands like Insert, Delete, Update etc. are given to manage the data in the database.

In RDMS data is stored in the form of multiple rows and columns, SQL is used to store the data in a well structured manner.

Full name of SQL (SQL Full Form in Hindi)

The full form (full name) of SQL is “Structured Query Language”.

History of SQL

SQL originated in the 1970s and was created by IBM employees Donald D Chamberlin and Raymond F Boyce to manage the data stored in IBM’s relational database System R.

Initially this language was named SEQUEL, but the trademark of an aircraft company named Hawker Siddeley based in UK was SEQUEL, for this reason the name of this language was later changed to SQL.

In 1978, IBM also started making commercial products related to SQL. RDMS was launched by Relation Software Inc around 1986, later the name of this company was changed to Oracle.

In today’s time, any company that makes database software uses its own SQL language, such as –

  • Microsoft Key SQL Language is – Microsoft SQL Server
  • Oracle’s SQL Language – Oracle RDBMS
  • Open Source Platform’s SQL Language is – MySQL

Features of SQL

The main features of SQL are as follows –

  • The database can be retrieved with the help of SQL.
  • SQL is used to insert and control data in RDBMS.
  • Insert, Delete, Manipulate data is done with the help of SQL.
  • With the help of SQL, a new table can be created in the database.
  • SQL Data Query Language is simpler and easier than other Query Language.
SQL kya hota hai in Hindi

Some Major Commands of SQL

Some of the major commands of SQL are as follows –

  • CREATE – To create a new object in the database.
  • ALTER – To modify the object in the database.
  • DROP – To delete an object.
  • SELECT – This command is used to view data from one or more tables.
  • INSERT – This command is used to create a new record.
  • UPDATE – The record is modified.
  • DELETE – Deletes the data from the database.
  • GRANT – This command is used to give permission to the user.
  • REVOKE – Use this command to revoke the permission.

Types of SQL Statements

in SQL command Some special types of keywords are used to give, which are called SQL Statements. There are mainly five types of SQL Statements.

1 – Data Definition Language (DDL)

Using the DDL command, you can create or delete a table in the data, a row or column can be created, deleted or changed in the table.

Examples of DDL commands are – CREATE, ALTER, DROP TABLE etc.

2 – Data Manipulation Language (DML)

Only data can be modified using DML commands. Data can be added, deleted and modified with the help of DML commands.

Examples of DML commands are INSERT, UPDATE, DELETE.

3 – Data Control Language (DCL)

The DCL command is used to control the data.

Examples of DCL commands are – GRANT, REVOKE

4 – DQL (Data Query Language)

With the help of DQL command, any data is selected in the data.

There is only one DQL command which is SELECT.

5 – TCL (Transaction Control Language)

The TCL command is used with DML. With the help of this command, the changes coming in the data are managed.

Some major TCL commands are – SAVE POINT, COMMIT

Uses of SQL

SQL language is used for the following tasks –

  • A new database can be created with the help of SQL.
  • Can insert new data into a database.
  • Data can be manipulated.
  • Data can be retrieved from the database.
  • You can create a new table in the database.
  • Records in the database can be deleted.

Similarly, all the work of Database Management System can be done with the help of SQL.

Advantages of SQL

SQL has many advantages that make it popular. SQL is a reliable and efficient language for database communication, some of the advantages of SQL are as follows –

  • Large amounts of data can be retrieved quickly and efficiently in SQL. Operations like Insert, Delete or Manipulate data can be done in no time.
  • The user does not have to write a large number of codes to retrieve the data, with the help of basic commands like SELECT, DELETE, INSERT etc., the user can easily manage the data.
  • SQL supports many types of Database Management System such as – MySQL, Oracle, MS Access etc.
  • SQL is an easy language to learn and understand.

Disadvantage of SQL

While SQL has many advantages, on the other hand it also has some disadvantages such as –

  • The interface of SQL is complex, due to which the user may have trouble using it.
  • Some versions of SQL are expensive, due to which not many users use it.

Difference Between SQL and MySQL (SQL vs MySQL in Hindi)

Following is the difference between SQL and MySQL –

  • SQL is a computer language whereas MySQL There is a Database Management System in which the commands of SQL are used.
  • SQL is a query language with the help of which database can be accessed whereas MySQL is an open source database.
  • With the help of SQL, the database is created whereas in MySQL, with the help of SQL Query, you can insert, delete and manipulate the data.

How to Learn SQL

Like other computer languages, there are resources to learn SQL. You can learn SQL both online and offline. But nowadays online classes have become very advanced here you can learn many things for free.

If you want to learn SQL offline then you can join Coaching Institute or you can also practice SQL by buying books related to SQL.

We have suggested below some reliable websites to learn SQL online for free where you can learn SQL coding language for free.

read these also

FAQ For SQL

Is SQL a programming language?

SQL general purpose one programming language Not there. It is used to manage data in RDBMS. Applications cannot be created in any way using only SQL.

What is the full form of SQL?

The full name of SQL is Structured Query Language.

What is the full form of RDBMS?

The full name of RDBMS is Relation Database Management System.

Why is SQL used?

SQL is used to communicate with the database. According to ANSI (American National Standards Institute), SQL is a standard language for RDBMS.

Conclusion: What is SQL in Hindi

so friends What is the SQL Through this article, we have tried to give you complete information about SQL Language, with the help of which you can start your SQL learning Journey.

It is always our endeavor that all the users who come to our blog can get satisfactory answers to their questions and the user does not have to go to other blogs to find the answer to the same question.

Hope you like this article written by us SQL in Hindi Must have liked this article What Is SQL In Hindi Also share it with your friends who are interested in programming.

Leave a Comment