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
I enjoyed the class a lot! I had problems with queries, so it was super helpful when Mahesh copies them into the chat. All explanations were thorough and be able to do it was awesome.
- Lisa Kruta, Environmental Coordinator, US Air Force
“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
“Tomi was great. He was very detailed and made sure I fully understood the section before moving on. There are so many functions, so the Informatica materials and lab books are super helpful.”
- Leroy Smith, ETL Developer, US Army
