About this Course

Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. The course begins with a discussion of relational concepts and terminology and quickly moves into a very practical discussion of data retrieval and manipulation using SQL. Each topic is reinforced with hands-on workshops.

Examples and workshops are provided for the following platforms with discussion of the relevant differences:

• DB2 for z/OS
• DB2 for Linux, Unix & Windows
• Oracle 10g & 11g
• Microsoft SQL Server

Audience Profile

Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to perform the activities associated with data stored in a relational database such as DB2, Oracle or SQL Server.

Course Outline

1. Relational Database Concepts

• The Relational Model
• Domains
• Integrity and Relationships (SQL)
• Unknown Values (NULL)
• Basic Datatypes

2. Basic Data Retrieval

• SELECT Statement
• Using SELECT
• Projecting Columns Onto the Result
• Basic Predicates
• Expressions in the SELECT Clause
• Expressions in the WHERE Clause

3. Intermediate Data Manipulation

• Compound Conditions
• Other WHERE Clause Operators
  • BETWEEN
  • IN
  • LIKE
  • IS NULL
• Using DISTINCT
• ORDER BY Clause

4. Built-in Functions

• Working with Datatypes and Casting
• Functions Involving NULLs
• CASE Statements

5. Aggregation

• SUM, AVG, MIN, MAX, & COUNT Functions
• Grouping Results with GROUP BY
• Filtering Groups with HAVING

6. Joins

• Inner Equi-Join
• Join Classification
• Cartesian Products
• Inner Joins of More than 2 Tables

7. Data Modification

• INSERT
• UPDATE
• DELETE
• COMMIT and ROLLBACK