DB2 school training courses in Boston, MA (public, in-house or online)

Learn how to tune for optimum performance the IBM DB2 9 for Linux, UNIX, and Windows relational database management system and associated applications written for this environment. Learn about DB2 9 for Linux, UNIX, and Windows in a single partition database environment. Explore performance issues affecting the design of the database and applications using the database, the major database performance parameters, and the different tools that assist in performance monitoring and tuning.

Us...

Full archival course description>>

Discuss basic relational database concepts
Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
Create tables, views and indexes
Use referential integrity, check constraints and triggers
Use outer joins, and join tables to themselves
Use CASE expressions, and the CAST function
Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
Use complex subqueries
Use a greater number of scalar SQL functions
Use adv...

Full archival course description>>

Establish the environment to store native XML data in DB2 for z/OS
Create XML indexes for efficient retrieval of XML data
Analyze query executions and what you can do to improve the query performance
Validate and register XML schema using commands
Decompose XML documents using XMLTABLE function
Use IBM Data Studio for decomposition using XMLTABLE function, and register XML schema for validation

This DB2 training class uses a hands-on approach to teach application programmers and designers the essential concepts of DB2 SQL. Upon completion of this DB2 class, students will understand DB2 relational databases, be able to execute both simple and complex queries using DB2 SQL, and be able to create and manipulate table data.

Class Goals
•Understand the basic concepts and facilities of DB2
•Be able to create and execute simple SQL statements
•Be able to create the desired...

Full archival course description>>

Our trainers are industry and product experts that have mastered the use of each product in the field and enjoy teaching others how extract the maximum benefit from OEM product use at each students organization, big or small. Students learn from Industry experts with hands on product experience in multiple hardware and software environments and will benefit in the following ways.

Benefits of AMS Trainers
•The industries highest quality Computer Product Trainers for more than 4,000+ pro...

Full archival course description>>