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


Search for Course:

SQ1010 Cross Platform SQL – Dealing with Complex Queries
 
 
Duration 3 Days
Delivery Method Instructor Led, Hands-on workshops
Public Price $1625.00


DESCRIPTION (Return to Top)

Get ready to go deep with Structured Query Language (SQL) and become a power user. Whether you are being asked to solve complicated problems with SQL or you need to read and understand complex SQL that is already written, this course is for you! Come prepared to master Structured Query Language (SQL) across multiple database platforms in this fast paced and hands-on course. We begin with an in-depth discussion of joins and move quickly to more complex operations involving set processing, grouping, subqueries, table expressions, recursion and more. 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 (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)
  • Complex Joins
  • Multiple Query Blocks
  • Table Expressions and Views
  • Set Operations
  • Advanced Grouping
  • Solving Complex Problems with SQL
  • Managing Transactions and Units of Work
  • Temporary Data


PREREQUISITES (Return to Top)

SQ1000 or equivalent experience.