Main Office: | 800.631.0410 | |
---|---|---|
Sales Office: | 800.533.3893 |
PLATFORM:
Multi-platform: DB2 UDB for z/OS & OS/390, DB2 UDB for Linux/ UNIX/Windows, Oracle and SQL Server.
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.
Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements.
Data warehouse and BI developers, data warehouse architects and DBAs.
Completion of our 'Data Warehousing Terms, Concepts & Architecture' (DWHTCA) course or equivalent knowledge.
Code | Course Title | Duration | Level | |
---|---|---|---|---|
DWHTCA |
Data Warehousing Terms, Concepts and Architecture |
1 Day |
I |
Details |
DWHWPT |
DB2 Data Warehousing Performance And Tuning Workshop |
4 Days |
II |
Details |
OWHPSQ |
Advanced PL/SQL (and SQL) for Data Warehousing ETL |
4 Days |
III |
Details |
Every student attending a Verhoef Training class will receive a certificate good for $100 toward their next public class taken within a year.
You can also buy "Verhoef Vouchers" to get a discounted rate for a single student in any of our public or web-based classes. Contact your account manager or our sales office for details.