Data Manipulation Language (DML)
Bachelor of Science in Computer Science · University · Database Systems
This unit introduces the Data Manipulation Language (DML), which allows users to manipulate data in a database. Students will learn how to use SELECT, INSERT, UPDATE, and DELETE statements to retrieve, add, modify, and remove data from tables.
What's included
- Introduction to Data Manipulation Language (DML)
- SELECT Statement: Syntax
- Operators
- and Clauses
- INSERT Statement: Adding New Data
- UPDATE Statement: Modifying Existing Data
- DELETE Statement: Removing Data
- WHERE and HAVING Clauses: Filtering and Grouping Data
- Data Aggregation Functions (e.g.
- SUM
- COUNT
- AVG)
Keywords
- DML
- SQL
- SELECT
- INSERT
- UPDATE
- DELETE
- Data Manipulation
- Database Systems