Compiled for those less experienced with IBM® DB2®, this page is designed to help you get started. In just about two hours, these training materials will prepare you to take a series of self-study tutorials and to download and try IBM DB2 for Linux®, UNIX®, and Windows®.
Which distributed edition of DB2 9.5 is right for you? Learn the details on what makes each edition of DB2 9.5 for Linux, UNIX, and Windows unique. The author lays out the specifications for each edition, outlines licensing considerations, historical changes from DB2 9, and describes some interesting things customers are doing with each edition of DB2. This popular article has been rewritten for the DB2 9.5 release and is current as of the date of publication.
Compare the distributed DB2 9.5 data servers In a side-by-side comparison table, author Paul Zikopoulos makes it simple to understand the basic licensing rules, functions, and feature differences between the members of the distributed DB2 9.5 data server family.
Now that you're familiar with DB2, you are ready to put that knowledge to use. The
tutorial series below provides an introduction to SQL and covers how DB2 9 is packaged and installed, how to create databases and database objects, and the basics of database security and transaction isolation.
DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data
This tutorial gives you an introduction to the objects that make up a DB2 database, and the different factors which affect how the database is created. After a brief introduction to DB2 objects, learn about the tools available to create, access, and manipulate DB2 objects.
DB2 9 Fundamentals exam 730 prep, Part 5: Working with DB2 objects
This tutorial discusses data types, tables, views, and indexes as defined by DB2 9. It explains the features of these objects, how to create and manipulate them using Structured Query Language (SQL), and how they can be used in an application.
DB2 9 Fundamentals exam 730 prep, Part 6: Data concurrency
This tutorial introduces you to the concept of data consistency and to the various mechanisms that are used by DB2 9 to maintain database consistency in both single and multi-user environments.
DB2 basics article series These articles are geared toward beginning users. The DB2 basics series introduces fundamental topics and provides a walk through of situations often encountered by the first time user.
DB2's Command Line Processor and scripting This article shows you how to use the Command Line Processor (CLP) to your advantage. But, if your command of SQL is strong -- or you want to enter one quick command to verify the installation of DB2 -- the command line is ideal, and usually faster than submitting similar requests through a front-end. The CLP is a direct route to every DB2 programming interface.
Quick reference: Common DB2 Command Line Processor (CLP) Commands A crisis hits, you need to issue commands, and the syntax escapes your mind. This handy deskside reference, although not complete, can help you remember most of the commonly used commands, especially if you are new to DB2.
DB2 Detective Game A fun way to learn about IBM DB2! Learn or teach the basics of DB2 and relational database with an interactive game called The DB2 Detective Game. The game teaches relational database concepts and shows how technology can be applied to solving real-life problems (the game's theme is a crime investigation). This tutorial has been updated for DB2 9.
DB2 Business Game If you're a beginner with DB2 and SQL, you may wonder how the technical skills you're learning are used in the "real world." Here is a chance for you to put your DB2 SQL skills into play in this interactive game! Jump into a "run your own business" scenario, where your company's future depends on a key report needed to secure funds for a critical upgrade. Use your relational database skills to build this report.
SQL and XQuery tutorial for IBM DB2: SQL and XQuery tutorial series for IBM DB2 This tutorial series introduces readers to the Aroma database to apply Structured Query Language (SQL) and XML Query (XQuery) knowledge to solve typical business questions. Also included are detailed instructions for installing DB2 and the Aroma database. This tutorial series has seven parts.
Training and certification The home base for developing skills. Find out all you need to know about getting skilled and certified.
developerWorks DB2 Access our vast library of information on database, analysis, and enterprise content management, featuring white papers, tips, Q&A, Webcasts, and sample code.
IBM, DB2, and DB2 Universal Database are
trademarks of IBM Corporation in the United States,
other countries, or both. Linux is a trademark of Linus Torvalds in the United States, other countries, or both. UNIX is a registered trademark of The Open Group in the United States and other countries. Windows is a
trademark of Microsoft Corporation in the United States,
other countries, or both. Other company, product, or service names may be
trademarks or service marks of others.
