Skip to main content

Skip over site navigation to main content

developerWorks  >   Information Management  >   Technical library  >  

Technical library view  RSS for Information Management

 developerWorks
 Related links:    Redbooks  |  Forums  |  Support knowledge base

Filter your search and/or enter a keyword. If you don't filter your search or enter a keyword, the search results will default to all results.
 
 
 
 
  1 - 9 of 9 results    Hide Summaries
Title   Type   Date  

Table that contains the results that meet the search criteria.

SQL and XQuery tutorial for IBM DB2: SQL and XQuery tutorial series for IBM DB2
This tutorial series introduces readers to the Aroma database to apply Structured Query Language (SQL) and XML Query (XQuery) knowledge to solve typical business questions. Also included are detailed instructions for installing DB2 and the Aroma database. 		Articles 31 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 1: Introduction to Aroma and SQL
This tutorial introduces readers to the Aroma database to apply Structured Query Language (SQL) and XML Query (XQuery) knowledge to solve typical business questions. Also included are detailed instructions for installing DB2 and the Aroma database. This tutorial is Part 1 of the SQL & XQuery Tutorial for IBM DB2 series. 		Tutorials 03 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 7: Introduction to XML and XQuery
This tutorial introduces pureXML and XQuery, starting from a basic overview of the characteristics and advantages of the XML data type, and then compares it with standard relational tables. Users are then asked to write XQueries to retrieve XML elements, filter data based on XML values, transform XML output, and use various clauses to select data more precisely. The tutorial ends with a section on mixing XQuery and SQL. This tutorial is Part 7 of the SQL & XQuery tutorial for IBM DB2 series. (Note: You must have DB2 9 installed to do the hands-on exercises in this tutorial.) 		Tutorials 31 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 6: Data Definition Language and Data Control Language
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. 		Tutorials 24 Aug 2006  
 
SQL & XQuery tutorial for IBM DB2, Part 5: Data comparison
This tutorial describes queries that compare data in an IBM DB2 database. This is accomplished by using either CASE expressions or subqueries. This tutorial is Part 5 of the SQL and XQuery tutorial for IBM DB2 series. 		Tutorials 24 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 4: Data analysis
This tutorial describes how to write queries that require basic data analysis. Many of the queries contain sequential calculations, or calculations that operate on an ordered set of rows--queries frequently encountered during business analysis. On-Line Analytical Processing (OLAP) functions provide the ability to return ranking, row numbering and existing column function information as a scalar value in a query result. This tutorial is Part 4 of the SQL and XQuery tutorial for IBM DB2 series. 		Tutorials 17 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 3: SQL joins and unions
This tutorial describes two ways to combine data from different tables in an IBM DB2 database: by joining the tables with inner or outer joins and by using the UNION, EXCEPT, and INTERSECT operators, which take the intermediate result set from one query expression and combine it with the result set from another query expression. This tutorial is Part 3 of the SQL & XQuery tutorial for IBM DB2 series. 		Tutorials 10 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, Part 2: Basic queries
Through a series of simple examples, this tutorial illustrates how to retrieve data from an IBM DB2 database with standard SQL SELECT statements. This tutorial describes how to retrieve rows from a relational database table, retrieve specific columns, retrieve specific rows, reform logical operations on retrieved data, and use wildcard characters in search conditions. This tutorial is Part 2 of the SQL & XQuery tutorial for IBM DB2 series. 		Tutorials 03 Aug 2006  
 
SQL and XQuery tutorial for IBM DB2, appendix: Appendix A
Appendix A describes all of the tables in the Aroma database, which consists of two schemas: a simple star schema for retail sales information and a multistar schema for purchasing information. 		Articles 31 Aug 2006  
 
  1 - 9 of 9 results    Hide Summaries
Not finding what you're looking for? Suggest Content