|
Provided by: Affinity IT Training, LLC Introduction to IBM DB2 Universal Database for Sybase Developers |
 |
Training
Provided by Affinity IT Training, LLC
Provides the student that has prior SQL or Sybase ASE experience
with the necessary basic skills
and fundamental knowledge of IBM DB2 UDB.
It includes information on the overall architecture of DB2 UDB,
basic to advanced DB2 UDB SQL syntax,
creating and using SQL Stored Procedures,
and an overview of basic administrative tasks
including creation of databases, tables, views, indexes,
the extraction and insertion of data, security,
and backup and restore.
Audience:Application developers already familiar with Structured Query Language (SQL) and other Relational Database Management products.
|
|
||||||||||
Introduction to IBM DB2 Universal Database for Sybase Developers
Objectives
- Be familiar with the evolution and architecture of DB2 UDB
- Understand basic and advanced DML and DDL syntax
- Be familiar with UDB Data Structures, Transactions, and Locking
- Understand UDB Functions
- Understand the syntax and use of Stored Procedures and Triggers
- Understand the syntax and use of Constraints, Indexes, and Views
- Be familiar with basic Administrative tasks
Outline
Overview of DB2 UDB
DB2 UDB Product Family
The DB2 UDB Environment
DB2 Programming Interfaces
The DB2 CLI
Terminology
The DB2 UDB Architecture
DB2 SQL PL
DB2 Resources
DB2 UDB Tools
Control Center
Managing Communications with Control Center
Managing Databases
Creating Databases and Objects
Command Editor
Connecting to a Database
Executing DB2 Commands
Executing SQL Commands
Using the Query History
Working With Scripts
Saving and Loading Script Files
Building Queries
Setting Command Editor Options
Setting General Tool Options
Command Line Processor
Using The CLP in Command Mode
CLP Options
Using The CLP Interactively
CLP Command History
Editing Queries in the CLP
Customizing the CLP Command Prompt
Getting CLP Help
Using Script Files with CLP
CLP Return Codes
Development Center
Development Center - Create Object
Importing Stored Procedures
Editing Stored Procedures
Building Stored Procedures
Debugging Stored Procedures
The Debugger Window
Specifying Run Settings
Lab 2.1 - DB2 UDB Tools
Introduction to DB2 UDB SQL
Reading Syntax Diagrams
SAMPLE Database Schema
SELECT Statement
SELECT Clause
SELECT Statement Examples
Correlation Names
Renaming Result Columns
FETCH FIRST Clause
FETCH FIRST Examples
Common Table Expressions
Common Table Expressions Examples
Derived Tables
The VALUES Clause
The VALUES Clause Examples
Operators
The LIKE Predicate
Precedence Rules - Arithmetic
Precedence Rules - AND vs. OR
ORDER BY
Joins
Setup
- UDB v8.1 Download
Seminar Pre-Requisites
- Familiarity with SQL and Relational technology (preferred)
Training Materials
- Course Workbook
Jan06
About The Training Provider: Affinity IT Training, LLC
Affinity IT Training, LLC - .
We are a provider of hands-on, instructor-led IT training for the global business community including website development, databases, programming languages and more. Training includes: ASP, .NET, C#, C , DB2, AJAX, JavaScript, HTML/XHTML/XML, Unix, Linux, Perl, Python, Ruby On Rails, Oracle, Sybase, SQL Server, Project Management Training and customized Integrated Case Study.
