SQL commands for AL ICT students...

key points.

1. SQL key words are "NOT CASE SENSITIVE".
2. semi colon (;) is required at the end of each statements. 

Some of The Most Important 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 

• Lets create a data base called "SchoonInformation".

CREATE DATABASE SchoolInformation;

• Lets delete the database.

DROP DATABASE SchoolInformation;

•