- 6 hours
The Manage Data with DB2 - SQL course discusses how SQL code is used to select DB2 table data and how that data can be interrogated and manipulated using functions, operators, subqueries and views.
Programmers, DBAs, business analysts, and any other personnel requiring training in managing and accessing DB2 databases, particularly the use of SQL.
Basic knowledge of DB2, relational databases, and system design.
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
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
Coding Scalar Functions on Columns
Coding Aggregate or Column Functions and Groupings
Coding the Order By Clause
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
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
Code Correlated and Non-Correlated Subqueries