| Title | Advanced SQL Two-day |
| Length in days | 2 |
| Software Version(s) | DB2 z/OS v7 and v8,Oracle9i, 10g. 11g, SQL Server 2005, 2008, 2008 R2, MySQL 5 |
| Course Version | E0 |
| Last modified | 5/19/2010 |
| Available | Yes |
| Hardware requirements | One workstation per student plus instructor |
| Software requirements | Client tools for DB2 z/os or UDB, Oracle, SQL Server or MySQL |
| Prerequisites | Experience writing SQL queries in any relational DBMS |
| Equivalent courses | ? |
| Download outline | AdvancedSQL_TwoDay.pdf |
| Download instructor notes | ? |
| Download master | SQLAdv_2day_Master.pdf |
| Download setup file | AdvancedSQLSetupSQLServer2008.zip; 30 meg; Advanced SQL, for SQL Server 2008, detached database; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetupOracle.zip; 12 meg; Advanced SQL, for Oracle, 9.2+ exported database, IMPORTS ONLY TO 9.2 AND LATER!; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetupDB2zos.zip; 6 meg; Advanced SQL, for DB2 z/OS, creates, loads and data; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetupAccess.zip; 15 meg; Advanced SQL, for Access; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetupDB2udb.zip; 6 meg; Advanced SQL, for DB2 Universal Database, creates, loads, data; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetup_all_DBMSs.zip; 150 k; Advanced SQL, for all types of DBMSs - solutions, student survey, instructor notes; Send CD to client DBA 2 weeks before class |
| Download setup file | AdvancedSQLSetupSQLServer2005.zip; 22 meg; Advanced SQL, for SQL Server 2005, detached database; MUST use if client uses SQL Server 2005 |