SQL commands allow you toinstruct a database management system (DBMS) to perform certain tasks. This may include defining tables and their structure, inserting, modifying or deleting data and performing queries.
Different ISO or ANSI standards frame the scope of SQL commands. Additionally, there are several implementation-specific dialects. This way, implementations from major vendors such as PostgreSQL, MySQL, Oracle DBMS and Microsoft SQL Server all have their own variant for this language. Some vendors have their own controls; most of the time, their differences mainly relate to functions related to the processing of character strings and other data.
In reality, SQL is composed of several sub-languages, each of them covering a different domain and benefiting from its own commands. Discover with us the main types of SQL commands.
