|
|
DB2 Universal Database
Join over 1 million people who learn
online, with these complete interactive computer training
courses.
|
See
How It Works
|
| This online course includes tutorials for: |
Time Needed |
| Features of DB2 |
3 hours |
| Installing and Configuring DB2 |
2 hours |
| DB2 Instances, Server Communications, and Clients |
5 hours |
| Data Security and Database Creation |
3 hours |
| Creating Table Spaces and Accessing Data |
4 hours |
| SQL and Design Considerations |
4 hours |
| System Tools and Recovery Concepts |
3 hours |
| Moving and Replicating Data |
3 hours |
| Monitoring DB2 Performance |
5 hours |
| Estimated time needed to complete entire
course |
32
hours |
|
Receive your login ID to take the training courses online,
as many times as you wish, for 1 year.
Click
here for group orders.
| Buy this entire
online training course with one easy payment of $67 |
|
OR
| Buy the Technical
Pack, and receive this course
plus many more, for only $197
|
 |
|
Benefits |
- Unlimited access for
1 year
- Learn anytime,
anywhere
- You control the pace
- Start & stop
wherever you want
- No books to read
- No software needed
- Value Packs include
Free online tech support
- Double
guarantee
|
- 100% Money back
guarantee
- One time payment No
monthly fee
- Use the course index
for review anytime
- Answer course
questions with at least 70% accuracy and print
your own certificates of
completion to prove that you have mastered each training course.
- Free status reports
for company managers
|
|
|
Requirements |
All you need is a PC with Windows,
the Microsoft Internet Explorer (browser)
and an Internet connection.
Note: The online computer training is designed to
work only with Internet Explorer. Prices shown are per
user. |
|
What
You will Learn |
|
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
|
|
Topic
Details |
- 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
- Perform
a typical, custom, or compact install
- Log
on to the system
- Change
passwords
- Start
and stop DB2
- Grant
privileges to other users
- 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
- 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
- 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
- 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
- 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
- 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
- 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
|
|
|
