Data Warehousing Training Toronto, Canada

Project Management Professional (PMP) from Project Management Institute(PMI)

QTP Certified Product Consultant (CPC) from Mercury

Certified Software Test Engineer (CSTE) from Quality Assurance Institute (QAI) Orlando, Florida

Project Management & Communications Course from Indian Institute of Science(IISc), Bangalore.

Software Quality Management Course from Indian Institute of Science(IISc), Bangalore.

Trained on Six Sigma Green Belt

Home > Training > Data Ware Housing Course Module

Data Ware Housing Training in Toronto

Review concepts relational databases

  • Normalization, 1st. 2nd. And 3rd.
  • normal form Star schema design and Snowflake schema design
  • Data Aggregation concepts

Database and ETL

  • Oracle sql*loader
  • PL/SQL
  • Extract, Transform, Load procedures
  • Table partitioning concepts
  • Data warehouse performance tuning

UNIX Overview and Shell scripts

  • Basic UNIX commands
  • Korn Shell
  • Automating ETL scripts

Data Warehouse Project

  • Real life Equity portfolio data warehouse
  • Designing Portfolio data warehouse
  • Feeds from external vendors
  • Creating Load procedures
  • Automating load procedures Aggregate table creation

Want to know more about Data Warehousing Training ?

Call us now @ 1 416 275 9840 or Request info about Data Warehousing Training Details

Office : Intersection of Hurontario and Burnhamthorpe, Mississauga, ON