DEFINITIONS SQL

 A. DATA DEFINITION LANGUAGE

In my own Understanding, DATA DEFINITION LANGUAGE is a language that is used to modify data and define data structures. For instance, the DDL commands could be used to remove, add, or modify tables within a database.

B. INTERACTIVE DATA MANIPULATION LANGUAGE

Data Manipulation Language represents a set of programming languages that are explicitly used to change the database, such as CRUD operations to create, read, update, and delete data. INSERT, SELECT, UPDATE, and DELETE commands are used.

C. EMBEDDED DATA MANIPULATION LANGUAGE

 

Embedded SQL is a technique for merging a programming language's computing capability with SQL's database manipulation skills. Embedded SQL statements are SQL statements that are written directly within the source code of a program written in the host language.