Thinkycap logo
Worksheets

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.

Coming soonPractice questions for this topic are coming soonUntil then, you can already practice other topics.Browse topics

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