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 Series V11

DB2 SQL Fundamentals V11

Duration
4 hours

Overview

Description

The DB2 SQL Fundamentals course looks at some of the more common SQL statements used by programmers when starting out. It addresses the code used to obtain DB2 table data, sort it, as well as methods used for inserting, deleting, updating and merging table data.

Audience

Programmers, DBAs, business analysts, and any other personnel that require SQL coding skills to manage DB2 data.

Prerequisites

Completion of the 'Manage Data Definitions with DB2' course, or equivalent knowledge.

Objectives

After completing this course, the student will be able to:

  • Code Simple SQL SELECT statements used to obtain DB2 table data
  • Describe how data can be sorted
  • Describe how to insert, update, and delete DB2 data by using SQL

Course Content

SQL - Selecting Data

Using the SELECT Statement to Obtain Data

Coding Predicates (WHERE Clauses)

Coding Simple Column Arithmetic

Coding for the Effects of Null Values

SQL - SCALAR and COLUMN Functions, ORDER BY Clause

Scalar Functions

Aggregate or Column Functions and Groupings

Coding the ORDER BY Clause

SQL - The INSERT, DELETE, UPDATE, and MERGE Statements

Inserting Rows into Tables

Deleting Rows from Tables

Modifying the Values of Columns in Rows

DB2 SQL Fundamentals Mastery Test

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