DB2 for Visual Studio Developers

 LENGTH OF COURSE:
4 Days

DESCRIPTION: This course is designed for Visual Studio and End Users that will be interacting with DB2. The course is designed for students that are familiar with the Visual Studio environment and need to obtain the skills necessary to interact with DB2. Performance, Coding Techniques and Practical Examples are the primary focus of this course.

PREREQUISITES: Knowledge of relational database concepts and Visual Studio Programming Concepts.

INSTRUCTION TECHNIQUES: A combination of Lecture, Exercises, and Labs (when/where available).

AUDIENCE

This course is designed for Developers, Programmers, Analyst, and Managers that need an understanding of the DB2/UDB environment and how to develop applications that effectively interact with the database
KEY HIGHLIGHTS:

  • DB2 Product Overview
    • DB2 and Data Objects
    • Tables, Table Spaces
    • Simple, Partitioned, and Segmented Table Spaces
    • Storage Groups, Databases
    • Indexes & Types
    • Systems Objects and DB2 Catalog
    • Stored Procedures, When, How and Why?
    • DB2 and Triggers
    • User Defined Functions Overview
    • Differences between DB2 for OS/390 and NT
  • Connecting to and Accessing Data from DB2
    • Connecting to the UDB Server
    • Accessing DB2 from Visual Studio
    • Visual Basic Connection Considerations
    • Programmer and End-User Access Considerations
    • Cross-Platform Library Management
    • DB2 ODBC Overview
    • JDBC & SQLJ Overview
    • ADO/DB2 Overview
  • DB2 Data Types
    • Character, Numeric, Large Objects
    • Data Type "Cross Walk" to Visual Basic


  • DB2 SQL DCL, DML and DDL Overview / Extensions
  • SQL Coding and Embedded SQL
    • Visual Development Techniques
    • What you can and can't do
    • Singleton vs. Cursor Processing
  • Program Structures for Visual Development
    • Program Structure
    • Host Variables and Structures
    • Host Variables with Visual Basic
    • Null Processing
    • Return Code Processing
  • Program Preparation Overview
  • Locking Concepts and Considerations
  • Programming Examples
  • Programming "Best Practices"
  • Security and Visual Studio Development
  • Dynamic SQL
  • Performance Considerations
    • DBAS Subcomponents
    • SQL Processing and Tuning
    • Stage 1 and 2 Predicates
    • SQL Coding Tips
    • Indexes and Filter Factors
    • Join Techniques and DB2 Optimizer
    • Sub-Queries and Types


  • EXPLAIN Facility
    • DB2 Optimizer Overview
    • Purpose and Practical Usage
    • Visual Explain
    • Explain Output
    • How helpful in the MS environment
  • Referential Integrity
  • More on DB2 ODBC
    • Writing a DB2 ODBC Application
    • Configuring DB2 ODBC
    • Functions
    • Advanced Features
    • Problem Diagnosis, Trace and Debug
    • DB2 ODBC and ODBC
    • SQLSTATE processing
    • Tips and Techniques
  • More on DB2 and ADO
    • ADO - ODBC
    • ADO and DB2 environment
    • ADO/ODBC Transaction - UOW
    • Tips and Techniques

Return to Home Page.
Return to Alphabetic Listing of Courses.
Return to Courses by Subject.
Request More Information or Contact Us.