ORACLE 11G

Oracle Database is an object-relational database management system.

ORACLE 11G Online Training

We introduce some of the basics of Oracle Database including installing Oracle on Windows and Linux, Oracle tools, some database modeling, underlying architecture, creating and dropping tables, selecting data, filtering data, sorting data, built-in functions, joining tables, and aggregating with the GROUP BY clause. The course content is not focused on Oracle Certification but it will give you a good start towards coding SQL and will also get you started with basic installation and configuration.

What you will learn

Technodips is providing best Oracle 11g Online Training from Hyderabad India.We will give you Online support the students of Technodips. Our Oracle 11g Online Training faculty is Certified, Highly Qualified and dedicated.

  • Introduction ORACLE 11G

ORACLE 11G Course Content

 

  • Overview
  • General Datawarehousing concepts
  • Dimensional modeling basics
  • Dimension Types ( Conformed and SCD)
  • Fact  Types( Additive , Non additive, Snapshot, Accumulator etc)
  • Installation
  • Installation Prerequisites
  • Points of Caution while installing
  • Understanding the need for RCU
  • Installation best practices
  • Difference between Simple and Enterprise Install
  • Admin Tool And RPD Modeling
  • Understanding Online and Offline modes of RPD
  • Building the Presentation Layer of a Repository
  • Aggregate Persistence
  • Dimension Lookups
  • Hierarchical Tables and Parenct Child Hierarchy
  • Modeling a Ragged Hierarchy Dimension
  • Creating Time Series Measures
  • Testing , Validation of a Repository
  • Creating Calculated Measures
  • Creating Dimension Hierarchies
  • Organizing Presentation Layer
  • Working with Initialization Blocks and Variables ( Session and Repository Variables)
  • Adding Multiple Source
  • Working with Aggregates

 

  • Dashboard And Analysis
  • Creating and Editing Analysis
  • Creating Interactive Dashboards using Analysis
  • Creating query and chart
  • Working with Filters
  • Working with Pivot Table
  • Building Views and Charts in Requests
  • Creating and Configuring  Interactive Dashboard
  • Configuring Action  Links
  • Creating and understanding KPI,KPI Watchlists and Scorecards
  • Sending Alerts Using Delivers
  • Using Job Manager
  • Architecture And Security Features
  • Understanding OBIEE 11g Architecture
  • Role of Weblogic Server and Enterprise Manager
  • Admin and managed Server
  • Authentication & Authorization
  • Creating Application Roles
  • Creating Users , Groups, Web Catalog groups
  • Object & Data Level Security Implementation
  • Web catalog Level Security Implementation
Back to top