Course Description
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
“ExistBI has provided multiple Microsoft Power BI training to our HR, Product and Sales teams. We’ve now engaged them to assist with complex Financial reports”
- Jena Bomboy, HR Director, The Giant Company
“The content was great for an introduction to Tableau. I truly appreciate the way Michael was able to explain everything, and would recommend this class to anyone needing to get their feet wet with Tableau.”
- Shianne DeGeorge, Business Intelligence Group, Kaiser Permanente
“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
