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) on the Db2 platform 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.
Entry level SQL coding experience assumed.
3 Days/Lecture & Lab
This course is designed for Programmers, Analysts, Database Administrators, and IT Managers who are exposed to, or are required to interact with data in Db2 databases.
- Complex Joins
- Multiple Query Blocks
- Table Expressions and Views
- Set Operations
- Advanced Grouping
- Solving Complex Problems with SQL
- Managing Transactions and Units of Work