e-Learning
Learn at your own pace with anytime, anywhere training.
Classroom Schedule
| Location | Delivered By | Language | Date | Price | Action |
|---|---|---|---|---|---|
| No schedule date's available now. | |||||
* Prices Inclusive of taxes
Virtual Schedule
| Location | Delivered By | Language | Date | Price | Action |
|---|---|---|---|---|---|
| No schedule date's available now. | |||||
* Prices Inclusive of taxes
Private / Corporate Training
Tell us a little about yourself:
Course Description
-
This DB2 SQL Workshop 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.
Objectives
- 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
Audience
- This basic IBM DB2 SQL 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
-
Database skills are not required.
Content
- 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