PL/SQL school training courses in Albuquerque, NM (public, in-house or online)

This hands-on course provides participants with the skills necessary to make full use of the procedural extensions to SQL that are supplied with Oracle.

Prerequisites: Successful completion of the Using Oracle SQL*Plus course, or equivalent knowledge and experience.

Delivery method: Instructor-led, group-paced, classroom-delivery learning model with structured independent or partnered exercises following each lesson.

Benefits: Students will learn to use PL/SQL extensions to ...

Full archival course description>>

This course introduces Oracle9i and Oracle Database 10g users to PL/SQL and helps them understand the benefits of this powerful programming language. Learn to create PL/SQL blocks of application code that can be shared by multiple forms, reports, and data management applications. Create anonymous PL/SQL blocks, stored procedures, and functions, and learn about declaring variables and trapping exceptions. Develop stored procedures, functions, packages and database triggers. Manage PL/SQL program ...

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

Oracle is a powerful and flexible relational database management system (RDBMS). It has hugely made its presence felt in database computing. PL/SQL is a significant tool which is designed for data manipulation, both internally within Oracle and externally in your own applications. Oracle databases tend to be backwards compatible. Oracle is an efficient, fast and resource saving operation. You can manage data retrieval for front-end operations using Oracle PL/SQL application.
Oracle is more v...

Full archival course description>>