- Tel: +44 (0)1275 859666
DB07 - QMF / SQL Workshop - 3 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
- INTRODUCTION TO DB2
- The Relational Model
- Data Representation
- The DB2 Environment
- Data Definition Language
- The DB2 Table
- Column Types
- INTEGER
- SMALLINT
- CHAR
- VARCHAR
- DATE
- DATE formats
- TIME
- TIMESTAMP
- Null Values
- Default Values
- Indexes
- Index Columns
- Tablespace scan vs. Index access
- Data Representation
- DATA MANIPULATION LANGUAGE
- SQL - Structured Query Language
- DB2 Environments
- SQL Features
- SQL Query Results
- The SELECT Statement
- The 'As' Clause
- Column concatenation
- Expressions
- Functions
- Special Registers
- The WHERE Clause
- Special Operators
- NOT Operand
- IN Operand
- LIKE Operand
- BETWEEN Operand
- Statements Using Nulls
- Column Functions
- Using 'Distinct'
- The GROUP BY Clause
- The HAVING Clause
- The ORDER BY Clause
- Fetch First 'n' Rows Only Clause
- Special Registers
- Current Date
- Current Time
- Current Timestamp
- User Keyword
- The UPDATE Statement
- Update with Subselect
- The DELETE Statement
- The INSERT Statement
- The Mass Insert Statement
- Functions
- Scalar Functions
- Function Examples
- Date, Time and Timestamp Functions
- The Case Statement
- JOINS
- Cartesian Joins
- Inner Joins
- Outer Joins
- Nested Table Expression
- The UNION Statement
- Subqueries
- Subqueries Using in
- Exists
- The 'All' Subquery
- The 'Any' Or 'Some' Subquery
- DB2 Environments
- QMF
- QMF Home Panel
- The Retrieve Command
- QMF Storage Areas
- Saving an Object
- Retrieving an Object
- Export and Import
- Printing reports
- The Retrieve Command
- WRITING QUERIES
- Introduction
- Entering Queries
- The DRAW Command
- The EDIT Command
- QBE Commands
- Enlarge/Reduce
- Using Elements in QBE
- QBe Conditions Box
- Joining Tables in QBE
- Using Variables in SQL Or QBE
- The QMF Table Editor
- Entering Queries
- FORMATTING REPORTS
- The FORM.MAIN Panel
- The FORM.COLUMNS Panel
- The FORM.PAGE Panel
- The FORM.DETAIL Panel
- The FORM.FINAL Panel
- The FORM.BREAKn Panel
- The FORM.OPTIONS Panel
- The FORM.CONDITIONS Panel
- The FORM.CALC Panel
- The SHOW Command
- The FORM.COLUMNS Panel
- PROCEDURES
- Introduction to Procedures
- Creating a Procedure
- Variables in Procedures
- Creating a Procedure