What is SQL?
SQL stands for Structured Query Language. It’s a standardized format for querying and managing databases.
How is SQL used, and what are DDL and DML?
SQL is by far the most common language for data communication. Although by definition it may seem like all databases use the same version of SQL, but this is far from the truth. Most databases have at least some proprietary SQL. What’s more, some databases don’t support SQL at all, or use a significantly truncated and simplified version of SQL.
Within SQL, common operations are grouped into DML, “Data Management Language”, and DDL, “Data Definition Language”. DML statements like SELECT, UPDATE, and INSERT let users retrieve, store, modify, delete, insert and update data in the database. DDL statements like CREATE, ALTER and DROP allow a database manager to create, modify, and remove database objects such as tables, indexes, and users.
How is SQL supported in Snowflake?
Snowflake is a data warehouse that supports the most common standardized version of SQL: ANSI. This means that all of the most common SQL operations are usable within Snowflake. Snowflake also supports all of the operations that enable data warehousing operations, like create, update, insert, etc.