Data Warehousing (DW) – Advanced SQL Queries & Performance
Duration: 2 Days
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.
Topics Covered In This Course
SUMMARY – DATA WAREHOUSE (DW) TERMS & CONCEPTS
STATISTICS & ANALYTIC QUERY OPTIONS
ONLINE ANALYTICAL PROCESSING (OLAP) QUERY OPTIONS
COMMON BUSINESS SCENARIOS
What You Can Expect
Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements.
Who Should Take This Course
Data warehouse and BI developers, data warehouse architects and DBAs.
Completion of our 'Data Warehousing Terms, Concepts & Architecture' (DWHTCA) course or equivalent knowledge.
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.
Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]