FINALS- LECTURE ACTIVITY TASK MODULE 4

I. LEARNING TASKS

 A. ENGAGE 

A. WHAT IS SQL? 

A relational database's Structured Query Language (SQL) is a programming language used to store and process data. In a relational database, data is stored in tabular form, with rows and columns denoting various data qualities and the relationships between the values of those attributes.

B. EXPLORE & EXPLAIN

Answer the following questions: 

1. What are some sql commands?

• SELECT - extracts data from a database
• UPDATE - updates data in a database
• DELETE - deletes data from a database
• INSERT INTO - inserts new data into a database
• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database
• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table
• CREATE INDEX - creates an index (search key)
• DROP INDEX - deletes an index

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

DELETE command is a Data Manipulation Language while DROP is a Data Definition Language. Delete is used to remove tuples from a table and DROP is used to remove entire schema, table, domain or constraints from the database.

C. ELABORATE & EVALUATION
Answer the following questions: Identification

SELECT 1. . Extracts data from a database.
INSERT 2. Inserts new data into a database.
ALTER TABLE 3. . Modifies a table.
Structured Query Language (SQL) 4. A standard language for accessing and manipulating databases.
Grant Permissions 5. Can set permissions on tables, procedures, and views.