Oracle school training courses in Colorado Springs, CO (public, in-house or online)

Major tasks to be considered within this course are:
�Software installation and the creation of new databases.
�An in-depth exploration of the database architecture, including memory, process and data structures, and the management of those structures.
�Management of database files.
�Specialized facilities intended to maximize performance of enterprise-scale transactional applications, such as the shared SQL and PL/SQL cache, the result cache, the database buffer cache, and other...

Full archival course description>>

CHOOSING A SQL & PL/SQL INTERFACE
�USING SQL DEVELOPER
�USING SQL*PLUS
�USING APPLICATION EXPRESS
�USING JDEVELOPER STUDIO

LANGUAGE FEATURES
�UNDERSTANDING PL/SQL
�STRUCTURE OF A PL/SQL PROGRAM BLOCK
�USING PL/SQL FROM SQL*PLUS

DECLARE CLAUSE
�ABOUT THE DECLARE CLAUSE
�DECLARE SIMPLE TYPES
�DECLARE COMPLEX TYPES
�TYPE ... TABLE
�TYPE ... RECORD

BEGIN CLAUSE
�ABOUT THE BEGIN CLAUSE
�PERFORMING DATA MANIPULATION
�LOGI...

Full archival course description>>

INSTALLING ORACLE 10G DATABASE SOFTWARE
�IDENTIFY DATABASE SYSTEM REQUIREMENTS
�THE OPTIMAL FLEXIBLE ARCHITECTURE (OFA)
�CONFIGURE THE INSTALLATION ENVIRONMENT
�INSTALLATION USING THE UNIVERSAL INSTALLER
�MORE ABOUT ENTERPRISE MANAGER

EXPLORING THE ORACLE DATABASE ARCHITECTURE
�GENERAL DATABASE ARCHITECTURE
�DATABASE INSTANCE MEMORY ARCHITECTURE

DATABASE INSTANCE PROCESS ARCHITECTURE
�ABOUT THE INSTANCE PROCESS ARCHITECTURE
�INSTANCE BACKGROUND P...

Full archival course description>>

Learn to create BI Answers queries
Learn to create multiple query Views
Learn to create BI Interactive Dashboards
Learn to configure, schedule, and deliver Alerts

Outline

Query development
Filters
Result Formatting
Charts
Pivot Tables
Conditional Formatting
Custom Formulas
Narratives
Column Selectors
View Selectors
Gauges
Legends
Titles
Tickers
Funnels
Using Variables
Navigation
Combining Multiple Requests...

Full archival course description>>

Students attending this class will be able to understand the teminology used in iDocumaker Workstation as well as understand the setup of the base application. Students will be able to describe the system architecture, understand all of the files associated with the application, and learn to setup a new library. Students will learn how the iDocumaker Workstation application interacts with and utilizes resources from the Documaker and Docupresentment/IDS applications.
Learn To: Deploy the iDoc...

Full archival course description>>