DB2 System Fundamentals

 LENGTH OF COURSE:
5 Days

DESCRIPTION: This course provides a comprehensive overview of IBM’s relational database servers, known as DB2 Universal Database. The course concentrates on DB2 concepts and facilities. The course begins with DB2 Fundamentals and concludes with the DB2 Applications Development Process. This course can be customized to fit the requirements of your organization. From the most basic to advanced, Jeff Markiewicz & Associates can make this course a perfect fit for your organization.

PREREQUISITES: Some relational database experience is suggested but not required.

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

AUDIENCE

This course is designed for DB2 Programmers, Analysts and Administrators needing a comprehensive understanding of DB2 .
KEY HIGHLIGHTS:

  • DB2 Universal Database Product Overview
  • Editions
    • Personal Edition
    • Workgroup Edition
    • Enterprise Edition
    • Extended Edition
  • DB2 Connect
  • DB2 Developer’s Edition
  • Licensing
  • Features and Functions
    • Administrator’s Tools
    • Control Center
    • SmartGuides
    • Command Line Processor (CLP)
  • Product Installation
  • DB2 Environment Summary
  • DAS and DB2 Instances
  • Creating Databases
  • Controlling Data Access
    • Security
    • Establishing DB2 Connections
    • Configuring DB2 Clients


  • Using SQL
    • Database Objects
      • Data Types
      • DB2 Supplied Types
      • Using Data Definition Language
      • Using Data Manipulation Language
      • Removing Data
      • Business Rules
      • Advanced SQL
        • Recursive SQL
        • Outer Join
        • OLAP Features
        • Advanced Case Statements
  • Database Monitoring and Tuning
    • Monitoring Methods
    • Explain Facility
    • Database Monitoring
    • Performance Issues
    • DB2 Sorting Methods
    • Diagnostic and Problem Determinatior
    • Tuning Tips & Techniques


  • DB2 Application Programming
    • Application Development Environment
    • DB2 Programming Methods
      • Static SQL
      • Dynamic SQL
      • CLI
      • API
      • Accessing Data from an application
      • Embedded SQL
      • Interrupt Handling
      • Online Analytical Processing
  • DB2 Advanced Application Programming
    • Dynamic Programs
    • ODBC vs. CLI
    • Stored Procedures
    • User Defined Functions
    • Support for JAVA
    • Compound SQL

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