1 / 7

How are the SQL commands classified | UBIQ - Ubiq BI

SQL commands are sets of instructions, coded into SQL statements, which are then used to communicate with a database to perform specific tasks, work, functions and queries. Learn more about this in this blog.<br>

21310
Télécharger la présentation

How are the SQL commands classified | UBIQ - Ubiq BI

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. What is a database query? A database query pertains to the process of acquiring data or query from a database. It is generally performed using a database query language that generates data of different formats according to function. SQL is the most popular language used for database queries.

  2. Uses of SQL commands SQL commands can be used not just for searching the database but also to execute various other functions. Using SQL commands, you are able to create tables, add data to tables, or modify data, drop the table and even set aside permissions for users.

  3. The 4 categories of SQL commands • DDL (Data Definition Language) • DML (Data Manipulation Language) • TCL (Transaction Control Language) • DCL (Data Control Language)

  4. DDL commands Data Definition Language consists of the SQL commands that are traditionally used to define the description of the database structure. The database then proceeds to automatically commit the current transaction before and after every DDL Command. ALTER, CREATE and DROP are among some of the DDL commands

  5. DML Commands Data Manipulation Language commands are generally used for retrieving, sorting, modifying and deleting data stored in the database. DML Commands are used to deal with the management of data present in the objects of a database. Notable DML commands include INSERT, UPDATE, DELETE & SELECT.

  6. Thank You Visit: https://ubiq.co/database-blog/how-are-the-sql-commands-classified-ubiq/

More Related