Please disable adblock to view this page.

← Go home

Database Languages

data_model_roles-svg

September 17, 2016
Published By : Pratik Kataria
Categorised in:

data_model_roles-svg

A database system provides a data definition language to specify the database schema and a data manipulation language to express database queries and updates.

DDL (Data Definition Language)

We specify a database schema by a set of definitions expressed by a special language called a DDL.

  • Create
  • Alter
  • Drop
  • Truncate
  • Comment

Example: create table account (acc_no char(10), balance integer);

DML (Data Manipulation Language)

DML is retrieval, insertion, and deletion of information from database.

  • Insert
  • Update
  • Delete
  • Query

Example: select acc_no, balance from account where acc_no = ‘A101’;

Pratik Kataria is a budding programmer, web designer and developer.