**NOTE** All Online Course Tutorials require Internet Explorer 5.0 or higher and the Macromedia Flash 4.0 or higher plugin installed as they will not work with AOL, Netscape or Mozilla browsers.**

IBM 000-700 Online Course Tutorial Details

Total Lessons: 9
Total Time: 32 hour(s)
Subscription Term: 12 month(s)

Summary:

This series provides a practical approach to learning how to use DB2 Universal Database and helps prepare learners for the DB2 Certification Exam (Exam 700). Learners will explore how to use various applications to access DB2 data and how to use tools to administer the database.

Features and Benefits of our Tutorial:
* Exercises that allow users to practice the application
* A file containing the text of the exercises
* Activities that allow users to apply course concepts in an interactive questioning environment
* Simulations that allow users to practice course skills, even if they don't have access to the application
* A glossary
* A Skill Assessment

Lesson 1 Features of DB2 - 3 hours

Objectives: After completing this lesson, students will be able to:
* Distinguish between the many editions of DB2
* Describe various graphical tools to help you manage DB2 databases
* Use various applications to access DB2 data
* Describe how DB2 ensures data integrity

Lesson 2 Installing and Configuring DB2 - 2 hours

Objectives: After completing this lesson, students will be able to:
* Perform a typical, custom, or compact install
* Log on to the system
* Change passwords
* Start and stop DB2
* Grant privileges to other users

Lesson 3 DB2 Instances, Server Communications, and Clients - 5 hours

After completing this lesson, students will be able to:
* Create and set up instances
* Update protocol information
* Install a DB2 client on a Windows system
* Configure database connections for DB2 clients
* Create server profiles and client profiles

Lesson 4 Data Security and Database Creation - 3 hours

After completing this lesson, students will be able to:
* Use authentication types to determine where and how user identities are verified
* Modify the authentication level for an instance
* Grant database access authorities and privileges
* Decide what data to store in the database
* Define relationships between tables
* Identify constraints and foreign keys

Lesson 5 Creating Table Spaces and Accessing Data - 4 hours

After completing this lesson, students will be able to:
* Create table spaces using the Create Table Space Wizard
* Manage data across multiple table spaces
* Create buffer pools
* Access data through the control center, command center, and command line processor
* Access data through Microsoft Access, Java, and other applications

Lesson 6 SQL and Design Considerations - 4 hours

After completing this lesson, students will be able to:
* Use various SQL statements
* Include SQL statements in application programs
* Use constraints and triggers to implement restrictions
* Create user-defined-types to extend data types supported by the database
* Manage system resources to ensure optimal performance
* Manage the interaction of concurrent users

Lesson 7 System Tools and Recovery Concepts - 3 hours

After completing this lesson, students will be able to:
* Use the task center, the journal, the tools setting notebook, and the license center
* Configure logging for a DB2 database
* Set up a recurring schedule for backups
* Restore data in the event of a database failure

Lesson 8 Moving and Replicating Data - 3 hours

After completing this lesson, students will be able to:
* Use the export, import, and load utilities
* Use the Set Integrity Wizard
* Create a replication source and target table
* Create a subscription set
* Administer the capture and apply programs

Lesson 9 Monitoring DB2 Performance - 5 hours

After completing this lesson, students will be able to:
* Use the health monitor, database system monitor, and visual explain to determine database performance
* Improve database performance through configuration parameters and the configuration advisor
* Use the DB2 information center
* Use tracing facilities to understand how to troubleshoot DB2