Introduction to DB2 via SQL and Query/400
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.
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).
There is no need of any special prerequisite, however, a basic familiarization with computer literacy is strongly advised.
-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