[ Home ] [ IT Training ] [ Careers ] [ About Us ] [ How To reach ] 

• Introduction to data warehousing
  Data warehouse administration
  Fact tables
  Measures

• Materialized views
  Specifying the Build methods
  Refresh options
  Materialized view logs
  Storage options
  Query rewrite options
  Optimizer hints

• Creating materialized views on existing tables
  Altering and dropping views
  Partitioned materialized views
  Using OEM for defining materialized views

• Using Dimensions
  Dimension definitions
  Multiple hierarchy dimensions
  Normalized dimension tables
  Creating and managing dimensions
  Dimension wizard

• Summary advisor tool
  Viewing utilization information
  Workload statistics

• Dimensional analysis of data
  Data sampling techniques
  ROLLUP and Cube

• SQL analytic functions
  Ranking functions
  Handling nulls

• Using bitmap indexes
  Comparison with B-tree indexes

• Star schema and Star queries
  Star transformation

• Advanced SQL DML
  Mutli-table inserts
  Conditional inserts
  Merge statement
  Join methods
  Cross joins, natural joins, outer joins

• Using external tables
  Table functions

• Parallel processing
  Enabling parallel execution
  Tuning parallel execution

Corporate Office:
207, Lok Center, Marol-Maroshi Road, Marol, Andheri (East), Mumbai 400 059. India.
Tel: +91- 22- 2920 1583, 2920 6976, 2925 7840, 2920 9720, 2920 4122, 2925 7632, 2920 4130, 2920 8902, 2925 3052, 2925 7689, 2920 7387, 2920 6329 Fax. No: +91-22- 2920 7388      |e-mail: info@pragatisoftware.com

© Pragati Software Pvt. Ltd. All rights reserved.