Introduction - SQL\PLSQL

What is SQL?

SQL : Structured Query Language

     SQL is a standard language designed for accessing and managing data in Relational Database Management Systems (RDBMS).

    SQL is based on ANSI (American National Standards Institute) standard introduced in 1986 and there are many SQL database software’s available in the market which follows the ANSI standard like:

·         Oracle

·         Mysql

·         Sqlserver

·         DB2 ……etc

What Can SQL do?

·         SQL can execute queries against a database

·         SQL can retrieve data from a database

·         SQL can insert records in a database

·         SQL can update records in a database

·         SQL can delete records from a database

·         SQL can create new databases

·         SQL can create new tables in a database

·         SQL can create stored procedures in a database

·         SQL can create views in a database

·         SQL can set permissions on tables, procedures, and views

Using SQL we execute different commands on RDBMS software’s to perform different operations on the data available in the database.

 Whenever we execute a SQL command the RDBMS software translates our command into understandable format of the database and do the necessary operation on data

To make it simple SQL Commands are divided into five categories, depending upon what they do.

1.    Data Retrieval Language (DRL)

2.    Data Manipulation Language (DML)

3.    Data Definition language (DDL)

4.    Transaction Control Language (TCL)

5.    Data Control Language (DCL)

What is PLSQL?

PL\SQL : Procedural Language/Structured Query Language

                      SQL has a special version named PL/SQL, which is sometimes termed as a super set of SQL. It bridges the gap between database technology and procedural languages as programmers can use PL/SQL to create programs for validation and manipulation of table, something that was not possible with SQL. 

  Please refer upcoming posts for more explanation .