Mediaspace scheduled maintenance: Aug 25, 2026 07:00 - 12:00 AM. During this time, videos will be temporarily unavailable. Check status updates.

Lecture

Data Definition and Manipulation Languages: Views

Description

This lecture covers the main aspects of data definition language, including creating, modifying, and deleting tables, as well as data manipulation language, such as inserting new data, updating existing data, and deleting data. Additionally, the instructor briefly discusses views, which are virtual tables representing non-editable collections of data gathered by an SQL query.

In MOOC

Geographical Information Systems 1

Official source

Ontological neighbourhood

Computer engineering

Databases: Relational databases

Related concepts (10)

Data definition language

In the context of SQL, data definition or data description language (DDL) is a syntax for creating and modifying database objects such as tables, indices, and users. DDL statements are similar to a computer programming language for defining data structures, especially database schemas. Common examples of DDL statements include CREATE, ALTER, and DROP. The concept of the data definition language and its name was first introduced in relation to the Codasyl database model, where the schema of the database was written in a language syntax describing the records, fields, and sets of the user data model.

Data manipulation language

A data manipulation language (DML) is a computer programming language used for adding (inserting), deleting, and modifying (updating) data in a database. A DML is often a sublanguage of a broader database language such as SQL, with the DML comprising some of the operators in the language. Read-only selecting of data is sometimes distinguished as being part of a separate data query language (DQL), but it is closely related and sometimes also considered a component of a DML; some operators may perform both selecting (reading) and writing.

Data control language

A data control language (DCL) is a syntax similar to a computer programming language used to control access to data stored in a database (authorization). In particular, it is a component of Structured Query Language (SQL). Data Control Language is one of the logical group in SQL Commands. SQL is the standard language for relational database management systems. SQL statements are used to perform tasks such as insert data to a database, delete or update data in a database, or retrieve data from a database.

Data query language

Data query language (DQL) is part of the base grouping of SQL sub-languages. These sub-languages are mainly categorized into four categories: a data query language (DQL), a data definition language (DDL), a data control language (DCL), and a data manipulation language (DML). Sometimes a transaction control language (TCL) is argued to be part of the sub-language set as well. DQL statements are used for performing queries on the data within schema objects. The purpose of DQL commands is to get the schema relation based on the query passed to it.

Query language

A query language, also known as data query language or database query language (DQL), is a computer language used to make queries in databases and information systems. A well known example is the Structured Query Language (SQL). Broadly, query languages can be classified according to whether they are database query languages or information retrieval query languages. The difference is that a database query language attempts to give factual answers to factual questions, while an information retrieval query language attempts to find documents containing information that is relevant to an area of inquiry.

Related lectures (24)

SQL: Data Manipulation and Views MOOC: Geographical Information Systems 1

Covers SQL data manipulation language, including DDL and DML commands.

DDL, DML, Views MOOC: Geographical Information Systems 1

Covers SQL data definition, manipulation, and views in databases.

Data Definition and Manipulation Languages MOOC: Geographical Information Systems 1

Covers the creation, modification, and deletion of tables, data manipulation, and views.

Data Wrangling with Hive: Managing Big Data Efficiently

Covers data wrangling techniques using Apache Hive for efficient big data management.

Querying a database: the SQL language MOOC: Geographical Information Systems 1