DDL, DML, and EDML

 We'll discuss the key concepts of databases in this article, along with the roles played by Data Definition Language (DDL), Interactive Data Manipulation Language (DML), and Embedded Data Manipulation Language. (EDML).

A database is a structured collection of data that is kept up and stored in a way that makes the data simple to retrieve, edit, and analyze. The most common method of organizing databases is through tables, which are composed of rows and columns that correspond to certain entries and data attributes.

Database administrators and developers work with data in databases using the specialist languages DDL, DML, and EDML. DDL is typically used to establish and modify the structure of a database, including the creation of tables, indexes, and other objects. DDL statements are frequently used to define a database's structure, which determines the types of data that can be stored and their relationships.

DML, on the other hand, is used to interface with database-stored data. DML commands can be used to add to, modify, delete, and retrieve table data. The most frequent DML command is the SELECT statement, which permits the retrieval of specified data from a table based on predetermined criteria. The DML statements INSERT, UPDATE, and DELETE can be used to add to, modify, or remove a table's data.

Last but not least, database data manipulation from within programs is made possible by EDML, a programming language that is embedded within other programming languages. It is very advantageous to create programs that communicate with databases because they allow users to manage and manipulate data within a database without moving to a new interface.