Hi ALL,
I am providing DB2 UDB DBA training , here is details, let me know , if any body interested.
Here is DB2 UDB DBA course info
1 RDBMS Concepts
Introduction to RDBMS
Codd Rules
Normalization
Data Model
2 DB2 UDB Concepts
About DB2 UDB
Components
DB2 UDB Architector
edition , tools
Process their roles
3 SQL (DML,DCL,DDL)
stored procedures, functions, DB triggers
Db2 development center
4. Installation & configuration( instance creation)
, about tool ( DB2CA)
System info, hardware over view
DB sizing ,design concepts
Bufferpools, Tablespaces , containers , pagesize,extent,prefetch
5 DB monitoring
Monitoring concepts
tools & utilities
DB2 health center
Snapshot
event monitor
3rd party tools like quest central
6 Backup & Recovery
HACMP, TSM concepts
7 Performance tuning
SYSTEM ( OS/Hardware)
DBM, DB parms
DB2set register variables
SQL tuning thoughts & techniques
8 Troubleshooting & user supporting
9 Over view of People soft 8.x on DB2 UDB
I will give clear notes & practice work for each part, other that that
placement assistant, supporting while you are in assignment ( rough & tuff issues)
Thank You