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 | |
| Prerequisites |
|
| Duration |
|
| Audience | 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. |
| Available Formats |
|
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 BOE310 Business Intelligence Platform: Administration and Security training was well presented and the trainer was very patient with us, now signed up to the BOE320 Administering Servers training”
★★★★★
- Yocelyn Robles, Platform Engineer, Franchise Tax Board
“We just finished the course and I’d like to say that Basem was an excellent teacher. I will definitely recommend your company and him in the future”
★★★★★
- Renee Dansereau, Senior Analyst, AXA XL
“Steve was a great instructor and was able to articulate the course material in a way that promoted learning.”
★★★★★
- Ben Ruddock, Analyst, GSP International Airport
