Db2 Udb Fundamentals

DB2 UDB Fundamentals Duration: 1 or 2 days Participants: Managers, applications developers, IT personnel, and technical users who need an understanding of DB2 UDB applications and systems. Objectives: Upon successful completion of this course you will be able to: - Describe the relational data model and explain how DB2 implements this model. - Explain the advantages and limitations of DB2, UDB (Universal Data Base), SQL (Structured Query Language), and QMF (Query Management Facility). - Describe the major steps involved in designing, implementing, and maintaining DB2 applications. - Understand the trade-offs involved in maintaining data integrity and security while optimizing performance in a DB2 UDB environment. - Identify applications development, end-user, and database administration tools available for DB2 UDB environments. Overview: This stand-alone course focuses on the features, capabilities, and environmental requirements of DB2 UDB. We recommend including hands-on workshops to enhance understanding of principles presented in the lecture. The focus is on OS/390 DB2 UDB. Prerequisites: An understanding of data processing and database fundamentals is helpful but not required. Format: Lecture and discussion with optional hands-on exercises. Topic Outline: - The Relational Model DB2 Defined Relational Concepts Table Relationships Referential Integrity Relational Manipulation Relational vs. Hierarchical Relational Design Exercise - SQL Data Manipulation Structured Query Language Data Manipulation Language Retrieving the Whole Table Specifying the Columns You Need Specifying the Rows You Need Search conditions - AND, OR Specifying Output Sequence - ORDER BY Built-in Column Functions Summarizing Groups of Rows - GROUP BY

Deleting Data Changing Data Adding New Data Join Data from Multiple Tables - Interactive SQL, SPUFI, and QMF Invoking SPUFI SPUFI QMF QMF Environment QMF Queries QMF structure Accessing QMF Query Report Using Default Form FORM.MAIN PANEL Edit Codes USAGE Codes BREAKn Text Final Text BREAKn and Final Report - DB2 Architecture Data Definition Language (DDL) DB2 Objects Stogroup Database Tablespace Table Table Row DB2 Data Types Object-Relational Extensions Large Objects (LOB) User-Defined Data Types Creating User-Defined Functions Index Building the Physical Environment - Basic Example View CREATE VIEW Example Synonym Trigger Support for Active Data Catalog - Embedding SQL in Applications Programs Supported Languages Overview Two Types of Embedded SQL Singleton SELECT and Example SQLCODE DB2 Application Programming Exercise CURSOR and Example Summary

- Program Preparation and Execution Program Preparation Program Flow Precompile Precompile Process Bind Bind Process Preparing the Program DB2I Overview Timestamp Considerations Common Reasons for -818 Summary of Prep Steps - UDB and Network Computing DB2 Version 5 Network Computing Support DRDA and DB2 Private Protocol DB2 Version 6 DRDA Three-Part Table Name ODBC/Call Level Interface ODBC/CLI Programming Handle Allocation and Connection Example Statement Preparation and Execution Example Version 6 ODBC/CLI Enhancements Stored Procedures Create Procedure CALL Statement Version 6 Stored Procedure Enhancements DB2 Version 5 Web Support DB2 Version 6 Web Support - DB2 Security DB2 Authorization Mechanism Resources Users and Authorization IDs Privileges Administrative Authorities Grant Examples Revoke Examples - Database and Systems Administration DB2 Product Family Systems Application Architecture System Environment DB2 Architecture Utilities Logging and Recovery Monitoring Performance Optimization Database Products DB2 Commands