Terminologies of SQL
DATA DEFINITION LANGUAGE – It is a computer programming language that provides commands dedicated to enacting specific tasks within the SQL and the database, such as the few below:
Define relation schemes – DDL describes the relation’s design and structure, like its name, set of attributes, fields, and columns. Delete relations – DDL can remove relations that are redundant to the database. Create indices – DDL minimizes the number of disk accesses needed whenever a query is processed, designed to locate and access the database’s data.
In the SQL query, the commonly used DDL commands are the following:
CREATE - creates a database or objects (tables, views, stored procedures, etc.) ALTER - modifies the structure of an already existing table. DROP - deletes an existing database or an object within a database. TRUNCATE - deletes all the table’s records.
There are also other commands available to use in SQL, such as:
RENAME - rename any table object (with or without data) at any time. COMMENT - allows the user to add in-line comments to view definitions.
INTERACTIVE DATA MANIPULATION LANGUAGE – It is a programming language used to build applications that perform data analysis and insert, delete, and update tuples in a relation.
Although, what exactly is a tuple? For starters, it is not the row we see in the database, but they are unordered sets of known values with names.
EMBEDDED DATA MANIPULATION LANGUAGE – It is a programming language that enables developers to incorporate data manipulation statements directly into the code of an application, used in applications that require interaction with a database and data manipulation uses. It is also the DML’s embedded version, utilized to apply SQL statements to the programs we created while using other programming languages.
