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

DB2 SQL Workshop

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

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

課程描述/Course Description：

This course provides an introduction to the SQL language.
This course is appropriate for customers working in all DB2 environments, that is, z/OS, VM/VSE, iSeries, Linux, UNIX, and Windows. It is also appropriate for customers working in an Informix environment.

授課對象/Target Audience：

This basic course is for everyone needing to write, support, or understand SQL queries. This includes but is not limited to end-users, programmers, application designers, database administrators, and system administrators who do not yet have knowledge of the SQL Data Manipulation Language (DML).

預備技能/Prerequisites：

You should have:
Basic computer literacy
Basic editing skills

課程目標/Skills Taught：

Code SQL statements to retrieve data from a DB2 or Informix table, including the SELECT, FROM, WHERE, GROUP BY, HAVING and ORDER BY clauses
Code inner joins and non-correlated subqueries
Use SQL arithmetic operations
Use scalar and column functions
Use UNION and UNION ALL
INSERT, UPDATE and DELETE rows
Code simple CREATE TABLE and CREATE VIEW statements

主要課題/Course Outline：

Introduction
Simple SQL Queries
Retrieving Data from Multiple Tables
Scalar Functions and Arithmetic
Column Functions and Grouping
UNION and UNION ALL
Using Subqueries
Maintaining data