General SQL Terms

General SQL Terms

1. Insert

   • used to add data to an existing table
     • The table where the data is added
       • it is passed using an argument of type sql_name or sql_string.
         • Los argumentos opcionales tipo ref_columna permiten definir las columnas en las cuales insertar los valores

2. Create

   • is used to create a new empty database
     • A CREATE statement in SQL creates
       • an object within a relational database management system (RDBMS).

3. SQL

   • domain specific language used in programming,
     • designed to manage, and retrieve information from systems
       • relational database management

4. Drop

   • The DROP statement is used to
     • permanently delete an index, table or database.

5. Update

   • used to modify values ​​in a table
     • The SET clause sets the new values ​​for the indicated columns
       • The WHERE clause is used to select the rows that we want to modify.

6. DDL

   • is the one in charge of modifying the structure of the database objects
     • Includes commands to modify, delete or define the tables in which the database data is stored

7. Rename

   • used to rename an existing database object (like Table, Column)
     • to a new name. Renaming a table does not cause it to lose any data contained in it

8. Delete

   • allows you to delete one or multiple records
     • Even all the records in a table, leaving it empty.
       • The condition, as always, defines the conditions that the records to be deleted must meet

9. DML

   • is a language provided by the database management system
     • that allows users to carry out the tasks of querying or manipulating the data
       • organizados por el modelo de datos adecuado.

10. Select

    • The SELECT statement allows us
      • query the data stored in a table in the database.