- Tel: +44 (0)1275 859666
DB00 - Introduction to DB2 - 2 Days
Course Description
Customisation
For on-site courses (i.e. at your premises), we are more than happy to tailor the course agenda to suit your exact requirements. In many cases, we are able to build your in-house standards and naming conventions into the delivered course.
Course Details
- DB2 OBJECT DESIGN AND DEFINITION OVERVIEW
- The Relational Model / Data Modelling
- Data Representation
- Design Issues
- The DB2 Environment
- Data Definition Language
- The DB2 Table
- Table Characteristics
- Column Types
- INTEGER
- SMALLINT
- BIGINT
- DECIMAL
- CHAR
- VARCHAR
- DATE
- DATE formats
- TIME
- TIMESTAMP
- Null Values
- Default Values
- Indexes
- Index Columns
- Tablespace scan vs. Index access
- Data Representation
- DB2 INTERACTIVE (DB2I)
- DB2I Options
- SPUFI - SQL Processor Using File Input
- Running Queries
- SPUFI Defaults
- SPUFI - Setting Autocommit to NO
- DB2 Commands
- DB2 Utilities
- The DB2I Defaults Panel
- SPUFI - SQL Processor Using File Input
- DATA MANIPULATION LANGUAGE
- SQL - Structured Query Language
- DB2 Environments
- SQL Features
- SQL Query Results
- The Select Statement
- The 'As' Clause
- The Where Clause
- Special Operators
- Not Operand
- In Operand
- Like Operand
- Between Operand
- Statements Using Nulls
- Is Not Distinct From
- Column Functions
- Using 'Distinct'
- Multiple Distinct
- Group By Clause
- Expressions / Functions in Group By
- Having Clause
- Order By Clause
- Fetch First 'n' Rows Only Clause
- Special Registers (Date, Time, Timestamp And User)
- Current Date
- Current Time
- Current Timestamp
- User Keyword
- The Update Statement
- Update with Subselect
- The Delete Statement
- The Insert Statement
- The Mass Insert Statement
- Select from Insert
- Select from Insert Example
- Scalar Functions
- Function Examples
- Date, Time And Timestamp Functions
- The Case Statement
- Table Join
- Outer Joins
- Outer Join Syntax
- Joining More Than 2 Tables (using Newer Syntax)
- Outer Join - Where Clause
- Nested Table Expression
- SQL Union
- Subqueries
- Subqueries Using In
- Exists
- The 'All' Subquery
- The 'Any' Or 'Some' Subquery
- Common Table Expressions (V8)
- Common Table Expression Example
- Recursive SQL (V8)
- Recursive SQL Example
- Recursive SQL - Controlling Depth of Recursion
- DB2 Environments
- APPLICATION PROGRAMMING OVERVIEW
- DB2 Environments
- Development Cycle With DB2
- SQL Statement Format
- Cursor Operations
- SQL Statements Used in Application Programs
- SQL Error Codes
- Batch Execution
- Plans & Packages
- Development Cycle With DB2