Welcome to Ed2Ti Blog.

My journey on IT is here.

Introduction to Databases [2/5]

- Posted in Trebas College by

DDL (Data Definition Language): Used for defining and managing database objects.

Key Commands:
- CREATE: Used to create database objects (e.g., tables, indexes).
- ALTER: Used to modify the structure of existing database objects.
- DROP: Used to delete database objects.

DML (Data Manipulation Language): Used for managing data within database objects.

Key Commands:
- SELECT: Retrieves data from one or more tables.
- INSERT: Adds new rows of data into a table.
- UPDATE: Modifies existing data in a table.
- DELETE: Removes rows from a table.

DCL (Data Control Language): Manages access to data within the database.

Key Commands:
- GRANT: Provides specific privileges to database users.
- REVOKE: Removes specific privileges from database users.

TCL (Transaction Control Language): Manages transactions within a database.

Key Commands:
- COMMIT: Saves changes made during the current transaction.
- ROLLBACK: Undoes changes made during the current transaction.
- SAVEPOINT: Sets a point within a transaction to which you can later roll back.