DB2 Universal Database
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.
This series is for anyone interested in learning more about DB2 Universal Database. This online course contains 9 lessons and should take approximately 32 hours to complete.
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 and teaches you how 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, and describe how DB2 ensures data integrity.
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 and teaches you how to perform a typical, custom, or compact install, log on to the system, change passwords, start and stop DB2, and grant privileges to other users.
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 and teaches you how to create and set up instances, update protocol information, install a DB2 client on a Windows system, configure database connections for DB2 clients, and create server profiles and client profiles.
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 and teaches you how 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, and identify constraints and foreign keys.
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 and teaches you how 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, and access data through Microsoft Access, Java, and other applications.
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 and teaches you how 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, and manage the interaction of concurrent users.
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 and teaches you how 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, and restore data in the event of a database failure.
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 manipulating data and teaches you how to use the export, import, and load utilities, use the Set Integrity Wizard, create a replication source and target table, create a subscription set, and administer the capture and apply programs.
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 and teaches you how 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, and use tracing facilities to understand how to troubleshoot DB2.