SQL – Selecting Data

Using the Select Statement to Select Data
Coding Predicates (Where Clauses) to Restrict the Data Selected
Coding Simple Column Arithmetic
Coding for the Effects of Null Values

SQL – Scaler and Column Functions and Order

Coding Scalar Functions on Columns
Coding Aggregate or Column Functions and Groupings
Coding the Order By Clause

SQL – The Insert, Delete, and Update Statements

Using the Insert Statement to Insert Rows into Tables
Using the Delete Statement to Delete Rows from Tables
Using the Update Statement to Modify the Values of Columns in Rows

Joining DB2 Tables Together

Joining Tables in SQL

SQL – Distinct, Case, Union, and Views

Using the Distinct SQL Keyword
Using the SQL Case Expression
Creating Unions to Combine Data from Multiple Selects
Creating and Using Views to Protect or Aggregate Underlying Table Data

Subselects and Correlated Subselects

Code Correlated and Non-Correlated Subselects

Manage Data with DB2 UDB - SQL Mastery Test