Structured Query Language: Part 1

Structured Query Language

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

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

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

Let's move toward 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 insert one more entry with the same name, "sanjay" that is already present, so now the output is:

Here we can see two "sanjay" with various addresses.

Use of SQL AND


Use of SQL OR


ORDER BY. SQL 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 with a small amount of practical knowledge of all the SQL commands. Remaining commands I'll explain in my next articleI'llybe it will help you!

Similar Articles