Structured Query Language (SQL) is the special purposed programming language. The main purpose of SQL to access data in Relational Database Management System. RDBMS is the most revered DBMS, and the basis for SQL. The data in RDBMS are recorded in relations or table. Relation is the pre-defined rows and column, where column contains attributes, and tuples in rows. Oracle, SQL Server, MySQL are the examples of RDBMS.

There are two languages in SQL: Data Definition Language (DDL) and Data Manipulation Language (DML).

Data Definition Language (DDL)

DDL is One of the fundamental requirements of SQL. One is dumb in the SQL without knowledge of DDL and it is backbone of SQL. It helps to develop overall design of database and helps to create, delete, and modify the database schema. It is not frequently used as database schema is not frequently changed.

Data Manipulation Language (DML)

DML One of the fundamental requirements of SQL. DML helps to work on RDBMS. It helps to change the content of RDBMS as it helps to insert, select, update and delete the database instances. It is frequently used as frequent modification is made in database.



Files

Download

SQL Tutorial (Basic)

Download

SQL Tutorial (Extended)

Download

 

Advertisements