Datatrain
Partners
Login
  Username
  Password
  Partner Login
 
Forgot Password?
Register Now!
Partners
Interskill Mainframe Training Newsletter - April ´17
Interskill Mainframe Training Newsletter - August ´16
Interskill Mainframe Training Newsletter - June ´15
Past Issues

Partners
Mainframe Links
Mainframe Facts - Did you know?



DidYouKnow


More facts...

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10

Manage Data with DB2 - SQL V10

Duration
6 hours

Overview

Description

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.

Audience

Programmers, DBAs, business analysts, and any other personnel 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 - SCALAR and COLUMN Functions, ORDER BY Clause

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

Subqueries and Correlated Subqueries

Code Correlated and Non-Correlated Subqueries

Manage Data with DB2 - SQL Mastery Test

Course Catalog » Database Curriculum » DB2 - Database Management System Series V10
 
 
 
  © All rights reserved. Interskill Learning Pty Ltd.
website designed & developed by blueapple
  HomeAbout UsProductsDemonstrationCourse CatalogDistributorsSite Map
    AOL Logo Interskill IBM