SQL

Edited October 6, 2020

SQL stands for Structured Query Language. It is the standard language for storing, manipulating and retrieving data in relational databases like MySQL, Oracle, SQL Server, MS Access, Postgres, etc.

What is SQL?#

SQL stands for Structured Query Language. It is the standard language for storing, manipulating and retrieving data in relational databases like MySQL, Oracle, SQL Server, MS Access, Postgres, etc.

Who should use SQL?#

Software developers and data scientists who want to interact with data stored in a relational database

When should I use SQL?#

• Application development that involves a relational database
• Analysis and exploration of data stored in a relational database

How do I learn about it?#

Useful links to learn basics of SQL:

• https://www.w3schools.com/sql/default.asp
• https://www.tutorialspoint.com/sql/sql-overview.htm
• https://www.geeksforgeeks.org/sql-tutorial/

Strengths#

• Fast query processing
• Standardized language for relational databases
• Easy to learn and understand
• Portable across platforms

Limitations#

• Complex interface which makes some users uncomfortable while dealing with the database
• Some of the databases go to the proprietary extensions to standard SQL for ensuring the vendor lock-in