DB2 SQL Workshop

M/UX
Atlanta, Chicago, Denver, Los Angeles, New York, Phoenix, San Francisco, Seattle, St. Louis, United States

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' This is a basic course for individuals who need to write, support, or understand SQL queries. This includes but is not limited to end users, programmers, application designers, database administrators, and system administrators.


Skills Taught

--------------------------------------------------------------------------------

Write basic Data Manipulation Language (DML) SQL statements
SELECT
INSERT
UPDATE
DELETE
Write basic Data Definition Language (DDL) SQL statements
CREATE TABLE
CREATE VIEW


Course outline

--------------------------------------------------------------------------------

Introduction

define the terms database, table, row, column, and view
state the most common DB2 UDB data types
list the most commonly used SQL statements in DDL
list the most commonly used SQL statements in DML
list the most commonly used SQL statements in Data Control Language (DCL)
state three null characteristics and their meaning
Simple SQL queries

describe four SELECT statement clauses (SELECT, FROM WHERE, and ORDER BY) and their purpose
retrieve all rows of a table
retrieve specific columns
retrieve rows based on comparisons to numeric or alphanumeric column values
use the keywords BETWEEN, IN, LIKE, and DISTINCT
order the resulting rows in a desired sequence
Retrieving data from multiple tables

retrieve data from more than one table or view
specify JOIN predicates
use correlation names in queries
Scalar functions and arithmetic

use arithmetic in the SELECT and WHERE clauses
specify basic scalar functions such as COALESCE/VALUE, DECIMAL, and SUBSTR
use date and time scalar functions
use the CONCAT operator
Column functions and grouping

describe the difference between scalar and column functions
list the most common DB2 column functions
group rows into sets based on one or more columns
Union

produce a single result table containing data from more than one query
state the UNION rules
state the difference between UNION and UNION ALL
Using subqueries

use subqueries in the WHERE and HAVING clauses
code subqueies using basic predicates
code subqueries using the IN keyword
Maintaining data

create a simple table for testing DML statements
create a simple view
insert rows into a table
update data in a table
delete rows from a table
drop a table
Daily Agenda

Day 1

Welcome
Introduction
Simple SQL Queries
Exercises
Retrieving Data from Multiple Tables
Exercises
Scalar Functions and Arithmetic
Exercises
Day 2

Column Functions and Grouping
Exercises
Union
Exercises
Using Subqueries
Exercises
Maintaining Data
Exercises


Certification

--------------------------------------------------------------------------------

Prepare for:
IBM Certification Test 700: DB2 UDB V8.1 Family Fundamentals


...''

Phone:866-700-9811

School Address:

pSeries/AIX, CISCO, Linux, Microsoft, Professional Skills, Project Management, RedHat LINUX Enrollments 866-700-9811 (Toll Free) or 916-226-2537

CICS, iSeries/OS400, Enterprise/zSeries and WebSphere Enrollments 888-689-3326 (Toll Free) or 916-226-2511

DB2 UDB, Rational Software, and Tivoli Enrollments 866-700-9817 (Toll Free) or 916-226-2533

M/UX
9245 Laguna Springs Drive
Suite 315
Elk Grove, CA 95758 USA

Jobs & Resumes: Atlanta, Chicago, Denver, Los Angeles, New York, Phoenix, San Francisco, Seattle, St. Louis
Houses & Roommates: Atlanta, Chicago, Denver, Los Angeles, New York, Phoenix, San Francisco, Seattle, St. Louis

WebSphere MQ System Administration (Sun Solaris)
WebSphere MQ for z/OS System Administration
WebSphere MQ Security
IBM Lotus Domino Designer 8
IBM Lotus Domino 8 Administration
IBM Lotus Domino 8 Infrastructure
IBM Lotus Sametime 7.5 Infrastructure
CICS Application Programming
CICSPlex System Manager, Administration
CICS V3.2 Fundamentals
Relational Database Design
Using Rational Data Architect
DB2 9 Database Administration Workshop for Linux/UNIX/Windows
DB2 Universal Database Administration Workshop for Windows
DB2 Universal Database Administration Workshop for UNIX
DB2 UDB Multi Partition Database Administration Workshop for UNIX
DB2 9 for LUW Multiple Partition DBA Workshop
DB2 UDB for z/OS and OS/390 Data Sharing Implementation

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Besides Acquiring latest course information by the search form, Students can also leave their study interests here and let schools callback.