Intro to SQL (Database series)

SQL stands for Structured Query Language. Generally, some people pronounce it as "sequel" while some call it "S-Q-L". SQL is composed by some commands to create tables, to relate them, produce various types of data manipulation and data administration, and to query database to generate useful information. Now we learn what the basic commands of SQL are.

 

The SQL command can be categorised into two broad categories, which are:

1. Data Definition Language (DDL). This type of commands allows us to creates database objects such as tables, indexes, and views as well as to define access right to those database objects.

2. Dana Manipulation Language (DML). This type of commands allows us to insert, delete, update, and retrieve data within table.

As you see above that those commands are relatively easy to learn because they are not too many and similar to English vocabulary. Keep in mind, those commands are basics. Since we are dealing with relational database management systems, in the real world we have to cope with the complex relations.