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

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.

• Relational Database Concepts
• Basic Data Retrieval
• Intermediate Data Manipulation
• Built-in Functions
• Aggregation
• Joins
• Data Modification

None