News About SQL LanguagePosted by tagicon_admin | July 29, 2015 | in : SQL
I am sharing some news about SQL . SQL is a database related language that is used to communicate with database. SQL stands for Structured Query Language which is the American National Standards Institute (ANSI) standard language for operating relational databases. SQL language have some statements that is used to data retrieves, new row entry, changes etc.
Now I am showing example of SQL Statements below:
1/ Data Manipulation Language (DML)
Basically data manipulation language is used to manipulate data from database. Changes existing rows, removes unwanted rows, retrieves data by using DML statement.
2/ Data Definition Language (DDL)
Data Definition Language is used to changes, sets up, removes data structures from tables.
3/ Data Control Language (DCL)
Basically it’s used to give and take power for data access from database. User or Administrator can give power their client to access database by using above DCL statement.
4/ Transaction control
We can change database by using Data Manipulation Language or DML statement, after changing its control by using above statement.
SQL language is a server support language that is used to communicate with the database server to access, manipulate and control data.