|
Provided by: Serebra Learning Corporation IBM DB2 UDB Essentials Part 4 - Advanced SQLUnfiled |
 |
Training
Provided by Serebra Learning Corporation
This course teaches the learner how to make use of advanced SQL techniques to access DB2 databases in different environments. Indepth coverage is given to creating SQL objects Case CAST and Summary Tables Joins Subqueries Scalar Functions Recursive SQL UDTs/UDFs and general performance guidelines. It is appropriate for learners working in all DB2 environments that is OS/390 VM/VSE AS/400 UNIX Windows and OS/2.
|
|
||||||||||
IBM DB2 UDB Essentials Part 4 - Advanced SQL
To identify SQL syntax used to create a table.
To identify SQL syntax used to define CHECK constraints.
To identify SQL syntax used to create an index.
To identify SQL syntax used to perform an inner join.
To match types of outer joins with their functions.
To identify SQL syntax used to perform a join between more than two tables.
To identify SQL syntax used to create a basic subquery.
To identify features of the IN predicate.
To identify features of the ALL predicate.
To identify features of the SUBSTR scalar function.
To identify features of the COALESCE scalar function.
To identify features of the DECIMAL scalar function.
To identify features of nested table expressions.
To identify SQL syntax used to create a nested table expression in a join.
To identify features of common table expressions.
To identify features of User-Defined Types (UDTs).
To identify features of User-Defined Functions (UDFs).
To identify features of the DB2 UDB index structure
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
Audience
Experienced SQL end-users application programmers database administrators and user support staff who need more advanced knowledge of SQL. Experience with coding and executing basic SQL statements is a pre-requisite of this course. (These skills can be developed by attending CF12 "DB2 SQL Workshop" or equivalent experience.
Objective
Upon completion of this course the student will be able to:
Topics Include
Unit 1: Creating DB2 UDB Objects
- Identify SQL syntax used to create a table.
- Identify SQL syntax used to define CHECK constraints.
- Identify SQL syntax used to create an index.
- Identify rules associated with referential integrity.
- Identify SQL syntax used to define referential constraints between tables.
- Identify SQL syntax used to create triggers.
- Identify features and functions of views.
- Identify conditions that govern updating views.
- Identify conditions that cause DB2 UDB to materialize a view.
Unit 2: Joins Between Tables
- Identify SQL syntax used to perform an inner join.
- Match types of outer joins with their functions.
- Identify SQL syntax used to perform a join between more than two tables.
- Distinguish between local and join predicates.
- Identify syntax used to create a CASE expression in SQL.
- Identify features of CAST specifications in SQL.
- Identify features and functions of summary tables.
Unit 3: Subqueries
- Identify SQL syntax used to create a basic subquery.
- Identify features of the IN predicate.
- Identify features of the ALL predicate.
- Identify features of the EXISTS predicate.
- Identify features of correlated subqueries.
Unit 4: Scalar Functions
- Identify features of the SUBSTR scalar function.
- Identify features of the COALESCE scalar function.
- Identify features of the DECIMAL scalar function.
- Identify features of the CHAR scalar function.
- Identify features of the LENGTH scalar function.
- Identify features of the LTRIM and RTRIM scalar functions.
- Identify features of the RAISE_ERROR scalar function.
- Match date-related scalar functions with their uses.
- Match time-related scalar functions with their uses.
- Identify features of labelled durations.
Unit 5: Table Expressions and Recursive SQL
- Identify features of nested table expressions.
- Identify SQL syntax used to create a nested table expression in a join.
- Identify features of common table expressions.
- Match stages in the recursive SQL process with their syntax.
- Identify guidelines for controlling recursive SQL.
Unit 6: UDTs UDFs and Performance
- Identify features of User-Defined Types (UDTs).
- Identify features of User-Defined Functions (UDFs).
- Identify features of the DB2 UDB index structure.
- Identify factors that affect the decision by DB2 UDB to use an index.
- Identify the stages that the Optimizer applies to process predicates.
- Identify guidelines for optimal SQL performance.
Duration
8 Hours
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
CDROM
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
