Structured Query Language (SQL) is a database query language generally used for creation, reading, retrieval, updating, and deletion (CRUD) in relational databases.
CRUD (Create, Read, Update, Delete) is
the scope of SQL that creates the following sub-languages:
1. Data query language DQL2. Data definition language DDL
3. Data control language DCL
4. Data manipulation language DML
According
to the American national standards Institute (ANSI), it is the standard language for the relational database management system.
But
why?
Why is Structured Query language one of the most essential skills that a Data Scientist can have in his/her respective field?
Why is Structured Query language one of the most essential skills that a Data Scientist can have in his/her respective field?
Because
SQL makes the excruciating & repetitive task of Data analytics easier by
streamlining data into a format that is much easier to work with. People
sometimes used the moot argument of Alternatives for data storage, but they
forget that such alternatives are generally not capable of handling large
amounts of data while SQL can’t only handle such work but is faster and more
efficient.
General Uses Of SQL
1. SQL executes queries
2. SQL inserts, updates, delete records from a database
3. SQL creates new tables and new databases
4. SQL stores data and can set permissions on these data storage formats like tables
1. SQL executes queries
2. SQL inserts, updates, delete records from a database
3. SQL creates new tables and new databases
4. SQL stores data and can set permissions on these data storage formats like tables
For SQL to be used, RDBMS(Relational Database Management System) is required. There are many such RDBMS available such as MySQL, PostgreSQL, IBM DB2, Oracle DB, and Microsoft Access.
We will learn about the types of SQL commands in the next post...