Overview
| Course code | T14D1 | Skill level | Intermediate |
|---|---|---|---|
| Duration | 4.0 days | Delivery type | Learning Collection |
| Course type | Public only | ||
| Public price | USD $190.00 plus tax | ||
Note: This course is a self-paced web-delivered class. The average time to complete the course is 30 hours. Once the ID and password are provided, you have 60 days to complete this course.
After you are enrolled in this course, you will not be able to cancel your enrollment.
This curriculum includes:
- IBM DB2 UDB Essentials Part 1 - Fundamentals of DB2 UDB Programming
- IBM DB2 UDB Essentials Part 2 - System and Database Administration
- IBM DB2 UDB Essentials Part 3 - SQL Fundamentals
- IBM DB2 UDB Essentials Part 4 - Advanced SQL
In Part 1 learn the fundamentals of IBM DB2. Get an introduction to the IBM DB2 UDB family and the key elements of database management services. Examine SQL comprehensively from the end user's perspective - write and run SQL and apply SQL to business intelligence. Then explore SQL and programming - the principal elements of SQL test environments, programming, compiling and execution.
In Part 2 focus on the roles and principal tasks of the system administrator and the database administrator in IBM DB2. Learn about administrative utilities and security. Get a comprehensive introduction to the areas of database modeling, database design, and distributed data processing, all of which are core concepts within IBM DB2 UDB.
In Part 3 get an introduction to the fundamental elements of SQL. Address simple query running before moving on to more complex procedures, such as retrieving data from multiple tables and creating single reports from multiple queries. Review scalar and column functions. Also, learn to run subqueries and maintain data. Learn to write basic Data Manipulation Language (DML) SQL statements and basic Data Definition Language (DDL) SQL statements.
In Part 4 learn how to make use of advanced SQL techniques to access DB2 databases in different environments. Examine creating SQL objects, CASE, CAST and summary tables, joins, subqueries, scalar functions, recursive SQL, User-defined Distinct Types (UDT) / User-Defined Functions (UDF), and general performance guidelines.
Audience
Part 1 and Part 2 are intermediate courses for individuals who need introductory knowledge of DB2 and for individuals preparing for advanced and specialized DB2 education.
Part 3 is an intermediate course for end users, programmers, application designers, database administrators, and system administrators who need to write, support, or understand SQL queries.
Part 4 is an intermediate course for experienced SQL end users, application programmers, database administrators, and user support staff members, who need more advanced knowledge of SQL. It is appropriate for individuals working in all DB2 environments, that is, OS/390, VM/VSE, AS/400, UNIX, Windows, and OS/2.
Prerequisites
For Part 3, you should have basic computer literacy and basic editing skills. Database skills are not required.
For Part 4, you should have experience with coding and executing basic SQL statements. You should complete:
- DB2 SQL Workshop (CF120)
- or equivalent experience
Ordering information
For information on how to order licenses for multiple users, please call 1-800-IBM-TEACH (1-800-426-8322).
| Order No. | Delivery Method | Price |
|---|---|---|
| T14D1 | Single Learner License | $190.00 |
| T14D2 | 5 User License | $645.00 |
| T14D3 | 10 User License | $1,215.00 |
| T14D4 | 25 User License | $2,930.00 |
| T14D5 | 50 User License | $5,840.00 |
Remarks
Special Note for IBM Business Partners authorized to remarket IBM IT Education Services public classes and on-site classes: This course is excluded from the IBM Technical Training Services for Public Education Program and the IBM Training Services for Enterprise - on-site Education Program for IBM Business Partners.
Machine requirements
Visit our Web site and search on T14D1 for requirements.
Workstation software:
Note: Apple and UNIX are not supported.
- Microsoft Windows 98 SE, NT 4.xx, ME, 2000, and XP (If using Windows XP, a Java Virtual Machine (JVM) may need to be installed)
Browser requirements:
- Microsoft Internet Explorer 5.0 with SP2 or higher (MSVM 5.0.0.3809 or higher or SUN JRE 1.3.1_02-1.3.1_04 or SUN JRE 1.4.0 or higher)
- Netscape Navigator 4.76 or higher (NN 6.x and SUN JRE 1.3.1 or higher; NN 7.x and SUN JRE 1.4 or higher)
- Browser must support cookies, Java, and JavaScript
Workstation hardware:
- Pentium-based computer or equivalent
- 16MB of RAM (32MB recommended)
- 800x600 resolution with 256 colors (1024x768 with 16 bit color recommended)
- Audio hardware is preferred but optional for couresware with audio
- 25 MB available hard drive disk space
My IBM
We're here to help
Easy ways to get the answers you need.
or call us at
Call 1-800-426-8322
Open M-F 9AM-7PM ET.
