computer training image
Online Training Classes Purchased Securely
Shopping cart  Shopping cart
0 Product(s) in cart
Total $0.00
> Checkout
Online Payments

Benefits of Computer Coach's online computer training classes

  • Accessible 24 hours a day 7 days a week, so you can learn when you have time.
  • Cost-effective solutions, so you don’t go broke learning the skills you need.
  • Available Anytime, anywhere with an Internet connection, so you can study at your house, office, or where you feel comfortable.
  • Interactive & fun courses allow for greater retention of course topics.
  • Easy to use so you can start learning right away.
  • Full of hands-on labs so you can get the practice you need
  • HTML Based so you don’t need any additional downloads
  • Live Mentor Available to ask questions and get clarification

online computer training questions answered

DB2 Universal Database Online Course

12 Month Subscription - $70
Live Mentor +$30

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.

Certification:
DB2 Certification Exam 700

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

Features:
●  Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
●  Activities allow learners to apply course concepts in an interactive questioning environment.
●  Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
●  Exercises allow learners to practice in the actual application being studied.
●  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.
●  A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
●  Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
●  Search text enables learners to rapidly search all text within a course to easily retrieve information required.

Topics included in this course:
DB2 Universal Database : Features of DB2
DB2 Universal Database : Installing and Configuring DB2
DB2 Universal Database : DB2 Instances, Server Communications, and Clients
DB2 Universal Database : Data Security and Database Creation
DB2 Universal Database : Creating Table Spaces and Accessing Data
DB2 Universal Database : SQL and Design Considerations
DB2 Universal Database : System Tools and Recovery Concepts
DB2 Universal Database : Moving and Replicating Data
DB2 Universal Database : Monitoring DB2 Performance

DB2 Universal Database : Features of DB2
Summary:
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.

Objectives:
After completing this course, 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

Topics:
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
top

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

Objectives:
After completing this course, 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

Topics:
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
top

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

Objectives:
After completing this course, 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

Topics:
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
top

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

Objectives:
After completing this course, 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

Topics:
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
top

DB2 Universal Database : Creating Table Spaces and Accessing Data
Summary:
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.

Objectives:
After completing this course, 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

Topics:
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
top

DB2 Universal Database : SQL and Design Considerations
Summary:
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.

Objectives:
After completing this course, 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

Topics:
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
top

DB2 Universal Database : System Tools and Recovery Concepts
Summary:
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.

Objectives:
After completing this course, 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

Topics:
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
top

DB2 Universal Database : Moving and Replicating Data
Summary:
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 manipulating data.

Objectives:
After completing this course, 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

Topics:
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.
top

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

Objectives:
After completing this course, 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

Topics:
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
top

12 Month Subscription - $70
Live Mentor +$30