Data Warehousing Concepts          
  • Introduction to Data Warehouse.
  • OLTP & OLAP Databases.
  • Data Warehouses and Data Marts and its Characteristics.
  • Concepts of Dimensional Modeling.
  • Concepts of Designing Star Schema, Snowflake Schema.
  • Dimension Tables, Fact Tables and its Characteristics.
  • Primary Key and Surrogate Key, Foreign Key concepts.
  • Slowly Changing Dimensions and its different types.
  • Staging area and Repository Concepts for Data Warehouse.
  • Granularity and Subject Orientation in the Data Warehouse.
  • Dimensional Modeling Concepts
    • Introduction to ETL Process.
Oracle & SQL queries
  • Introduction to oracle & PL/SQL.
  • Joining concepts.
  • Sub queries & correlated queries.
  • Oracle interview questions.
  • Introduction to Unix
  • Basis commands
  • Unix interview questions

Course Highlights –

  • Every course is trained by working professionals only
  • Ample practical assignments are given to the trainees
  • Real time project and examples to support practical learning
  • Mock interviews to simulate and help students face job interviews
  • Repeat the whole course with no extra cost
  • Flexible weekend classes and special weekday classes
  • Confirmation Letter / Training Letter / Project Letter : For Degree Pursing Candidates To Submit In Colleges
  • Experience Certificates : All students would be given experience certificates after successful completion of project.

Print Friendly