SQL stands for Structured Query Language. It is a language used in programming and used to access and manipulate data in databases. SQL was developed in 1970s, but over time it has become one of the most used query language
Why SQL?
The reason why SQL has become one of the most common language in programming and accessing data in databases are as follows;
1.SQL is standard and has been well documented. Therefore, people can easily learn the language.
2.SQL can as well analyze data of any size, be it small or large stacks of data, SQL can easily analyze them.
3.The language is also simple and non-procedural.
Some of the basic commands in SQL are as follows
SELECT this command extract data from a database.
DELETE this command delete data from a database
UPDATE this command update data in a database
INSERT INTO this command insert new data into a database
ALTER this command is used to modify a table.
SQL SYNTAX
Syntax is the structure of statement in computer language. Since SQL is a computer language, the are specify sets of rules that are followed when writing it. They include:
1.SQL keywords can either be written in uppercase or lowercase, it is not case sensitive.
2.SQL statement can be written in a single line or multiple lines.
SQL can be used to access and manipulate data in all relational databases which include;
-MySQL
-Oracle
-PostgreSQL
-MSSQL .etc
Therefore, SQL is a language that one should know in order to be successful as a data analyst, data scientist and even data engineer and many other careers.
Top comments (0)