SQL - Data Manipulation/Query Language (DML/DQL)
- is a type of Structured Query Language (SQL) used to CRUD (Create, Retrieve, Update, Delete) data in a data structure defined by Description Language (DDL)
- these include:
- SELECT
- INSERT
- UPDATE
- DELETE
- BULK INSERT - imports a data file into a database table or view in a user-specified format
- MERGE - performs INSERT, UPDATE, and/or DELETE operations on a target table based on the results of a JOIN with a source table in one transaction