SQL Workshop :: CE120

start > courses and registration > training feature sheet

code.

CE120

length.

2 days

type.

Instructor-Led

partner.

IBM

price.

$995

This course provides an introduction to the SQL language and applies to the entire DB2 Family, and Informix. 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.

Phoenix, AZ	feb.4.2009 - feb.5.2009	register
Phoenix, AZ	feb.4.2009 - feb.5.2009	register
Phoenix, AZ	apr.29.2009 - apr.30.2009	register
Phoenix, AZ	apr.29.2009 - apr.30.2009	register
San Francisco, CA	feb.4.2009 - feb.5.2009	register
Sacramento/Elk Grove, CA	feb.4.2009 - feb.5.2009	register
San Francisco, CA	feb.4.2009 - feb.5.2009	register
Sacramento/Elk Grove, CA	feb.4.2009 - feb.5.2009	register
El Segundo/Los Angeles, CA	feb.4.2009 - feb.5.2009	register
El Segundo/Los Angeles, CA	feb.4.2009 - feb.5.2009	register
Sacramento/Elk Grove, CA	apr.29.2009 - apr.30.2009	register
San Francisco, CA	apr.29.2009 - apr.30.2009	register
Sacramento/Elk Grove, CA	apr.29.2009 - apr.30.2009	register
San Francisco, CA	apr.29.2009 - apr.30.2009	register
El Segundo/Los Angeles, CA	apr.29.2009 - apr.30.2009	register
El Segundo/Los Angeles, CA	apr.29.2009 - apr.30.2009	register
Englewood/Denver, CO	feb.4.2009 - feb.5.2009	register
Englewood/Denver, CO	feb.4.2009 - feb.5.2009	register
Englewood/Denver, CO	apr.29.2009 - apr.30.2009	register
Englewood/Denver, CO	apr.29.2009 - apr.30.2009	register
Miami, FL	dec.3.2008 - dec.4.2008	register
Miami, FL	dec.3.2008 - dec.4.2008	register
Atlanta, GA	may.4.2009 - may.5.2009	register
Atlanta, GA	may.4.2009 - may.5.2009	register
Chicago, IL	mar.25.2009 - mar.26.2009	register
Chicago, IL	mar.25.2009 - mar.26.2009	register
St louis/Maryland Heights, MO	feb.4.2009 - feb.5.2009	register
St louis/Maryland Heights, MO	feb.4.2009 - feb.5.2009	register
St louis/Maryland Heights, MO	apr.29.2009 - apr.30.2009	register
St louis/Maryland Heights, MO	apr.29.2009 - apr.30.2009	register
Durham/Raleigh, NC	feb.25.2009 - feb.26.2009	register
Durham/Raleigh, NC	feb.25.2009 - feb.26.2009	register
New York/Downtown, NY	apr.16.2009 - apr.17.2009	register
New York/Downtown, NY	apr.16.2009 - apr.17.2009	register
Bellevue/Seattle, WA	feb.4.2009 - feb.5.2009	register
Bellevue/Seattle, WA	feb.4.2009 - feb.5.2009	register
Bellevue/Seattle, WA	apr.29.2009 - apr.30.2009	register
Bellevue/Seattle, WA	apr.29.2009 - apr.30.2009	register

who can benefit

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 complete:

	Basic computer literacy
	Basic editing skills
	Database skills are not required

skills gained

Upon completion of this course, you should be able to:

	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

ibm education advantage program eligibility:

Yes - IBM Education Pack - online account

related courses, exams and materials

	other related training and products

CE030 DB2 Family Fundamentals

	before related training and products

U5732 DB2 Family Introduction Mini-Curriculum

	after related training and products

CF180 Relational Database Design

course content details

	Introduction

	Define the terms: Database, table, row, column, view
	State the more common DB2 and Informix data types
	List the most commonly used SQL statements in the: Data Definition Language (DDL), Data Manipulation Language (DML), and Data Control Language (DCL)
	State three null characteristics, and their meaning

	Simple SQL queries

	Describe four SELECT statement clauses (SELECT, FROM, WHERE, 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, 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
	Distinguish between INNER and OUTER joins

	Scalar Functions and Arithmetic

	Use arithmetic in the SELECT and WHERE clauses
	Use basic scalar functions to: Manipulate arithmetic calculations through rounding, Manipulate date values, and Manipulate character data

	Column Functions and Grouping

	Describe the difference between scalar and column functions
	List the more common DB2 and Informix column functions
	Group rows into sets based on one or more columns
	Limit the number of groups in the result set

	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 WHERE and HAVING clauses
	Code subqueries 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

	Agenda - Day 1

	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

	Day 2

	Exercise review
	Column Functions and Grouping
	Exercise 4
	Exercise Review
	Exercise 5
	Exercise Review
	Using Subqueries
	Exercise 6
	Exercise Review
	Maintaining Data
	Exercise 7
	Exercise Review