《Part_VI》.pdfVIP

SQL and XQuery tutorial for IBM DB2, Part 6: Data Definition Language and Data Control Language Overview of the DML, DDL, and DCL components of SQL Skill Level: Introductory Pat Moffatt (pmoffatt@) Information Management Program Manager, IBM Academic Initiative IBM Bruce Creighton (bcreight@) Skills Segment Planner IBM Jessica Cao Training Tools Developer IBM 24 Aug 2006 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. Section 1. Before you start About this series This tutorial series teaches basic to advanced SQL and XQuery topics. Developers and database administrators can use this tutorial to enhance their database query skills. Academic Initiative members can use this tutorial series as a part of their Data Definition Language and Data Control Language Trademarks © Copyright IBM Corporation 2006. All rights reserved. Page 1 of 26 developerWorks® /developerWorks database curriculum. This tutorial series shows how to express commonly asked business questions as database queries by using SQL queries or XQueries. All the examples in this document are based on Aroma, a sample database that contains sales data for coffee and tea products sold in stores across the United States. Each example consists of three parts: • A business question, expressed in everyday language • One or more example queries, expressed in SQL or XQuery • A table of results returned from the database This guide is designed to al