Back to Courses

Db2 Coding – Coding Relationally – Expert Videos

Duration

45 minutes

Overview

Description

These expert videos delve deeper into the relational aspect of Db2 databases, explaining how it impacts the way applications are coded. The presenter discusses traditional data processing techniques and describes how this process differs when coding for Db2 databases. A range of coding tips are presented that will improve the performance of your Db2 applications.

Audience

This is aimed at individuals whose job role is to analyze and improve the performance of their Db2 database environment.

Prerequisites

Successful completion of the Interskill Db2 Coding – Defining Database Performance – Expert Video series, or equivalent knowledge.

Objectives

After completing this series of videos, the student should be able to:

  • Describe how a Relational Database is Structured
  • Explain the Differences Between Relational and Traditional Data Processing
  • Describe Programming Practices that Improve Db2 Application Performance

Course Content

What is Relational?

Reviewing What Constitutes Performance
Understanding What Relational Means
How Relational Impacts the Way You Code
Understanding the Relationship Between Db2 Tables
Accessing Data Elements

Relational vs. Traditional Thinking

Databases and Database Management Systems
Set Theory
Working With Tables, Rows, and Columns

What Does It Mean to Code Relationally?

Relational Closure
Relational Table Operations
SQL Statements
Working with Sets
Importance of the SQL WHERE Clause

Unlearning Past Coding Practices

Sorting and SQL
Using the ORDER BY Clause
Optimization of Data Access
Traditional Masterfile Processing
Using JOINS in Preference to CURSOR Processing
Using WHERE Instead of IF-THEN-ELSE
Differences Between Opening a File, and Opening a Cursor