O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required