Oracle DBA 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>>

Students study the internal structure and organization of an Oracle database environment. The course presents a structured approach to planning, building, tuning, and monitoring an Oracle 11g database. Students create an Oracle database, tablespaces, user accounts, views, indices, and other objects necessary to support an application. We also examine some of the issues involved when running a large number of databases within an environment and with running large databases.

PL/SQL is Oracle’s extension language for standard SQL.

In this PL/SQL training class, students who already know SQL, learn to use PL/SQL to write sophisticated queries against an Oracle database.

Class Goals
•Understand the PL/SQL Development Environment.
•Learn the basics of the PL/SQL language.
•Learn to declare and work with variables.
•Learn to use conditionals and loops in PL/SQL.
•Learn to handle and create user-defined exceptions.
•Learn to ...

Full archival course description>>