Rohith

Creator of whiletrue.live.

@rohithreddykota

Data Definition Language

A data definition language (DDL) is a computer language used to create and modify the structure of database objects in a database. These database objects include views, schemas, tables, indexes, etc. This term is also known as data description language in some contexts, as it describes the fields and records in a database table.

Posted September 22, 2022 by Anusha and Rohith ‐ 6 min read

sql data-definition-language rdbms

Data Manipulation Language

A DML or refers to a computer programming language that allows you to add, delete, and alter data in a database. A DML is typically a sub language of a larger database language like SQL, with the DML containing some of the language's operators.

Posted September 22, 2022 by Anusha and Rohith ‐ 6 min read

sql rdbms data-manipulation-language

Security and Access

Data Control Statements are used for authorizing data access, in order to preserve the security of the data within the database. These statements can ensure that unauthorized users don’t change or view data accidentally or deliberately. Data access authorizations are provided using the GRANT statement.

Posted September 22, 2022 by Anusha and Rohith ‐ 5 min read

sql rdbms security access

Integrity Constraints

An integrity constraint is a declarative way to define a business rule for a column of a table. An integrity constraint is a statement about a table's data that is always true.

Posted September 22, 2022 by Anusha and Rohith ‐ 4 min read

sql rdbms

Database Objects

A database object is any defined object in a database that is used to store or reference data.Anything which we make from create command is known as Database Object. It can be used to hold and manipulate the data. Some of the examples of database objects are : view, sequence, indexes, etc.

Posted September 22, 2022 by Anusha and Rohith ‐ 8 min read

sql rdbms