DB2 school training courses in Columbus, OH (public, in-house or online)

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>>

Welcome to Introducing IBM DB2 Concepts . This self-paced, e-learning program provides a general overview of DB2 concepts focusing on the database structure, security, and writing basic SQL queries to interact with DB2 data. You will examine how DB2 stores data in both single and multiple disk scenarios and explore different methods for adding data to a database. You will explore the logging and backup/recovery options DB2 provides to avoid data loss from such things as power failures.