Database school training courses in Denver, CO (public, in-house or online)

This five-day instructor-led course provides students with the knowledge and skills to implement a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to implementing a database.

Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion
After completing this course, students will be able to:
�Create databases and datab...

Full archival course description>>

This five-day instructor-led course provides students with the knowledge and skills to maintain a Microsoft SQL Server 2008 database. The course focuses on teaching individuals how to use SQL Server 2008 product features and tools related to maintaining a database.

Audience
This course is intended for IT Professionals who administer and maintain SQL Server databases.

At Course Completion
After completing this course, students will be able to:
�Install and configure SQL Se...

Full archival course description>>

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