Advanced SQL
What You'll Learn in Advanced SQL
Course Length
Learning Objectives
- Become a SQL power user
- Understand and solve complex SQL problems
- Learn more about set processing, advanced grouping, table expressions, recursion and more
Target Student
Programmers, Analysts, Database Administrators, End Users and IT Managers who are exposed to or are required to perform the activities associated with data stored in a relational database.
Course Outline
Get ready to go to the next level with the 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 the Structured Query Language (SQL) across multiple database platforms in this fast-paced and hands-on course. We begin with a review of joins and move quickly to more complex operations involving set processing, advanced grouping, table expressions, recursion and more. Each topic is reinforced with hands-on workshops. Examples and workshops are provided for multiple platforms, such as Db2 for z/OS, Db2 for Linux, Unix & Windows, Oracle, SQL Server or PostgreSQL, with discussion of the relevant differences.
Topics covered in this course:
- Review Inner/Outer Joins
- Subquery Table Expressions
- Set Operations
- Advanced Grouping with the CUBE, ROLLUP and GROUPING SETS Extensions
- Solving Complex Problems with SQL
- PIVOT and UNPIVOT Operations
- Using Temporary Tables and Views
Delivered by One of Our Trusted Partners
Advanced SQL
Upcoming Classes
All Public classes are held onlinewith a live instructor
| Dates | Price | Qty |
|---|---|---|
| July 17-18, 2025 10:00 AM to 5:00 PM ET | $1,560.00 Online | |
| October 30-31, 2025 10:00 AM to 5:00 PM ET | $1,560.00 Online | |
| March 5-6, 2026 10:00 AM to 5:00 PM ET | $1,560.00 Online | |
| July 9-10, 2026 10:00 AM to 5:00 PM ET | $1,560.00 Online |
Have a Group?
Complete the form to receive a quote for private or customized training.
More people = GREATER savings
PDF Reference Guide
Take the Reference Guide anywhere and save the environment with an electronic copy of your training Reference Guide for use on any of your computers or devices
30 Days of After-Training Support
Get 30 days of live 24/7 after-training support via phone, email and online chat to help apply what you've learned
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.
PDF Reference Guide
Want a summary of what you’ve learned? Save paper and use your PDF Reference Guide, accessible on any of your devices.
Certificate of Completion
Boost your credentials with a Certificate of Completion, confirming the skills you’ve acquired with us.