Structured Query Language(SQL) - Processing Skills of SQL | 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)

Chapter: 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)

Processing Skills of SQL

The various processing skills of SQL are

Processing Skills of SQL

The various processing skills of SQL are :

Data Definition Language (DDL) : The SQL DDL provides commands for defining relation schemas (structure), deleting relations, creating indexes and modifying relation schemas.

Data Manipulation Language (DML) : The SQL DML includes commands to insert, delete, and modify tuples in the database.

Embedded Data Manipulation Language : The embedded form of SQL is used in high level programming languages.

View Definition : The SQL also includes commands for defining views of tables.

Authorization : The SQL includes commands for access rights to relations and views of tables.

Integrity : The SQL provides forms for integrity checking using condition.

Transaction control : The SQL includes commands for file transactions and control over transaction processing.

Tags : Structured Query Language(SQL) , 12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL)

Study Material, Lecturing Notes, Assignment, Reference, Wiki description explanation, brief detail

12th Computer Science : Chapter 12 : Database concepts and MySql : Structured Query Language(SQL) : Processing Skills of SQL | Structured Query Language(SQL)