Data Warehousing – Advanced SQL Queries & Performance
| Course Code: | DWHASP |
| Platform: | Multi-platform: DB2 for z/OS, DB2 UDB for Linux/UNIX/Windows, Oracle, SQL Server, etc. |
| Duration: | 2 days |
| Audience: | Data warehouse and BI developers, data warehouse architects and DBAs. |
| Prerequisites: | Completion of our course Data Warehouse Terms, Concepts & Architecture or equivalent knowledge. |
| Summary: | After briefly reviewing DW and BI terms and concepts, the
lecturer will develop an understanding of how to use the
statistics, analytic and OLAP features in a BI environment. The main features of this presentation are examples, intensive hands-on exercises, best practices and performance considerations. |
| Objectives: | Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements. |
 Detailed Outline |
|
Course Outlines
Detailed course outlines are available in PDF format.
Download Adobe's Acrobat Reader free from:
www.adobe.com
