 Welcome back MechanicalEI, did you know that data manipulation commands are a set of commands using which we can perform certain operations on a database? This makes us wonder, what are data manipulation commands in SQL? Before we jump in check out the previous part of this series to learn about what SQL is. Now, data manipulation commands as the name suggests are used to retrieve and manipulate data in a relational database. These are a part of data manipulation language or DML. There are four major data manipulation commands. First is a select command. It is used to retrieve data from the database and allows database users to retrieve the specific information they desire from an operational database. It returns a result set of records from one or more tables. Second comes the insert command, which is used for inserting data into a table. Using this command, you can add one or more records to any single table in a database. It is also used to add records to the existing code. Third comes the update command. It is used to modify the records present in the existing table. Fourth and last is the delete command. It is used to delete some or all records from the existing table. A data control language is defined as a language that is used for controlling privileges in a database. These privileges are required for performing all the database operations such as creating sequences, views or tables. It is a part of the structured query language. There are two types of commands in a data control language. First is the grant command. It is used for offering access or privileges to the users on objects of the database. Through this command, the users get access to privileges in the database. The general syntax for the grant command contains a privilege name, object name and username. Second comes the revoke command. The main purpose of the revoke command is cancelling the previously denied or granted permissions. Through the revoke command, access to the given privileges can be withdrawn. In simple words, the permission can be taken back from the user with this command. The general syntax for the revoke command involves privilege, list, relation name and username. Hence, we first saw what data manipulation commands are and then went on to see what data control commands are.