A Brief Overview of SQL (Structured Query Language)
Fundamentals of SQL
SQL which stands for Structured Query Language is a language to manage and communicate with databases. For instance, it is used for database creation, deletion, update rows by fetching rows, modifying rows, etc. SQL statements are used for tasks like updating data on a database or retrieving data from a database.
SQL is an ANSI (American National Standards Institute) standard language. There are other versions of the SQL language like T-SQL by Microsoft, PSQL by Interbase/ Firebird, etc. Therefore, the most common relational database management systems that use SQL are Sybase, Microsoft SQL Server, Oracle, Ingres, Access, etc. Despite that most of these database systems use SQL, most of them have other additional proprietary extensions that are made particularly for their system. Hence, In this blog, we will be focusing on the ANSI/ ISO standard certified SQL language.
What is SQL?
SQL (Structured Query Language) is a relational query language that is used for interacting with the database. It is used for accessing, storing, and manipulating data in a relational database. SQL is an ANSI/ISO certified standard and mostly all the RDMS uses SQL as a standard database query language.
