Introduction of Sub-Languages in SQL
Hi there! 👋 I’m Ganesh , and welcome to my SQL corner — a place where data meets curiosity . Introduction to Sub-Languages in SQL SQL (Structured Query Language) is the standard language used to interact with databases — to store, retrieve, and manage data efficiently. To make it easier to perform different types of operations, SQL is divided into sub-languages , each serving a specific purpose. These sub-languages define how users communicate with the database — whether they are creating structures, manipulating data, controlling access, or retrieving information . The main five sub-languages of SQL are: 🔹 DDL (Data Definition Language): Used to define and manage database structures such as tables, schemas, and indexes. (Examples: CREATE, ALTER, DROP) 🔹 DML (Data Manipulation Language): Used to manipulate and modify data stored in tables. (Examples: INSERT, UPDATE, DELETE) 🔹 DQL (Data Query Language): Used to retrieve data from the database for analysis...