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


Here I insert some more values.

If we want to select a specific value then:


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


Use of SQL OR


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


UPDATE Statement


DELETE Statement




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!