Course Title: Enterprise Data Management – Introduction to DB2 for z/OS IICollin College - Continuing Education Course Syllabus Course Title: Enterprise Data Management – Introduction to DB2 for z/OS II Course Description: Introduction to Relational Database Management System (RDMS) – DB2 for z/OS applications development, database design, data concurrency, DB2 security, data or system recovery, and system performance challenges. Course Prerequisite(s): Enterprise Data Management – Introduction to DB2 for z/OS I Course Objectives: Understand applications development using DB2 for z/OS along with database design, basics of systems management and high level system/query performance. Textbook(s): None Reference Materials: DB2 9 for z/OS Technical Overview Bruni; ISBN: 0738489131 http://www.redbooks.ibm.com/abstracts/sg247330.html?Open DB2 9 for z/OS Performance Topics http://www.redbooks.ibm.com/abstracts/sg247473.html?Open DB2 V9R1 for z/OS IBM Online Software Product Bookshelf http://www-03.ibm.com/systems/z/os/zos/bkserv/zswpdf/#db2v91 Lesson Plan – by session Session 1: SQL Overview DB2 Application Interfaces Online Interface Lab Session 2: Database Design and Implementation Application Development Processes Session 3: Sample Applications Lab DB2 Data Control Session 4: DB2 Data Security and Recovery Data Security Lab Session 5: DB2 Subsystem Operation DB2 Utilities and Tools Session 6: Utilities Lab DB2 System Performance Session 7: DB2 Query Performance System z Processor Enhancements for DB2 Session 8: Overview of IBM and Industry DB2 CertificationsCareer Opportunities Review Wrap