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 new 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 81 other followers