Discover Classes. Earn Rewards.

Oracle BI 11g R1: Build Repositories is unfortunately unavailable

Thankfully we have 1 other Oracle Class for you to choose from. Check our top choice below or see all classes for more options.

SQL Queries Introduction

Computer Training Source, Inc. @ 420 N Wabash Ave, Chicago, IL

Learn how to use SQL to update and retrieve data from various database systems, including Oracle, Sybase, Microsoft SQL Server, and more. Gain skills in performing conditional searches, working with functions, organizing data, retrieving data from multiple tables, and exporting query results. Bring a flash drive for storing exercise files and dress in business casual attire.

(21) Beginner 18 and older
$999

4 sessions

Gift it!
See all Oracle classes Chicago

Oracle BI 11g R1: Build Repositories

  • All levels
  • 18 and older
  • $5,000
  • 1450 East American Lane, Schaumburg, IL
  • over 5 sessions

Start Dates (0)

  • $5,000
  • ExitCertified - Schaumburg @ 1450 East American Lane Ste 1640, Schaumburg, IL 60173
  • over 5 sessions
Showing 10 of 0

Class Description

Description

What you'll learn in this oracle training:

This Oracle BI 11g R1: Build Repositories training is based on OBI EE release 11.1.1.7. Expert Oracle University instructors will teach you step-by-step procedures for building and verifying the three layers of an Oracle BI repository; you'll begin by using the Oracle BI Administration Tool to construct a simple repository to address a fictitious company's business requirements.

Learn To: 
  • Build and execute analyses to test and verify a dimensional business model.
  • Use the Oracle BI Administration Tool to administer Oracle BI Server.
  • Use the Oracle BI Administration Tool to build, manage and maintain an Oracle BI repository.
  • Build a dimensional business model to address business intelligence requirements.
  • Validate your work by creating and running analyses, and verifying query results using the query log.
Skills Gained:
  • Build and run analyses to test and validate a repository
  • Build simple and calculated measures for a fact table
  • Create logical dimension hierarchies and level-based measures
  • Check the model and then model aggregate tables to speed query processing
  • Model partitions and fragments to improve application performance and usability
  • Use variables to streamline administrative tasks and modify metadata content dynamically
  • Use time series functions to support historical time comparison analyses
  • Set up security to authenticate users and assign appropriate permissions and privileges
  • Build the Physical, Business Model and Mapping, and Presentation layers of a repository
  • Apply cache management techniques to maintain and enhance query performance
  • Set up query logging for testing and debugging
  • Set up a multi-user development environment
  • Use the Administration Tool wizards and utilities to manage, maintain, and enhance repositories
  • Enable usage tracking to track queries and database usage, and improve query performance
  • Perform a patch merge in a development-to-production scenario
  • Describe Exalytics machine and the Summary Advisor tool used in the machine
Who Can Benefit:
  • Application Developers
  • Business Analysts
  • Business Intelligence Developer
  • Data Modelers
  • Data Warehouse Administrator
  • Data Warehouse Analyst
  • Reports Developer
  • Technical Consultant
Prerequisites:
  • Knowledge on Dimensional modeling
  • Knowledge on Basic SQL
  • Knowledge on Data warehouse design

Refund Policy

  • Cancellations made at least 22 business days in advance of the class will be honored with a refund less 5% cancellation fee.
  • Students who cancel less than 22 business days prior to the start time are assessed a fee of 100% of the class fee.
In the event that an instructor or the school needs to cancel at the last minute, students will receive a refund less a 5% non-refundable registration fee.

Reviews of Classes at ExitCertified (2)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 50000 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

ExitCertified

A Trusted Name in IT Education

Since 2001, ExitCertified has provided individual and corporate clients with a superior learning experience. As a trusted education partner we deliver more than 9500 authorized IT training courses for 20+ vendors from such leading technology firms as Oracle, SAP, Symantec,...

Read more about ExitCertified

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Chicago educator.

ExitCertified

ExitCertified

All classes at this location

Google Map

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Professional Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...