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.
Training Paths that reference this course are:
Data Servers Cross Product Overview
DB2 for z/OS
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).
You should have:
Basic computer literacy
Basic editing skills
Database skills are not required.
- Simple SQL Queries
- Retrieving Data from Multiple Tables
- Scalar Functions and Arithmetic
- Column Functions and Grouping
- UNION and UNION ALL
- Using Subqueries
- Maintaining data