Database Languages
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.
- 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.