◊ DB2 UNIVERSAL DATABASE ONLINE TRAINING SERIES
Online DB2 Universal Database Training
Database » Database
Only $99.95
DB2 Universal Database Series (32 hours)
ONLINE DB2 Universal Database TRAINING FEATURES
- Learn DB2 Universal Database online with these interactive online DB2 Universal Database courses.
- Affordable Pricing (Only $99.95 for the complete series)
- A full year to complete the DB2 Universal Database courses
- Retake the DB2 Universal Database courses as many times as you like
- Measure your progress with assessment tests after each course
- Earn completion certificates after passing each assessment test
1. Features of DB2
Time: 3 hours
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
- 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
2. Installing and Configuring DB2
Time: 2 hours
This course shows learners how to install and configure DB2, as well as how to decide which installation is right for their situation.
Objectives
- 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
3. DB2 Instances, Server Communications, and Clients
Time: 5 hours
This course shows learners how to view or change protocol information associated with DB2 server instances, and how to install DB2 clients.
Objectives
- 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
4. Data Security and Database Creation
Time: 3 hours
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
- 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
5. Creating Table Spaces and Accessing Data
Time: 4 hours
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
- 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
6. SQL and Design Considerations
Time: 4 hours
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
- 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
7. System Tools and Recovery Concepts
Time: 3 hours
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
- 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
8. Moving and Replicating Data
Time: 3 hours
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
- 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
9. Monitoring DB2 Performance
Time: 5 hours
This course shows learners how to use various tools to monitor and tune the performance of a database to get optimal performance.
Objectives
- 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
Resources for DB2 Universal Database
