Structured query language

SQL is the protocol that’s used to access, query, and interact with data in your RDBMS. It is common because of the simplicity of performing even advanced data operations and analysis. There are a few main forms of SQL:

• Data Definition Language (DDL): This is a language that lets you define structures and make changes to the schema, tables, constraints, and more. Examples include create, alter, truncate, drop, and rename statements.
• Data Manipulation Language (DML): This language lets you manipulate data in your database. There are four major operations involved in this – Create, Read, Update, and Delete (CRUD). Examples include insert, update, and delete statements.
• Data Query: This is a type of statement that lets you query data and extract results for the desired analysis. An example is a select statement.
• Data Control Language (DCL): This is the language that lets you control access to data in your database in terms of...