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

Output

Here I insert some more values.

If we want to select a specific value, then:

Output

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

Output

Use of SQL OR

Output

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

Output

UPDATE Statement

Output

DELETE Statement

OUTPUT

DELETE ALL VALUES

 

Output

Summary

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!