All about DATA

A. DATA DEFINITION LANGUAGE

Data Definition Language (DDL) is a subset of SQL used to define and manage the structure of database objects, such as tables, indexes, and schemas, including creating, altering, and deleting these objects.



B. INTERACTIVE DATA MANIPULATION LANGUAGE

Interactive Data Manipulation Language (IDML) is a part of SQL that lets you interact with and manage the data in a database. It includes commands that allow you to retrieve data, add new data, change existing data, and remove data. The SELECT command is used to get data from the database, like asking the database a question and getting an answer back. The INSERT command adds new data into the database, similar to putting new information into a file. The UPDATE command changes existing data in the database, like editing a file to update some information. The DELETE command removes data from the database, similar to erasing information you no longer need. In essence, IDML is all about how you can work with the information stored in a database.


C. EMBEDDED DATA MANIPULATION LANGUAGE

Embedded Data Manipulation Language (EDML) allows SQL statements to be included directly within programming code (like C, Java, or Python) to interact with databases. It simplifies communication between programs and databases by integrating SQL commands directly into the code, enabling seamless management and manipulation of data.





 

Comments

Post a Comment

Popular posts from this blog

Introducing SQL

Image
What is SQL? SQL stands for Structured Query Language. It's a standard programming language used for managing and manipulating databases. With SQL, you can perform various tasks such as querying data, inserting new records, updating existing records, and deleting records from a table. Additionally, you can create and modify the structure of the database, including tables, indexes, and views. SQL is crucial for anyone who needs to interact with databases, like database administrators, developers, and data analysts.
Read more

Components of database

Image
  1. What are the different components of dbms? A Database Management System (DBMS) typically consists of several components that work together to efficiently manage and organize data. The key components of a DBMS include: Database: Definition: The database is the collection of related data that is logically structured and stored in a specific format. It serves as the foundation for a DBMS. Data Dictionary: Definition: Also known as metadata, the data dictionary contains information about the database, including the structure of tables, relationships, constraints, and other details. It acts as a guide for the DBMS to understand and manage the data. Database Engine: Definition: The database engine is the core of the DBMS. It is responsible for processing queries, managing transactions, and ensuring data integrity. The engine interacts with the data stored in the database. Query Processor: Definition: The query processor interprets and executes queries written in a database query...
Read more