• Decrease font size
  • Default font size
  • Increase font size

SQL Fundamentals for DB2 Self-Paced Training Course

 Print E-mail

Try A SQL Fundamentals for DB2 self-paced Training Module Now!Visit GogoTraining and Buy SQL Fundamentals for DB2 self-paced training course today!

Start SQL For DB2 Training Today!

 

  • Dashcourses has partnered with GogoTraining to bring you this Self-paced Course
  • Set your own training schedule
  • Watch as many times as you want 24/7 for 60 days following purchase
  • Find out what Dashcourses' self-paced SQL Fundamentals for DB2 training is all about with no obligation - download Silverlight and View a Module
  • Our self-paced training modules are viewable in Internet Explorer, Firefox and Safari

Training Description

This SQL Fundamentals for DB2 self-paced technical training course is designed for the database professional who wants to get more “bang for the buck” out of DB2. A common complaint is that so much money is sunk into relational database management systems, only to have them end up as glorified flat-file processors due to inefficient SQL and misguided application design.

Why select all the columns and all the rows only to have your application program (or third-party tool) do the filtering? Why select detail-level rows when what you want to see is summarized results?

This self-paced SQL course presents basic and intermediate SQL syntax in an easy-to-understand format, demystifying even some of the more complex features. It enables the attendee to return to work much better prepared to avail him‑ or herself of the power of the DB2 engine.

Training Objectives

Upon completing this technical training course, you should be able to:

  • Use relational database concepts and terminology fluently, particularly that of the DB2 family of database management systems
  • Identify the various types and components of Structured Query Language (SQL)
  • Code simple to complex SELECT, INSERT, UPDATE, and DELETE statements
  • Distinguish between DB2’s various built-in data types and use scalar functions to transform data types
  • Code simple inner join statements and understand the concepts of an outer join
  • Perform aggregate processing with column functions and the GROUP BY and HAVING clauses
  • Distinguish between and code both correlated and noncorrelated subqueries
  • Combine result sets with the UNION and UNION ALL set operators and understand the related concepts of intersection and difference
  • Code CASE expressions and outer joins as appropriate alternatives to UNION ALL

Prerequisites

There are no DB2‑ or SQL-specific prerequisites for this course. However, any prior experience with DB2 or other relational database management systems should prove valuable.

Proficiency with Windows, Notepad (or another Windows-based text editor), the mouse, and the PC in general is assumed. For a Linux/UNIX audience, familiarity with equivalent tools and concepts is assumed.

Upon completion of this course, many students benefit from attending Advanced SQL for DB2 as a follow-on course.

Self-Paced Modules

SQL for DB2 Training Module 1: Overview

  • Objectives
  • Bibliography
  • Workshop: If necessary, install DB2 and the SAMPLE database

SQL for DB2 Training Module 2 – Introduction to Relational Databases

  • Relational database concepts
  • The DB2 family
  • Structured Query Language (SQL)
  • Workshop: Familiarization

SQL for DB2 Training Module 3 – Simple SELECT Statements

  • Simple SELECT statements
  • Column projection: The SELECT clause
  • Row selection: The WHERE clause
  • Sequencing the result: The ORDER BY clause
  • Workshop: Data retrieval

SQL for DB2 Training Module 4 – Simple Modification Statements

  • Adding rows: The INSERT statement
  • Changing column values: The UPDATE statement
  • Removing rows: The DELETE statement
  • Views and modification statements
  • SQL return codes
  • Workshop: Data modification

SQL for DB2 Training Module 5 – Data Types

  • Numeric, string, and chronological data types
  • Special registers
  • Nullable columns

SQL for DB2 Training Module 6 –Scalar Functions

  • Data-type conversion with scalar functions
  • Scalar functions to change nullity
  • Numeric, string, and chronological scalar functions
  • Miscellaneous scalar functions
  • Workshop: Customizing result sets

SQL for DB2 Training Module 7 – Joining Tables

  • Types of joins
  • Joins for referential integrity
  • Self-referencing joins
  • Joining three or more tables
  • Exceptions and outer joins
  • Workshop: Inner joins

SQL for DB2 Training Module 8 – Aggregate Processing

  • Column functions
  • The GROUP BY clause
  • The HAVING clause
  • Workshop: Column functions and grouping

SQL for DB2 Training Module 9 – Subqueries

  • Syntax elements
  • Noncorrelated and correlated subqueries
  • Subquery predicates
  • Modification statements with subqueries
  • Workshop: Subqueries

SQL for DB2 Training Module 10 – Set Operations

  • Union
  • Intersection
  • Difference
  • Workshop: Combining result sets

SQL for DB2 Training Module 11 – CASE Expressions

  • Searched WHEN clause
  • Simple WHEN clause
  • More examples of CASE expressions

SQL for DB2 Training Module 12 –Outer Joins

  • Inner joins—Review
  • Exception rows
  • Outer joins—The old way
  • Left, right, and full outer joins
  • Filtering rows in outer joins
  • Workshop: Alternatives to UNION ALL

SQL for DB2 Training Module 13 – Review and Summation

  • What you have learned
  • Where to go from here