Data Warehousing – Advanced SQL Queries & Performance
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.
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.
Objectives: Upon completion of this presentation, the participant should be able to code efficient SQL queries to meet both single and multidimensional business requirements.
This Training Course is taught in classrooms in the following locations:
Guide Price: GBP750+VAT