Microsoft training courses, Cisco training courses, Prince2 training courses, ISEB training courses with locations nationwide
Call now to speak to an experienced Training Advisor
 
     
 
Home
  
How it works
  
About the quality of your course
 
Managed services
  
Partner CourseMonster
  
 
 
Thousands of Microsoft, ISEB, ITIL, Cisco and Prince2 Training Courses and more
  
 
Browse IBM Training Courses

DB2 Fastpath to DB2 UDB for Experienced DBAs

Course Code: CF28N4GB (Also known as: CF28N4GBGB)      Days: 2
Show all IBM Courses
Call for Latest Dates
Call us on 0870 7777 388 for availability on this course.
Have questions or need a better city/date? 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
    		 
      CourseMonster books thousands of public training courses, classes and boot camps both in London and throughout the UK including: Berkshire, Birmingham, Bristol, Bournemouth, Bucks, Cambridge, Derby, Devon, Edinburgh, Glasgow, Hampshire, Ipswich, Leeds, Leicester, Luton, Manchester, Middlesex, Milton Keynes, Norfolk, Nottingham, Reading, Surrey, Sussex, Tyne and Wear, Midlands and Yorkshire. Topics range from software to administration and development.  
         
    CourseMonster® Patent Pending © SeaKom, All Rights Reserved - Channel partners with Business Training Partnership