BD-I

This repository refers to the classes about "Database I".

DDL (Data Definition Language):

• CREATE: Creates objects in the database, such as tables, indexes, or stored procedures.
• ALTER: Modifies the structure of existing objects, such as adding or removing columns from a table.
• DROP: Deletes objects from the database, such as tables or indexes.
• TRUNCATE: Removes all records from a table, keeping its structure.

DML (Data Manipulation Language):

• SELECT: Retrieves data from one or more tables.
• INSERT: Adds new records to a table.
• UPDATE: Modifies existing data in a table.
• DELETE: Removes records from a table.

DCL (Data Control Language):

• GRANT: Grants permissions to users or roles to perform operations on the database.
• REVOKE: Withdraws previously granted permissions.

TCL (Transaction Control Language):

• COMMIT: Confirms the ongoing transaction, making the changes permanent.
• ROLLBACK: Undoes changes made during the transaction.
• SAVEPOINT: Sets a point within a transaction to which you can later roll back.

DQL (Data Query Language):

• SELECT: Although part of DML, SELECT is often considered a query language.

These are the main types of SQL commands, each playing a specific role in managing and manipulating data in a relational database.