SQL and XQuery tutorial for IBM DB2, Part 6: Data Definition Language and Data Control Language

Level: Introductory

Pat Moffatt (pmoffatt@ca.ibm.com), Information Management Program Manager, IBM Academic Initiative, IBM　
Bruce Creighton (bcreight@ca.ibm.com), Skills Segment Planner, IBM　
Jessica Cao , Training Tools Developer, IBM　

24 Aug 2006

	Register now or sign in using your IBM ID and password.

This tutorial, Part 6 of the SQL & XQuery tutorial for IBM DB2 series, expands on Data Manipulation Language (DML) and introduces Data Definition Language (DDL) and Data Control Language (DCL). It also discusses SQL statements other than SELECT.

Prerequisites

This tutorial was written for DB2 Express-C 9 for UNIX®, Linux®, and Windows® (formerly known as Viper). You should be familiar with DB2 and databases. It is preferable that you view the previous tutorials in this series before attempting this tutorial, part six.

System requirements

To use this tutorial to the fullest, you should have IBM DB2 9 installed. Download DB2 Express-C, a no-charge version of DB2 Express Edition for the community that offers the same core data features as DB2 Express Edtion and provides a solid base to build and deploy applications. You will also need to install the Aroma database, which can be downloaded in the tutorial.

Duration

Under 2 hours

Formats

About this tutorial

The previous parts of this series have all focused on the SELECT statement. This tutorial introduces the other SQL components and statements, including:

• CREATE TABLE
• INSERT
• UPDATE
• DELETE
• ALTER TABLE
• CREATE VIEW
• CREATE INDEX
• DROP TABLE
• GRANT
• REVOKE

Share this.... Digg this story del.icio.us Slashdot it!

Back to top