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.

« Hide The Details

Topics Covered In This Course

SUMMARY – DATA WAREHOUSE (DW) TERMS & CONCEPTS

Rationale and beneficiaries
DW architecture (including BI considerations)
Data warehouse vs. data mart
Metadata
Normalization vs. denormalization
Integrity constraints
Schema types
DW objects (logical vs. physical)
Hardware considerations
Partitioning and parallelism options
Indexes
Summary tables
Extract, Transform, Load (ETL)

STATISTICS & ANALYTIC QUERY OPTIONS

Rationale
AVG
CORRELATION
COUNT/COUNT_BIG
COVARIANCE
MAX
MIN
RAND
STDDEV
SUM
VARIANCE
Workshop

ONLINE ANALYTICAL PROCESSING (OLAP) QUERY OPTIONS

Rationale
RANK
DENSE_RANK
ROW_NUMBER
PARTITION BY
ORDER BY
ROWS
RANGE
GROUP BY
GROUPING
ROLLUP
CUBE
OVER
Workshop

COMMON BUSINESS SCENARIOS

Retail
Finance
Sports
Advertising
Office supplies

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.

Recommended Prerequisites

Completion of our 'Data Warehousing Terms, Concepts & Architecture' (DWHTCA) course or equivalent knowledge.

« Hide The Details

Related Courses

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.

Schedule For This Course
There are currently no public sessions scheduled for this course. We can schedule a private class for your organization just a couple of weeks from now. Or we can let you know the next time we do schedule a public session.

Notify me the next time this course is confirmed!

Can't find the course you want?
Call us at 800.533.3893, or
email us at [email protected]

Privacy Notice