SQL, or Structured Query Language, is a powerful language used to create, manipulate and manage data in relational database management systems. It is the most widely used language for relational database access and is a standard for many database vendors and products.
SQL is a declarative language, which means it is used to define and manipulate data in a database. It is not a procedural language, which means it does not provide step by step instructions for how to perform a task. Instead, SQL statements describe what data is needed and how it should be organised.
What the statements cover
SQL statements are used to create, alter and delete tables, add and modify columns, insert and delete rows and query data from the database. They are used to create and manipulate views, create and manage indexes and define and manage constraints on the data. SQL statements can also manage users and their permissions.
SQL is used for data analysis, data mining and reporting. It is also used for application development and database administration.
A shared standard
SQL is an ANSI standard, which means it is standardised across different database vendors. That makes it easier to learn and use, because the syntax and commands are consistent across different products.
SQL is a powerful language for managing data in relational databases. It is declarative, standardised and used for tasks ranging from analysis and reporting to application development and database administration. Because it is shared by so many products, it remains one of the most durable skills in data work.
Sources and further reading
Official documentation and reference material for this topic.