Manage Data with DB2 - SQL

Duration

2 to 3 hours

Overview

Audience

Programmers and DBAs requiring training in managing and accessing DB2 databases, particularly the use of SQL.

Prerequisites

Basic knowledge of DB2, relational databases, and system design.

Objectives

After completing this course, the student will be able to identify:
• How to inquire on DB2 data by using SQL Data Manipulation Language (DML)
• How to insert, update, and delete DB2 data by using SQL DML

Course Content

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, UPDATE, and MERGE 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 - SQL Mastery Test