Instructor Led Db2 Udb Training

Data Warehousing DW Advanced SQL Queries and Performance ...DB2 UDB for z/ OS & OS/ 390, DB2 UDB for Linux/ UNIX/ Windows, Oracle and SQL Server. After briefly reviewing DW and BI terms and concepts, the lecturer will develop an understanding of how to use the statistics, analytic and OLAP features in a BI environment. The main features of this presentation are examples, intensive handson exercises, best practices and performance considerations.  more...

UDB DB2 SQL This course offers students a lecture/ lab intensive environment on DB2's Data Server Technology. The class covers the concepts of Basic SQL, Objects and Advanced SQL in a DB2 database and the use of the Gui interfaces for executing SQL. The student will learn how to write simple to complex queries along with being able to modify database objects through SPUFI, QMF or the Command Console. Advanced  more...

DB2 UDB for zOS Version Nine - Technical Introduction ...DB2 UDB for z/ OS Version Nine. Evaluate the usefulness of the new features and enhancements of DB2 UDB for z/ OS Version Nine. This course cover a Technical Introduction to the following NEW SQL Features of DB2 UDB for z/ OS Version Nine, including the following - pureXML, New Data Types (bigger BINARY, VARBINARY, BIGINT, DECFLOAT), INSTEAD OF triggers, INTERSECT and EXCEPT, TRUNCATE  more...