Most of the actions you need to perform on a database are done with SQL statements. For example:

SELECT * from Customers;

SQL Keywords are NOT case sensitive: select is the same as SELECT

SELECT/select * from Customers;

Semicolon after SQL Statements

Some database systems require a semicolon at the end of each SQL statement.

Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.

Some of The Most Important SQL Commands

data

• 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

database

• CREATE DATABASE - creates a new database
• ALTER DATABASE - modifies a database

table

• CREATE TABLE - creates a new table
• ALTER TABLE - modifies a table
• DROP TABLE - deletes a table