Information Management Software

The following tutorials are self-paced, Web courses designed to help get you installing, configuring, building, testing, deploying and doing much more. As well, the skills roadmaps outline how you can leverage the curriculum materials to help enhance your skills.

SQL and XQuery Tutorial Series for IBM DB2

Tutorials:

		Series landing page
		Part 1: Introduction to Aroma and SQL
		Part 2: Basic queries
		Part 3: SQL joins and unions
		Part 4: Data analysis
		Part 5: Data comparison
		Part 6: Data Definition Language and Data Control Language
		Part 7: Introduction to XML and XQuery
		Appendix

DB2 9 Fundamentals certification preparation series (Exam 730)

Tutorials:

		Part 1: Planning
		Part 2: Security
		Part 3: Accessing DB2 data
		Part 4: Working with DB2 data
		Part 5: Working with DB2 objects
		Part 6: Data concurrency
		Part 7: Introducing Xquery

DB2 9 Database administration certification preparation series (Exam 731)

Tutorials:

		Part 1: Server managment
		Part 2: Data placement
		Part 3: Database access
		Part 4: Monitoring DB2 activity
		Part 5: DB2 utilities
		Part 6: High availability: Backup and recovery
		Part 7: High availability: Split mirroring and HADR

Application Development : DB2 9 Application Development Certification Preparation (Exam 733)

Tutorials:

		Part 1: Database objects and programming methods
		Part 2: DB2 data manipulation
		Part 3: XML data manipulation
		Part 4: Embedded SQL programming
		Part 5: CLI/ODBC programming
		Part 6: .NET programming
		Part 7: Java programming
		Part 8: Advanced programming
		Part 9: User-defined routines

Application Development: DB2 9 Application Development Tutorials

Tutorials:

		Part One
		Part Two

Introductory: DB2 UDB V8.1 Family Fundamentals

Tutorials:

		Part 1: DB2 tools, data warehousing and OLAP
		Part 2: Security and instances
		Part 3: Creating and accessing DB2 databases
		Part 4: SQL usage
		Part 5: Database objects
		Part 6: Database concurrency
		DB2 product manuals (enter your search criteria in the Search Support field and select the Learn box)

Database Administration: DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration

Tutorials:

		Part 1: Server Management: DB2 V8.1 Database Administration certification prep
		Part 2: Data Placement: DB2 V8.1 Database Administration certification prep
		Part 3: Database Access: DB2 V8.1 Database Administration certification prep
		Part 4: Monitoring DB2 Activity: DB2 V8.1 Database Administration certification prep
		Part 5: DB2 Utilities: DB2 V8.1 Database Administration certification prep
		Part 6: Backup and Recovery: DB2 V8.1 Database Administration certification prep
		DB2 UDB Administration Fastpath Course for V7 (voice enabled)
		DB2 UDB Administration Fastpath Course for V8 (voice enabled)

Roadmap:

		Database Administrator Skills Roadmap

DB2 product manuals:

		Administration Guide: Planning
		Administration Guide: Implementation
		Administration Guide: Performance

Application Development: Database Development DB2 V8 Application Development certification prep

Tutorials:

		Part 1: Database objects and programming methods
		Part 2: Data Manipulation
		Part 3: Embedded SQL programming
		Part 4: CLI/ODBC programming
		Part 5: Java programming
		Part 6: Advanced programming
		Part 7: User-defined routines
		DB2 UDB Programming Fastpath Course (voice enabled)

Roadmap:

		Database Developer Skills Roadmap

IBM Informix Dynamic Server 11 System Admin preparation series (Exam 918)

Tutorials:

		Series Landing Page
		Part 1: Installation and configuration
		Part 2: System activity monitoring
		Part 3: Troubleshooting
		Part 4: Performance tuning
		Part 5: Database server operations
		Part 6: Backup and restore
		Part 7: Informix Dynamic Server replication
		Part 8: SQL features for administrators

Using IBM Informix Dynamic Server on Microsoft Windows

Tutorials:

		Part 1: Install Informix Dynamic Server
		Part 2: Install Apache, PHP, and OpenAdmin
		Part 3: Create a simple SQL script and deploy as REST and SOAP Web service
		Part 4: Connect to Visual Studio

DB2 and IDS Games

Games:

		DB2 Detective
		DB2 Business
		IDS Detective