|
|
|
|
|
NWSQ1010 Cross Platform SQL – Dealing with Complex Queries
DESCRIPTION
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 3 day 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
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
- 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
NWSQ1000 or equivalent experience.
|
|
|
|
