Oracle Database: Introduction to SQL

• Identify the major structural components of the Oracle Database 12c
• Manage objects with data dictionary views
• Manage schema objects
• Retrieve row and column data from tables
• Run data manipulation statements (DML) in Oracle Database 12c
• Use scalar and correlated sub-queries
• Utilize views to display data
• Write SELECT statements that include queries
• Write multiple-column sub-queries
• Control database access to specific objects
• Create reports of aggregated data
• Create reports of sorted and restricted data
• Create tables to store data
• Display data from multiple tables using the ANSI SQL 99 JOIN syntax
• Employ SQL functions to retrieve customized data 

Oracle BI 11g R1: Create Analyses and Dashboards

• Introduction to Oracle Business Intelligence Enterprise Edition
• Working with Oracle Business Intelligence Analyses
• Filtering Data for Analyses
• Selecting and Grouping Data in Analyses
• Adding Views to Analyses
• Showing Results with Pivot Tables
• Working with Additional Views in Analyses
• Visualizing Data: Gauges and Maps
• Scorecards and Key Performance Indicators
• Measuring Results with Scorecards and KPIs
• Creating Oracle Business Intelligence Dashboards
• Configuring Oracle Business Intelligence Dashboards
• Creating Dashboard Prompts and Variables
• Integrating BI Content with MS Office
• Working with BI Content in Smart View
• Oracle Business Intelligence Mobile
• Creating Mobile Applications with Oracle Business Intelligence Mobile App Designer
• Using Oracle Business Intelligence Delivers
• Administering the Presentation Catalog

Oracle BI 11g R1: Build Repositories

• Apply cache management techniques to maintain and enhance query performance
• Set up query logging for testing and debugging
• Set up a multiuser 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
• 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
• 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