Structured Query Language: Part 1

Structured Query Language, also known as SQL, is a programming language designed for managing Relational Database Management Systems (RDBMSs). SQL is an International Organization for Standardization (ISO) standard.

In a RDBMS all the data is stored in tables with each table consisting of rows and columns.

In this entire article I use Oracle 10g express edition software for the database.

Let's move towards the programming

First to do any operation we need a database so let's create a simple database named “College”.

Create database



Output: here we can see our database is created.



Now let's make the table in the database.

Create Table



Now our database and table are created.

Insert the values in the database



To see the output



Output



Here I insert some more values.



If we want to select a specific value then:



Output



Now I inset one more entry with the same name “sanjay” that is already present so now the output is:



Here we can see that there are two “sanjay” with various addresses.

Use of SQL AND



Output



Use of SQL OR



Output



ORDER BY: in SQL this is used to order the selected value in increasing or decreasing order.



Output



UPDATE Statement



Output



DELETE Statement



OUTPUT



DELETE ALL VALUES



Output



This article might not look well designed but in this article I am not focused on the design, I am just trying to provide you a small amount of practical knowledge of all the SQL commands. The remaining commands I'll explain in my next article.

Maybe it will help you!