Chapter 12. SQL Concepts

The language of relational database technology is the Structured Query Language (SQL). Invented by IBM in the 1970s, the SQL language continues to evolve and is the only way to access relational database data. The SQL language has three major components:

  • Data Maniupulation Language (DML)—. Used to select, insert, update, or delete database objects

  • Data Definition Language (DDL)—. Used to create, modify, or drop database objects

  • Data Control Language (DCL)—. Used to grant or revoke databases

Today you learn the following:

  • How to use the SELECT, UPDATE, INSERT, and DELETE statements

  • How to include SQL statements into application programs

  • The various programming interfaces supported by DB2

Data Manipulation Language

SQL allows users ...

Get Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial