![](http://picload.org/image/rgroorlp/10.jpg)
GoGoTraining – DB2 Training
English | Size: 2.66 GB (2,850,808,214 Bytes)
Category: CBTs
In This Course You Will Learn How To:
Use relational database concepts and terminology fluently, particularly that of the DB2 family of database management systems
Identify the various types and components of Structured Query Language (SQL)
Code simple to complex SELECT, INSERT, UPDATE, and DELETE statements
Distinguish between DB2’s various built-in data types and use scalar functions to transform data types
Code simple inner join statements and understand the concepts of an outer join
Perform aggregate processing with column functions and the GROUP BY and HAVING clauses
Distinguish between and code both correlated and non-correlated sub-queries
Combine result sets with the UNION and UNION ALL set operators and understand the related concepts of intersection and difference
Code CASE expressions and outer joins as appropriate alternatives to UNION ALL
[Read more…]