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 currently learning Springboot and Hibernate.
Technologies known and worked on: C/C++, Java, Python, JavaScript, HTML, CSS, WordPress, Angular, Ionic, MongoDB, SQL and Android.
Softwares known and worked on: Adobe Photoshop, Adobe Illustrator and Adobe After Effects.