Canada IT Courses
ExitCertified US




ExitCertified - Excellence in IT Certified Education
 
IT education classes
IT training feature sheet
 
   
 
start > courses and registration > training feature sheet
DB2 Database Administration Workshop for Windows
 
 
 
 
ibm certified training   this course works with savings passes
 
code. CF232   length. 4 days
type. Instructor-Led   partner. IBM
price.
$2,500  
 
 
Learn how to perform database administration tasks such as creating DB2 instances, creating and populating databases, and using logical design to support concurrency and recovery requirements with DB2 9 for Linux, UNIX, and Windows. Use a Windows operating system during hands-on labs.
 
course schedule  
 
There are currently no scheduled dates for this course. If you are interested in this course, request a course date with the links below.
   
Request course date Request on site training
 
who can benefit
  
 
This is an intermediate course for database administrators and other technical individuals, who plan, implement, and maintain DB2 for Linux, UNIX, and Windows databases.
 
prerequisites
  
 
You should complete/be able to:

AIX 5L Basics (Q1313) or have equivalent experience of AIX functions
DB2 SQL Workshop (CF120) or have equivalent knowledge of SQL basics
Use basic UNIX functions, such as utilities, file permissions, hierarchical file system, command, and the visual editor (vi) editor
Describe the functions of SQL and construct Data Definition Language (DDL) and Data Manipulation Language (DML) authorization statements
Discuss basic relational database concepts and objects such as tables, indexes, views, and joins
OR have equivalent eperience
 
skills gained
  
 

List and describe the components of DB2
Implement DB2 security
Perform basic administration of a DB2 database system
Define a basic DB2 recovery strategy and perform the tasks necessary to support the strategy
Describe the application development process with respect to DB2 considerations


 
course materials
  
 
The course materials address DB2 9 for Linux, UNIX, and Windows.
 
hands-on labs
  
 
Nine labs are included to address DB2 9 for Linux, UNIX, and Windows.
 
certification
  
 
Prepare for IBM Certification Test 731: DB2 9 for Linux, UNIX, and Windows Database Administration



 
ibm education advantage program eligibility:
  
 

Yes - IBM Education Pack - online account
Yes - IBM Education Card
Yes - IBM Corporate Education Pass




 
course content details  
 


  Overview of DB2

list the DB2 family of products
identify the DB2 products
describe the functions of DB2 components
compare DB2 packaging options and product requirements
list DB2 supported configurations




  Getting started with DB2 Graphical User Interface (GUI)

list the GUI tools in DB2
explore the various ways to access the GUI tools
use different methods to execute a command or statement in DB2




  Creating databases and data placement

create DB2 databases
identify default objects that are created when a database is created
identify how table spaces may be defined to store different types of data
describe the two types of table space management
identify when each type of table space management should be used
create System Managed Storage (SMS) table spaces
create Database Managed Storage (DMS) table spaces




  Create objects

describe DB2 object hierarchy
create database objects: tables, indexes, views, aliases, schemas
alter tables and add check constraints, triggers, and referential integrity
describe Large Objects (LOB)




  Moving data

describe and use the export and import utilities
describe and use the load utility
describe the functionality of the DB2 replication component




  Recovery

state the three types of recovery support
explain the principles DB2 uses for its recovery/restart functions
describe the capabilities and functional requirements of DB2 logging
use the utilities to back up and recover user data and DB2's catalog
recover data to a prior point in time
state general considerations regarding disaster recovery
prepare and implement standard recovery procedures for data recovery




  Monitoring and problem determination

use error logs
identify the different monitor types
identify how to obtain a db2trc
describe the function of EXPLAIN and use this facility to assist basic analysis
identify additional commands for listing application information




  Concurrency

list objects that may be locked by the database manager
discuss available lock modes and their compatibility
influence locking strategies used by the database manager




  Application alternatives

prepare applications that access DB2 data for execution
use PRECOMPILE and BIND options that are appropriate for specific application requirements
describe the application alternatives available to access DB2 data or request other DB2 functions
list the benefits, and possible disadvantages, of the various interfaces


  Application performance

list reasons for REBIND of application programs and execute this command
define the concept of single dimensional clustering, and determine the proper cluster sequence, if any, for DB2 tables
use RUNSTATS, REORGCHK, and REORG to enhance application performance
identify configuration parameters that impact performance of applications




  Security

use DB2 access control mechanisms to implement security within the database
use group IDs to create a control hierarchy
describe privileges within a database
describe privileges required for binding and executing a package
describe the difference between explicit privileges and implicit privileges
describe the different DB2 authorization levels




  Daily Agenda: Day 1

Welcome
Overview of DB2 Database
Getting Started with DB2 GUIs
Lab (DB2 customization)
Creating Databases and Data Placement
Lab (Creating databases/tablespaces)




  Day 2

Lab (Creating databases/tablespaces) (Continued)
Create objects
Lab (Create objects)
Moving data
Lab (Moving data)




  Day 3

Lab (Moving data) (Continued)
Recovery
Lab (Recovery)
Monitoring and problem determination
Concurrency
Lab (Investigating DB2 locking)
Application alternatives




  Day 4

Lab (Preparing applications for execution)
Application performance
Lab (Application performance tools)
Security
Lab (Securing the DB2 environment)



 
Free $100 Best Buy Gift Certificate

Save on IBM Training



find a course
 
phone us
 
view course schedule





Free $100 Best Buy Gift Certificate

 
go to top
Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education Sun Microsystems, Veritas, Oracle, Symantec, and Project Management IT Education
© 2008 ExitCertified. All rights reserved.
terms of use and disclaimer :: privacy policy :: webmaster :: link to us
   
Sacramento Training :: 916.669.3970 | Las Vegas Training :: 1.800.803.EXIT (3948) | San Francisco Training :: 415.975.3948 | San Jose Training :: 408.288.EXIT (3948)
Phoenix, Arizona Training | Los Angeles, California Training | San Diego, California Training | Broomfield, Colorado Training | Fort Lauderdale, Florida Training
Tampa, Florida Training | Atlanta, Georgia | Downers Grove, Illinois | Kansas City, Kansas Training | Portland, Maine Training | Baltimore, Maryland Training | Burlington, Massachusetts Training
Troy, Detroit, Michigan Training | Minneapolis, Minesota Training | St. Louis, Missouri Training | Omaha, Nebraska Training | Edison, New Jersey Training | New York City, New York Training
Raleigh, North Carolina Training | Columbus, Ohio Training | Philadelphia, Pennsylvania Training | Nashville, Tennessee Training | Dallas, Texas Training
Houston, Texas Training | Hampton, Virginia Training | Madison, Wisconsin Training | Seattle, Washington Training

ExitCertified is a global provider of authorized technology training. Some of our popular course topic searches include:

Java Training | J2EE Training | JSP Training | Java Courses | Servlets Training | EJB Training | Struts Training | Networking Courses | Solaris Training
Red Hat Training | SUSE Training | XML Training | Oracle SQL | Oracle PL/SQL | DBA Training | DBA Certification | Oracle Certification
RedHat Training | Solaris Certification | Java Certification | Veritas Certification | PeopleSoft Training | 11g Training | 11g Certification
RedHat Courses | SQL Training | 10g Training | 9i Training | Application Development Training | Certified Training | Corporate Training
Government Training | Course Catalogue | Training Schedule | Certification Training | Project Management Training | Linux Training
Solaris 10 Training | Unix Training | NetBackup Training | Virus Protection Courses | Education Technology Newsletter | zSeries Training
s/390 Training | iSeries Training | DB2 Training | OS/400 Training | AIX Training | Rational Courses | PMI Training | Project Management Training
SeeBeyond Training | Java Composite Application Platform (JCAPS) Training | MySQL Training | MySQL Database Course | Hyperion Training | Fusion Middleware