SQL that stands for Structured Query Language...And what we read as S - Q - L instead of Sequel is an advanced relational database system that offers a robust environment to allow for organization to store their information in a secure manner. Not putting into effect its largest competitor, the Oracle Database.
However, both languages have almost similar syntax, this should not be a confusing factor that learning SQL means you understand Oracle, rather learning SQL makes you understand database manipulation methods that could be used in oracle too.
Before SQL, people would use Microsoft Access that offered an intuitive simple interface for most individuals to work with.
Many powerful tasks can be performed in SQL by use of its mere seven powerful statements:
SELECT
INSERT
UPDATE
CREATE
ALTER
DROP, and
DELETE
The above statements fall under two major categories:
DATA MANIPULATION LANGUAGE (DML), and
DATA DEFINITION LANGUAGE(DDL)
DML:
SELECT- used to select data in one or more columns of one or more tables
INSERT - allows you append rows to an existing table
UPDATE - allows you to update data in one or more rows of one or more tables
DELETE - allow you delete one or more rows from a table or multiple tables
DDL:
CREATE - enables you create new table, or create new index
ALTER - enables you modify structure of existing table thro adding and deleting columns
DROP - enables you delete a table or a database
The next tutorial will be on using the DML and DDL'S
