Courses and publications are offered to help you prepare for the certification tests. The courses are recommended, but not required, before taking a certification test.
All Course Formats
This course provides you with information about the functions of IBM's DB2, a relational database manager which may be installed under a variety of operating systems on many hardware platforms.
DB2 9 runs under the z/OS, Linux, UNIX, and Windows operating systems, to name a few.
The course includes discussion of how the DB2 products provide services. The focus is on the services DB2 provides and how we work with DB2, not on its internal workings.
This basic course is for persons needing an introductory knowledge of DB2, and persons preparing for advanced and specialized DB2 education.
This course is the classroom delivered version of Instructor Led Online Course 3E120.
This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.
This is a basic course anyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).
Linux® is one of the fastest growing server operating platforms within the past few years. DB2® has long been known for its technology leadership. This IBM® Redbooks® publication is an informative guide that describes how to effectively integrate DB2 for Linux, UNIX®, and Windows® (LUW) with SUSE and Red Hat Linux operating systems. This book provides both introductory and detailed information about installing, configuring, managing, and monitoring DB2 in a Linux environment. We describe the DB2 product family and features for Linux, and we provide step-by-step instructions for a single as well as for a multiple partition DB2 system installation and configuration. We discuss how to migrate single and multiple partition DB2 to DB2 Version 9.5, and discuss, in detail, DB2 database administration in a Linux environment, procedures and tools for database backup and recovery, online maintenance, and system monitoring. We cover DB2 integrated tools and their features and use. We discuss aspects of DB2 application development in the Linux environment and provide general tips about building and running DB2 applications on Linux and the use of DB2 application development tools.
Data is one of the most valuable assets a company has. Relational and hierarchical databases have been used in the industry for decades. This book teaches you the fundamentals of databases, including relational database theory, logical and physical database design, and the SQL language. Advanced topics include using functions, stored procedures and XML.
This book provides information from the DB2® for Linux, UNIX, and Windows documentation to cover all the objectives that are described in the DB2 10.1 Fundamentals Exam 610.