Posts

Showing posts from March, 2023

Information Management - SQL

 A. Data Definition Language - DDL or Data Definition Language is  subset of SQL. It is  language for describing data and it's relationship in a database. You can generate DDL in a script for database objects. B. Interactive Data Manipulation Language - Represents a collection of programming languages explicitly used to make  changes to the database, such as CRUD operations to create, read, update, and delete data. Using INSERT, SELECT, UDTAE, and DELETE commands. C. Embedded Data Manipulation Language - Is a method of combining the computing power of a programming language and the database manipulation capabilities of SQL.