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®.
The big picture: IBM DB2 Information Management Software and DB2 Universal Database If you are new to IBM DB2 information management software, this brief history of DB2 contains the information you need to get on board fast, including a historical perspective, technology overview, the role of DB2 software in e-business on demand, and many references to help you get started.
Colorful Introduction to DB2 UDB Are you a visual learner? This graphical introduction to DB2 will save you time in learning the main concepts of the DB2 environment.
Read these book excerpts for more in depth knowledge of functionality:
DB2 Universal Database V8 Administration Guide The Administration Guide in its three volumes provides information necessary to use and administer the DB2 relational database management system (RDBMS) products. The Planning volume offers information about database design. Three chapters in particular will help you get started:
Now that you're familiar with DB2, you are ready to put that knowledge to use. This series of six tutorials will provide you with the practical skills necessary to work with DB2 and are designed to help you prepare for certification on DB2 UDB Version 8 Family Fundamentals (Exam 700).
Part 1: DB2 Planning Part 1 covers DB2 basics with an introduction to data warehousing and OLAP.
Part 2: DB2 Security Part 2 covers DB2 authentication, authorization and privileges.
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.
An Introduction to DB2 UDB Express GUI tools This article introduces you to the GUI tools for DB2 UDB Express on DB2 UDB for Linux, UNIX, and Windows and describes how to use them for performing basic database operations, restricting access to objects, and setting up connectivity.
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 UDB Evaluation Guide for Linux and Windows You ask yourself, "So I have downloaded DB2 UDB Version 8 for Linux or Windows. What's next?" This IBM Redbook helps you journey through the experiences of discovering the new DB2 UDB V8.1. This journey introduces you to existing features and enhancements that make the DB2 family of products a superb choice for a relational database.
Online skills and technical information:
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.
