On-site & Public, Instructor-led, Hands-on IT Training
(International 01) 908.233.8900
  400+ Course Offerings:

Search for Course:

SQ1000 Cross Platform SQL Essentials
Duration2 Days
Delivery MethodInstructor Led, Hands-on workshops
Public Price$1125.00

DESCRIPTION (Return to Top)

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 & 12c
  • Microsoft SQL Server

AUDIENCE (Return to Top)

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.

TOPICS (Return to Top)
  • Relational Database Concepts
  • Basic Data Retrieval
  • Intermediate Data Manipulation
  • Built-in Functions
  • Aggregation
  • Joins
  • Data Modification