Advanced SQL

ExistBI is a Microsoft Partner

Course Description

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.

Course Summary

Next Public Course Dates

UK & Europe:

  • 25 - 26 June 2026
  • 16 - 17 July 2026
  • 30 - 31 July 2026

US & Canada:

  • 9 - 10 July 2026
  • 23 - 24 July 2026
  • 6 - 7 August 2026

More dates

Prerequisites
  • Before taking this course, students should take SQL Basics or have equivalent work experience.
Duration
  • 2 Days
AudienceProgrammers, 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.
Available Formats
  • Public Virtual Live Instructor-Led
  • Private Virtual Live Instructor-Led
  • Private Onsite

Course Modules

  • 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

Testimonials

“The SAP BOID10 Universe Designer class was a very enjoyable and informative course and we’re all looking forward to using the skills we learnt. We all agreed that the instructor was very good and was able to break down pretty complex issues to make them more understandable”

★★★★★

- Grahame Welch, Head of BI, UK Home Office

“Mike was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions to remember, so just have to practice with the materials and labs to get acquainted with all of them.”

★★★★★

- Ariel, Analyst, US Military

“Our Informatica Data Quality training class was very good.  The trainer knew the tool and the Informatica platform very well. We recommed ExistBI for Informatica training.”

★★★★★

- Darren Jackson, CIO, US Bank

Upcoming Public Virtual Live Instructor-led Course Dates

UK & Europe:

US & Canada:

    To book this course, please fill in your details and submit the form.

      To book this course, please fill in your details and submit the form.