Oracle Database 11g: Administration
School: ONLC Training Centers in Texas
Venue: Austin, Dallas, El Paso, Fort Worth, Houston, Irving, Plano, Frisco, San Antonio, Wichita Falls
Tel.: 800-288-8221Major 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>>
|
Oracle Database 11g: PL/SQL Fundamentals
School: ONLC Training Centers in Texas
Venue: Austin, Dallas, El Paso, Fort Worth, Houston, Irving, Plano, Frisco, San Antonio, Wichita Falls
Tel.: 800-288-8221CHOOSING 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>>
|
Oracle Database 10g: Administration
School: ONLC Training Centers in Texas
Venue: Austin, Dallas, El Paso, Fort Worth, Houston, Irving, Plano, Frisco, San Antonio, Wichita Falls
Tel.: 800-288-8221INSTALLING 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>>
|
Oracle BI Dashboards, Answers, and Delivers
School: ONLC Training Centers in Texas
Venue: Austin, Dallas, El Paso, Fort Worth, Houston, Irving, Plano, Frisco, San Antonio, Wichita Falls
Tel.: 800-288-8221Learn 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>>
|
Developing SQL Queries for Oracle Databases
School: Learning Tree International
Venue: Annapolis, Atlanta, Baltimore, Boston, Chicago, Dallas, Los Angeles, New York, Philadelphia
Tel.: 1-888-843-8733You Will Learn How To
Formulate complex queries with Oracle SQL
Apply the full range of complex query types
Use the analytic OLAP functions of Oracle
Test SQL queries completely
Select the most efficient solution to complex SQL problems
Choose between Oracle and ANSI style joins
Course Benefits
SQL forms the cornerstone of all relational database operations. Taking full advantage of its power requires an in-depth understanding of the language. In this co...
Full archival course description>>
|
