October's top 10 Information Management articles, top 5 tutorials

In reverse chronological order by publication date, here are the Information Management articles and tutorials that developerWorks readers found most interesting.

1. DB2 9 certification: Everything you need to know

   Certification has arrived, no question. Howard Fosdick tells you the inside story on the secrets for doing it successfully, quickly, and inexpensively.

2. Build Web applications with Eclipse, WTP, and Derby

   Building dynamic Web applications is easy using Eclipse, the Web Tools Platform (WTP) for Eclipse, Derby, and Apache Tomcat. Install and configure all of the required open source components, and build a complete Web application using JSPs and servlets to store and retrieve information from a Derby database.

3. Understand the DB2 JDBC Universal Driver

   Discover the latest step in the evolution of Java® application development using IBM DB2® for Linux®, UNIX®, and Windows®. Get an inside view of the JDBC Universal Driver, and examine common debugging techniques that help you get to the heart of any problem.

4. DB2 Basics: Getting to know the DB2 command line processor

   Explore the three modes in which the command line processor operates, get a detailed explanation of the db2 command, and learn some usability enhancements that are sure to please command line users.

5. DB2 Universal Database commands by example

   Complementing the DB2 SQL Reference and Command Reference manuals, download "cheat sheets" that provide examples of commands going against the SAMPLE database (in either partitioned or non-partitioned mode).

6. DB2 Basics: Constraints

   Learn about the various types of constraints supported by DB2, and see examples of each constraint type. In addition, understand the fundamentals of constraints management (using either the command line or the DB2 Control Center).

7. DB2 Basics: Fun with dates and times

   Manipulate dates, times, and timestamps using SQL on DB2 for Linux, UNIX, and Windows platforms.

8. Parsing strings in SQL

   Parse data strings and discover some possibilities for the subsequent processing of the data.

9. DB2 Basics: Table spaces and buffer pools

   Understand the importance of table spaces and buffer pools, and see how properly designing and tuning them can enhance database performance.

10. An overview of DB2 and Java DataBase Connectivity (JDBC)

    Are you confused about JDBC support in DB2? This article pulls it all together and answers common questions, too.

Back to top

1. DB2 9 Fundamentals exam 730 prep, Part 4: Working with DB2 data

   Get acquainted with Structured Query Language (SQL), and understand the basics of how DB2 9 uses SQL to manipulate data in a relational database.

2. DB2 9 Fundamentals exam 730 prep, Part 3: Accessing DB2 data

   Gain an understanding of the objects that make up a DB2 database, and the different factors that 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.

3. DB2 9 Fundamentals exam 730 prep, Part 2: Security

   Get an introduction to DB2 security. Learn about DB2 authentication, authorization, and privileges.

4. DB2 9 Fundamentals exam 730 prep, Part 1: DB2 planning

   Learn the basics of the DB2 9 products and tools, along with concepts that describe different types of data applications, data warehousing, and OLAP. This is the first in a series of seven tutorials to help you prepare for the DB2 9 for Linux, UNIX, and Windows Fundamentals exam 730.

5. DB2 9 DBA certification exam 731 prep, Part 1: Server management

   Learn skills that help you to properly manage your DB2 database servers. This tutorial provides information about data consistency, transactions and how they are initiated and terminated, and the use of locks.

Back to top