Available for Download

Currently Available

The following is available for download in Adobe PDF format:

• SQL Self-Test (300 KB) • Test your aptitude in SQL and see whether you meet the prerequisites for the Advanced SQL for DB2 UDB for Linux, UNIX, Windows class. (See What We Offer for more information on our courses and other offerings.)

• The SQL Series of Courses Installation Guide (179 KB) The files referred to may all be found below.

• Advanced SQL Workshop 3 Extra Credit (170 KB) • Extra workshop problems (and solutions) for Advanced SQL for DB2 UDB for Linux, UNIX, Windows chapter 3

The following are available for download in text or PDF format:

• Files for workshops on the distributed (Linux, UNIX, Windows) platforms:

• DDL to create the sample tables • Coming soon!
• Constrnt.txt (2KB) • DDL to add data integrity constraints to the sample tables
• InsMyRow.txt (1 KB) • DDL to add your own row to the Employee table
• AllEmps.txt (1 KB) • DDL to create the AllEmps view
• TempTabl.txt (1 KB) • DDL to create the Temp table
• Student.zip (1 KB) • Batch file to copy the above four text files to C:\CejCo on the student workstation



• Files for workshops on the mainframe (z/OS, OS/390, MVS) platforms:

• Cre8DB.txt (17 KB) • DDL to create a workshop storage group and database
• Cre8TB.txt (55 KB) • DDL to create the sample tables
• Cre8IX.txt (41 KB) • DDL to create indices on the sample tables
• LoadTB.zip (28 KB) • DDL to populate the sample tables via INSERT statements
• Constr.txt (5 KB) • DDL to add data integrity constraints to the sample tables
• TempTB (5 KB) • DDL to create the TEMP table
• DropDB (3 KB) • DDL to drop the workshop database and storage group

What Would You Like?

what else you would like us to make available for download.

Last updated: Tuesday, October 16, 2007