MIDTERM - LECTURE ACTIVITY TASK MODULE 3
I. LEARNING TASKS A. ENGAGE A. Data Definition Language What is a Data Definition Language (DDL)? - Using predefined commands and a particular syntax, Data Definition Language (DDL) is used to construct and modify the structure of objects in databases. Tables, sequences, locations, aliases, schemas, and indexes are some examples of these database objects. B. Data Manipulation Language - A Data Manipulation Language (DML) is a computer programming language used to add (insert), delete, and alter (update) data in a database. A DML is frequently a sublanguage of a larger database language such as SQL. C. Embedded Data Manipulation Language - A technique known as Embedded SQL is used to incorporate inline SQL statements or queries into the source code of a programming language, sometimes referred to as a host language. This is a reliable and practical way of fusing a programming language's computing capability with SQL's particular data management and manipula...