Scheduled Dates (sort by: location | date) |
Request availability or book by selecting a date: Central London
City
Prices exclude VAT.
Have questions or need a better city/date? Ask now.
On-site/international quote? Ask now.
|
Course Overview Perform basic database administration tasks using IBM DB2 Universal Database. These tasks include creating and populating databases and implementing a logical design to support recovery requirements. If you are an experienced relational DBA in a database other than DB2 then this course will help you learn basic DB2 UDB database administration skills in a fast-path manner. This course is in effect a 2-day version of CF21 or CF23. Audience Experienced Database Administrators and technical personnel on other relational database platforms who are involved in planning, implementing, and maintaining DB2 databases. Skills Gained After completing this course, you should be able to: - List and describe the components of DB2 Universal Database
- Implement DB2? security
- Perform basic administration of a DB2 database system
- Perform the tasks necessary to support a basic recovery strategy
- Describe the application development process with respect to DB2 considerations
Prerequisites Before taking this course you should be able to: - Perform basic database administration tasks on a relational database system
- Use basic OS functions on Linux such as utilities, file permissions, hierarchical file system, commands, and editor
- State the functions of the Structured Query Language (SQL) and be able to construct DDL, DML, and authorisation statements
- Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
- These skills can be developed by taking
- OS Training
- DB2 SQL Workshop
- DB2 Universal Database Fundamentals
- DB2 Family Fundamentals (CF03U)
- DB2 SQL Workshop (CF12GB)
Course Outline Overview of DB2 Universal Database Getting Started with DB2 UDB GUIs Creating Databases and Tablespaces Create Objects Moving Data Recovery Monitoring/Problem Determination Concurrency Application Alternatives Application Performance Security This course is run on DB2 Version 9. Practical Work Practicals will be run on DB2 for Linux. Follow On Courses - Follow on courses of interest are CF461BGB, CF41U, and CF49N2GB.
- DB2 UDB Performance Tuning & Monitoring Workshop (CF41U)
- DB2 UDB Advanced Recovery for Single Partition Databases (CF49N2GB)
How to make a booking for the CF28N4GB course
|
