Learn Online with StaffKit Training Courses
Online Employee Business and Computer Training

DB2 Universal Database Training


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

This DB2 Universal Database online training series provides over 32 hours of self-paced courseware. This web-based training provides 6 months of unlimited access to all of the following lessons:

1 . Creating Table Spaces and Accessing Data
2 . Data Security and Database Creation
3 . DB2 Instances, Server Communications, and Clients
4 . Features of DB2
5 . Installing and Configuring DB2
6 . Monitoring DB2 Performance
7 . Moving and Replicating Data
8 . SQL and Design Considerations
9 . System Tools and Recovery Concepts

Lesson Detail:

Creating Table Spaces and Accessing Data
This course shows learners how to create table spaces to store data and how to access data in DB2 databases. After taking this course, the learner will understand several methods of storing data.


  • Managing data in table spaces
  • Allocating additional space
  • Creating a buffer pool
  • Creating table spaces for indexes and large data
  • Creating tables in table spaces
  • Accessing data through DB2 tools
  • Accessing data through Microsoft Access
  • Accessing data through Java applications
  • Accessing data through your own applications

Data Security and Database Creation
This course shows learners how to control access to data and how to create a database. It also provides best practices for safeguarding data.


  • Types of authentication
  • Access to DB2
  • Access within DB2
  • Security for Windows
  • Deciding what to store in the database
  • Defining relationships, keys, and constraints for a table
  • Normalizing the table
  • Creating a simple database
  • Adding data to tables

DB2 Instances, Server Communications, and Clients
This course shows learners how to view or change protocol information associated with DB2 server instances, and how to install DB2 clients.


  • Working with DB2 instances
  • Modifying the DB2 communication configuration
  • Modifying configuration files
  • Adding systems through the Control Center
  • The DB2 administration server
  • The different types of DB2 clients
  • Performing a client install
  • Configuring database connections
  • Manually configuring and verifying a connection
  • Creating client profiles

Features of DB2
This course provides an overview of various DB2 products and the basic and major features of DB2. This course helps the learner decide which DB2 product fits a specific need.


  • Various editions of DB2
  • DB2 and its companion products
  • Managing databases with DB2
  • Accessing DB2 data from the Web
  • Major features of DB2
  • Data types and functions
  • Data integrity
  • Accessing, storing, and recovering data
  • Using application programs

Installing and Configuring DB2
This course shows learners how to install and configure DB2, as well as how to decide which installation is right for their situation.


  • Performing a typical install
  • Performing a custom install
  • Performing a compact install
  • Logging on to the system
  • Starting DB2 and using DB2 first steps
  • Granting privileges

Monitoring DB2 Performance
This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance.


  • The health monitor and database system monitor
  • The event monitor
  • Using visual explain
  • Collecting statistics and reorganizing tables
  • Controlling the DB2 environment
  • The configuration advisor
  • The design advisor
  • Input/output performance
  • The DB2 information center and error-logging facilities
  • Tracing facilities
  • The ODBC driver manager trace

Moving and Replicating Data
This course covers methods of moving data in and out of a DB2 database and propagating data from a source database to a target database through replication. After taking this course, learners will be better prepared to decide which utility to use when ma


  • Exporting data
  • Importing and loading data
  • Import options for various file formats
  • The Load Wizard
  • Replication concepts
  • Creating a replication environment
  • Monitoring the capture and apply programs

SQL and Design Considerations
This course explains how to use SQL, which is the language of relational databases, and what to consider when designing applications or databases. In the course, the learner will study the various SQL statements used to access data.


  • Data manipulation language
  • Column functions, scalar functions, and grouping
  • Set operators, predicates, and data manipulation
  • Using views
  • Invoking SQL statements
  • Constraints and user-defined types
  • Triggers
  • Routines and large object support
  • The development center
  • DB2 Net Search and spatial extenders
  • Managing System Resources
  • Concurrent users, indexes, and query applications

System Tools and Recovery Concepts
This course shows learners how to use several DB2 tools to administer databases and rebuild them through the process of recovery. This prepares learners to perform important system administration tasks.


  • The task center
  • Importing, running, and scheduling scripts
  • Using the journal and customizing tools settings
  • Creating indexes, viewing directories, and managing contacts
  • Managing the database log
  • Backing up databases
  • Recovering data

Certification:
DB2 Universal Database


Audience:
This series is for anyone interested in learning more about DB2 Universal Database.


Features:

  • Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.

Technical Requirements:


What You Get:

You will receive Unlimited Access to all of the DB2 Universal Database training tutorials listed above. Your online training courses will be available from anywhere you have internet access.This e-learning series includes all of the online training tutorials listed and is provided in an interactive, self-paced format. Retake any or all of our computer training as often as you want. Our online tutorials allow you to learn anywhere, anytime from any computer with internet access. All courses allow for 6 months of unlimited access (1 user), include a variety of features and qualify for Continuing Education Unit credit.


Web-Based Training Products:


DB2 Universal Database Online Training Series

Only $99.95    staffkit

You might also be interested in our Technical Package which includes all of the DB2 Universal Database training courses listed above plus hundreds of hours of related online training courses

 

Technical Package

Only $249.95   staffkit

DB2 Universal Database
Training Series
Total Courses: 9
Total Time: 32+ hours
$119.99
Only $99.95
Available in Package only
Total Courses: 853
Total Time: 1723+ hours
$499.99
Only $249.95
Satisfaction Guaranteed    BBB Online Accredited Business          Fruad Protection Guaranteed By American Express            Paypal World Seller

Reviews:

'offers employers an excellent way to train their staff economically and without having to send them out of the office.'
HRMReport.com

'this is a must have resource'
California Technology Magazine

'this is theUltimate
Career Development
Package.'
MidWest Technology Journal

Read more customer
reviews about our
e-learning training tutorials

StaffKit offers a centralized e-learning solution for business, computer, technical, compliance and employee training.
Copyright © 2001-2014 StaffKit All Rights Reserved