Introduction to SQL

 What is Data Definition Language?

    Data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. In the context of SQL, data definition or data description language is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. 

    Data Definition Language (DDL) is a subset of SQL. It is a language for describing data and its relationships in a database. You can generate DDL in a script for database objects to keep a snapshot of the database structure. Set up a test system where the database acts as the production system but contains no data.

What is Interactive Manipulation Language?

Interactive manipulation language is a component of the SQL that is used to insert, delete and update tuples in a relation.

What is Embedded Data Manipulation Language?

Embedded Data Manipulation Language is a method of inserting inline SQL statements or queries into the code of a programming language, which is known as a host language. Because the host language cannot parse SQL, the inserted SQL is parsed by an embedded SQL preprocessor.