September 17, 2016
Categorised in: Database Management System
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.
Example: create table account (acc_no char(10), balance integer);
DML (Data Manipulation Language)
DML is retrieval, insertion, and deletion of information from database.
Example: select acc_no, balance from account where acc_no = ‘A101’;
Pratik Kataria is currently learning Springboot and Hibernate.
Softwares known and worked on: Adobe Photoshop, Adobe Illustrator and Adobe After Effects.