首頁>IBM課程中心>課程信息

DB2 SQL Workshop for Experienced Users

課程編號/Course Code	CE131	課程級別/Skill Level	高級
課程分類/Curricula	Data、AI	授課方式/Delivery Type	教室授課
授課語言/Language	中文	上機實驗/Hands-on Labs	有
價格 (元) /Price	NT$ 60000	天    數/Duration	3
點    卷	120	先修課程	CE121

授課地點 Location	3月	4月	5月	6月	7月	8月	9月	10月
台北			30-30

課程描述/Course Description：

This course teaches you how to make use of advanced SQL techniques to access DB2 databases in different environments. This course is appropriate for customers working in all DB2 environments, specifically for z/OS, Linux, UNIX, and Windows.

授課對象/Target Audience：

This intermediate course is for experienced SQL end users, application programmers, database administrators, and user support staff who need more advanced knowledge of SQL.

預備技能/Prerequisites：

You should have experience with:
coding and executing basic SQL statements.

課程目標/Skills Taught：

Discuss basic relational database concepts
Use some of the OLAP features of DB2, such as GROUPing and RANKing functions
Create tables, views and indexes ？ Use referential integrity, check constraints and triggers ？ Use outer joins, and join tables to themselves
Use CASE expressions, and the CAST function
Identify the impact of Summary Tables, Materialized Query Tables, and temporary tables
Use complex subqueries
Use a greater number of scalar SQL functions
Use advanced SQL constructs, such as recursive SQL and table expressions
Define User-Defined Distinct Types and User-Defined Functions
Avoid several of the most common causes for poorly-performing SQL

主要課題/Course Outline：

Introduction
Create Objects
Join
CASE, CAST, Summary Tables, and Materialized Query Tables ？ Using Subqueries
Scalar Functions
Table Expressions and Recursive SQL
UDTs/UDFs and Performance