BLOGPOST MODULE 4

 A. ENGAGE
    A. WHAT IS SQL?

SQL or Structured Query Language is a programming language used to interact with and manage data stored in relational databases. It allows you to retrieve, add, modify, and delete data from these databases, as well as create and modify tables, indexes, and other database structures.

SQL is widely used in businesses and organizations of all sizes to manage large amounts of data efficiently and effectively. It's an essential tool for data analysts, software developers, and anyone who needs to work with databases.

B. EXPLORE AND EXPLAIN

1. What are some sql commands?

Some sql commands are:
Select    -    Used to retrieve data from one or more tables.
Insert    -    Used to add new data to a table.
Update  -    Used to modify existing data in a table.
Delete    -    Used to remove data from a table.
Create   -    Used to create new database objects, such as tables, views, and indexes.
Alter      -    Used to modify the structure of an existing database object.
Drop      -    Used to delete an entire database object.
Where   -    Used to filter data based on specific conditions.

2. What is the difference between drop and delete command?

When DROP is used, the deletion is permanent and cannot be undone while the DELETE is reversible, depends if the transaction is not yet being committed. In addition, DROP command is used for deleting an entire database while the DELETE is used to remove specific rows in a table. 

C. ELABORATE AND EVALUATION

Answer the following questions: Identification

SELECT            1. Extracts data from a database.

INSERT             2. Inserts new data into a database.

ALTER               3. Modifies a table.

SQL or Structured Query Language 4. A standard language for accessing and manipulating                                                                                   databases.

SQL                    5. Can set permissions on tables, procedures, and views.