PL/SQL school training courses in Colorado Springs, CO (public, in-house or online)

Introduces students to creating database structures and storing, retrieving, and manipulating data in a relational database. SQL is the set of statements that all users and programs must use to access data in the Oracle database. Also focuses on SQL*Plus to manipulate SQL statements.

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

In this course, students learn to use the advanced features of PL/SQL in order to design and tune PL/SQL to interface with the database and other applications in the most efficient manner. Using advanced features of program design, packages, cursors, extended interface methods, and collections, students learn to write powerful PL/SQL programs. Programming efficiency, use of external C and Java routines, PL/SQL server pages, and fine-grained access are covered.

Students learn to write PL/...

Full archival course description>>

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

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