课件及试题研讨会武钢自动化.pdf

Course Description ◼ DB2 SQL Workshop ◼ Duration: 2 days ◼ Purpose: Introduction to SQL language. ◼ Contents: ◼ Structure and elements of SQL ◼ SQL queries ◼ Retrieving data from multiple tables ◼ Scalar functions and grou ◼ Combination of multiple result tables ◼ Using subqueries ◼ Maintaining data ©Copyright WISCO Automation Co. 2005. s . 2007/01 Course materials may not be reproduced in whole or in part without the prior written permission of WISCO Automation Co. 2 Agenda ◼ Day1 ◼ e ◼ Unit 1. Introduction ◼ Unit 2. SQL Queries ◼ Unit 3. Combination of Tables ◼ Unit 4. Arithmatic ◼ Day2 ◼ Unit 5. Column Functions and Grou ◼ Unit 6. Union ◼ Unit 7. Subselect ◼ Unit 8. Write Operations ©Copyright WISCO Automation Co. 2005. s . 2007/01 Course materials may not be reproduced in whole or in part without the prior written permission of WISCO Automation Co. 3 Unit 1. Introduction ◼ After completion this unit, you should be able to: ◼ Name the components of a relational database ◼ Define a ◼ Table ◼ Row ◼ Column ◼ View ◼ List the SQL statements in the following statement categories ◼ Data definition language ◼ Data manipulation language ◼ Control language ©Copyright WISCO Automation Co. 2005. s . 2007/01 Course materials may not be reproduced in