Concept of SQL: Categories of SQL Commands (Especially for GATE-Geospatial 2022)

Doorsteptutor material for CTET-Hindi/Paper-1 is prepared by world's top subject experts: get questions, notes, tests, video lectures and more- for all subjects of CTET-Hindi/Paper-1.

Examrace Books on Mapping, GIS, and Remote Sensing prepares you throughly for a wide range of practical applications.

What is SQL?

SQL (Structured Query Language) is a programming language designed for managing data in a relational database. SQL has a variety of functions that allows its users to read, manipulate, and change data.

The SQL is the abbreviation for structured query language, and we pronounce it either see-kwell or S-Q-L. Many different versions of SQL exit, but it is the current industry standard query language for requesting information from databases.

The SQL was adopted as a standard by American National Standards Institute (ANSI) in 1986 and International Organization for Standardization (ISO) in 1987. Although SQL is defined by both ANSI and ISO, there are many extensions to and variations on the version of the language defined by these standards bodies. Language extensions such as PL/SQL are designed to address this by turning SQL into a full-fledged programming language while maintaining the advantages of SQL.

SQL is that ‘SQL is not structured, nor is it limited to queries, nor is it a language.’ This is founded on the notion that pure SQL is not a classic programming language. On the other hand, however, it is a programming language because it has a grammar, syntax, and programmatic purpose and internet.

Categories in SQL Commands

There are three categories in SQL commands. They are namely:

  • Data Definition Language (DDL)
  • Data Manipulation Language (DML)
  • Transaction Control Commands
This Diagram Shows Categories in SQL Commands

Developed by: