Cross Platform SQL Essentials (SQ1000)

Request a Quote for this class

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
    • 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