Database Wisdom: SQL - DML

DML

The Data Manipulation Language, DML, allows a person to query data (view it), modify it (add new or change existing) and to delete it. DML has evolved into a very robust, set based, data management and manipulation language.

DML includes many keywords such as SELECT, INSERT, UPDATE, DELETE, FROM, etc. each of these keywords will be explained below and examples will be given. This book will not cover every possible DML keyword or even every possible syntactical variant of those that it does cover. This book is the foundation. A future book will cover more advanced topics.

The important thing to remember about DML is that it manages data, not the structures that data is stored in. The Data Definition Language is concerned with the underlying structures.

Topics:

• Intro
• SQL
• DML
• DDL
• Data Types
• Expressions and Operators
• Common SQL Functions