INFORMATION MANAGEMENT(MODULE 4)

Zyvrex John R Perez

BSIT - 1A

What is SQL?

    Structure Query Language stands for Structured Query Language. A database access and manipulation standard language. It follows the ANSI standard.

SQL can do:

• SQL can execute queries against a database
• SQL can retrieve data from  a database 
• SQL can insert records in a database
• SQL can update records in a database
• SQL can delete records from a database
• SQL can create new databases
• SQL can create new tables in a database
• SQL can create stored procedures in a database
• SQL can create views in a database
• SQL can set permissions on tables, procedures and views

SQL Commands : 

• SELECT - extract 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