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