What is SQL in Database Management System ? Different SQL Commands

What Is SQL ? 

The full form of SQL is Structured Query Language, this language is an American National Standard Institute (ANSI) language.  

Meaning that SQL is a structured query language through which structured data is managed in the relational database.

SQL is designed in such a way that you can easily manage any data set.  And with this data can be stored, deleted, retrieved, updated easily.





Different SQL Commands (Structured Query Language)  

Some commands are needed to use SQL (structured query language) in relational databases, let's know about those commands:

DDL (Data Definition Language) 

The full form of DDL is Data Definition Language.  With the DDL command, the structure of the table created in the database is changed.  

For example, deleting, creating, or changing tables.

There are some main commands of the DDL command which are mentioned below,

CREATE 

CREATE statements are used to define the database structure schema.

ALTER 

The alert command allows you to change the structure of the database.

TRUNCATE

The truncate command is used to delete all the rows from the table and free up the space containing the table.


DML (Data Manipulation Language) 

The full form of DML is Data Manipulation Language.  The database is modified by the DML command.

There are some main commands of the DML command which are mentioned below:

INSERT

This is a statement of SQL query.  This command is used to insert data in a row of a table.

UPDATE

This command is used to update or modify the name of a column in a table.

DELETE

This command is used to remove one or more rows from a table.


DCL (Data Control Language) 

The full form of DCL is Data Control Language.  This includes commands like GRANT and REVOKE.  

The DCL command is used to grant or withdraw authority to the database user.

Some main types of DCL command are ,

Grant 

This command is used to grant privileges to a user in a database.

Revoke 

This command is used to withdraw permission from the user.


TCL (Transaction Control Language) 

 The full form of TCL is Transaction Control Language.  The TCL command is used only with DML commands.  Such as insert, delete, update.


DQL (Data Query Language) 

The full form of DQL is Data Query Language.  DQL command is used to fetch data in the database.

 Some main types of DQL commands are ,

SELECT 

This command helps you to select the attribute based on the condition described by the WHERE clause.



Use of SQL 

 As you all will know that a little bit of SQL (Structure Query Language) is used in the database, so we have told you a little more about its use below,

 SQL is used in database, with the help of SQL you can easily manage your database, which means if you ever want to change something in your database, you can do it easily with help of SQL.

 Apart from this, if you want to enter some new data in your database or want to delete any data, or want to make some changes to it, you can do all this easily with the help of SQL.

 If you also want to use SQL, then you install its software on a good configuration computer or laptop and connect your database with SQL, then you can easily access your database with the help of SQL.


History of SQL 

 SQL was first developed by researchers at IBM.  Those researchers were Raymond Boyce and Donald Chamberlin, both of whom created the SQL programming language for the first time in 1970.  When SQL was first developed, its name was SEQUEL, then it was changed to SQL (Structured Query Language).

 The purpose of developing SQL was that it was created to manage IBM's database, that is, System R.  Then in 1979, a company named "Relational Software", which later became an Oracle company, took out the modified version of SQL and it was named Oracle V2.

 After this, gradually according to time, SQL kept on changing and it reached a very good position in the database world.  Then the arrival of a language like MySQL helped the database user a lot in using the database and now anyone can do it very easily.


So friends, how did we like this post?  I hope you all must have liked this post of ours and through this post of ours, we have been able to convey some information to you.  If you like to read more posts like this, then you must mail us or tell us by commenting in the comment box.  We will bring you more such good and informative posts.  And do not forget to share this post of ours with your friends and on social media platforms so that more people can read this and get some information.  And also follow our social media pages so that you can get our play post or any update soon.  We will wait for your question and suggestion.




Comments

Post a Comment

Popular posts from this blog

Problem Solving Methodology and Techniques

Image
What is   Algorithm  ? The algorithm is defined as the step-by-step solving of a problem in the user's language.   It is considered an effective procedure for solving a problem with an infinite number of steps.  The characteristics of the algorithm are,  Precise  Unambiguous  Finite termination  Unique solution Once the algorithm is written, it can be coded into a problem using any programming language.  The algorithm uses 3 different constructs Sequence: sequence says that instructions are to be executed in what order or sequence. Branching or decision making: Branching involves testing or condition and based on the outcome of the condition testing different instruments are executed. Repetition: Repetition means one or more instructions shall be repeated several times.  This is otherwise called a loop.  There are different types of loops such as,  do-while, for What is    Pseudocode ? It is a concise descri...
Post

What is Internet how does it Work ?

Image
The Internet today is an amazing technology that knows everything. If the internet was not there, it would not have been as fast as the world is moving today. In today's time, everyone uses the internet and why should everything become so easy with the help of the internet.  But not as much as the Internet is beneficial, but it is also harmful. So if you also use the Internet, then you should know about the Internet.  That is why I have done this article for all of you so that everyone can understand the internet in a very easy and simple language. So let's know with complete information about the internet. What is the internet? The internet is that the largest network within the world, connecting many computers.  A network may be a group of two or more computer systems linked together. The internet is a wire that is in the sea around the world.  And this wire keeps information and data moving around the world. This data can be anything like text, mp3, document, imag...
Post

What is a Data Structure and its Types ?

Image
If you also like to read computer-related information or if you are a computer science student, then this post can be beneficial for you.  In this article, I have explained what is a data structure?  How many types of data are there?  And many more.  To understand the data structure, we need to know what is data.  So let's know about the data and its structure. What is Data ? Data is any row fact or value are called data. Value can be anything if there is any value like 1,2,3,4,5,6 all these have value means it is data.   If we talk about the second example, then a book is also data because it is a book, and the book has value.  Meaning that even the thing which has some value is called data. What is Information ? Information is processing data.  Meaning that if any data is on process mode then we can call that data information.   For example, if we talk about an example, I told you that "you come to me", so the one who told me is ...
Post