Understand Data Manipulation Language (DML), Summaries of Database Management Systems (DBMS)

Download Understand Data Manipulation Language (DML) and more Summaries Database Management Systems (DBMS) in PDF only on Docsity!

Understand Data

Manipulation Language

(DML)

98 - 364 Database Administration Fundamentals

98 - 364 Database Administration Fundamentals

Lesson Overview

1.3 Understand data manipulation language (DML) In this lesson, you will review:  SQL DML — DDL relationship  DML  SELECT  INSERT  UPDATE  DELETE

98 - 364 Database Administration Fundamentals DML — DDL (continued)  data definition language (DDL) A language that defines all attributes and properties of a database, especially record layouts, field definitions, key fields, file locations, and storage strategy. Acronym: DDL.  DDL is used to create the framework for the database, the schema of the database, or both. This will be covered more in DDL review lesson 1.4.

98 - 364 Database Administration Fundamentals

DML

 DML is used to retrieve and modify database information. These commands will be used by all database users during a routine workday. Following is a basic review of some of the most common DML commands

98 - 364 Database Administration Fundamentals

INSERT

The INSERT command is used to add records to an existing

table.

INSERT INTO Grant_info VALUES (‘John’, ‘Doe’,12345,2200) In this code, we have created John Doe, given him a student ID, and set his grant value to $2200. There are four data values specified for the record. These correspond to the table attributes/fields in the order they were defined: first_name, last_name, student_id, and credit.

98 - 364 Database Administration Fundamentals

UPDATE

The UPDATE command can be used to modify information contained within a table, either individual data or groups of data. UPDATE Grant_info SET aid_awarded = aid_awarded + 4000 WHERE student_id = 12345 This UPDATE command calls the Grant_info table and adds $4,000 to the value of the aid award for student 12345.