Introduction to DB2 via SQL and Query/400
Summary
SQ101
This course provides an introduction to SQL language applied for DB2 environments and IBM QUERY/400 basic concepts. It provides the basic knowledge to code simple SQL and QUERY/400 statements in order to retrieve data from a DB2 table, to group and order the selected data, to perform simple numerical and alphanumerical operations, to join and merge tables, to modify table data using INSERT, UPDATE and DELETE commands and to create new tables or views.
Audience
This course is being addressed to people needing to write, maintain, or understand SQL queries. Additionally, it might be useful to business analysts, software developers and database administrators who don’t have the knowledge of a Data Manipulation Language (DML).
Prerequisites
There is no need of any special prerequisite, however, a basic familiarization with computer literacy is strongly advised.
Duration
16 hours
Level
Fundamental
Content
-Introduction to DB2 and DMLs and tools
-Simple SQL Queries
-Retrieving Data from Multiple Tables
-Numeric and alphanumeric functions
-Column Functions and Grouping
-UNION and UNION ALL
-Using Subqueries
-Maintaining data
-QUERY/400