Mark Rittman will be in Istanbul for a two days seminar this month(30 June-1 July), most probably I will be there and here is the details of this seminar.
Oracle 11g Data Warehousing Masterclass Seminar Description :
The Oracle Database is the foundation for any Oracle Business Intelligence and analytical application, and Oracle Database 11g delivers a number of new and incremental features that relates to data warehousing, analytics and aggregate management. This two-day seminar, delivered by Mark Rittman, takes delegates through the 11g release of Oracle’s data warehousing platform, examines several new features and provides an end-to-end guide to delivering fast, efficient data warehouses using the latest Oracle tools and database features.
Oracle 11g Data Warehouse Design ETL and Data Loading Indexing – Bitmap Indexes, Bitmap Join Indexes, Indexing for Star Transformations, Index Tuning using the SQL Access Advisor Partitioning, Compression & Parallel Execution SQL for Analysis Summarization & Oracle OLAP Data Mining Data Warehouse Optimization & Tuning
Day 1 :
Creating the Data Warehouse Foundation
- Oracle 11g Data Warehouse Design – The three-layer model – Constraints – Real Application Clusters – Storage – Backup & Recovery – Optimized Warehouse Initiative – ETL and Data Loading – SQL ETL functions – Merge – Table Functions – Multi-table Inserts – Parallel DML – Data Pump – Transportable Tablespaces – Oracle Warehouse Builder 11g – Indexing – Bitmap Indexes – Bitmap Join Indexes – Indexing for Star Transformations – Index Tuning using the SQL Access Advisor – Partitioning, Compression & Parallel Execution – New Partitioning features in 11g – Partitiion Pruning – Partition-wise Joins – Index Partitioning – Partitioning and Table Compression – Basic Segment Compression – Loading data into a standard compressed segment – Advanced Compression – ILM & ILM Assistant
Day 2 :
Effective Data Warehouse Querying, Mining and Tuning
- SQL for Analysis – Analytic Functions – Pivoting Operations – User-defined Aggregates – Data Densification (Partition Outer Join) and Time-Series Calculations – Model Clause – SQL For Aggregation – Rollup, Cube – Grouping Sets – With clause (subquery factoring) – Grouping into Itemsets – Hierarchical Cubes – Summarization & Oracle OLAP – Basic Materialized Views – Advanced Materialized Views – Refresh Mechanisms & MV Maintenance – Creating Analytic Workspaces – Querying AWs using SQL Views – Cube Organized Materialized Views – Data Mining – Introduction to Oracle Data Mining – Key algorithms – Preparing data for data mining – Supervised and Unsupervised mining – Incorporating DM functionality into the DW – Oracle Data Miner – Data Warehouse Optimization & Tuning – Star Transformations – Basic Query Rewrite – Advanced Query Rewrite (Query Equivalence) – Reading Explain Plans – Reading Trace Files – Data Warehouse Tuning using Oracle Enterprise Manager
Comment by H.Tonguç Yılmaz — June 24, 2009 @ 10:58 am
Comment by H.Tonguç Yılmaz — June 30, 2009 @ 6:04 pm
RSS feed for comments on this post. TrackBack URI
Fill in your details below or click an icon to log in:
You are commenting using your WordPress.com account. ( Log Out / Change )
You are commenting using your Twitter account. ( Log Out / Change )
You are commenting using your Facebook account. ( Log Out / Change )
You are commenting using your Google+ account. ( Log Out / Change )
Connecting to %s
Notify me of follow-up comments via email.
Notify me of new posts via email.
The Rubric Theme. Blog at WordPress.com.
Get every new post delivered to your Inbox.
Join 74 other followers