Oracle: Introduction to PL/SQL
Product Code: PLSC01 Time: 5 Hour(s) CEUs: Available

Summary:

This course provides an introduction to the PL/SQL, Oracle's procedural language extension to SQL.

Objectives:

After completing this course, students will be able to:
  • Describe the building blocks of PL/SQL and its environment
  • Explain the benefits of the basic components of PL/SQL structures
  • Explain the benefits of packages over stand-alone procedures and functions
  • Create various types of triggers
  • Create and use procedures

Outline:

  • PL/SQL
  • PL/SQL Structures
  • Packages
  • Triggers
  • Stored Procedures

Features:

  • Exercises that allow users to practice the application
  • A file containing the text of the exercises
  • Simulations that allow users to practice course skills, even if they don't have access to the application
  • A glossary

Applicability:

This course is for programmers and database administrators who will be using PL/SQL with Oracle database products or Oracle Developer/2000.

Prerequisites:


Technical Requirements:

200MHz Pentium with 32MB Ram. 640 x 480 256-color video (800 x 600 is recommended). Windows 98 or higher. Minimum Connection Speed: 28.8k. Internet Explorer 5.0 or higher (5.5 or higher for MindLeaders Central) required. Macromedia Flash player 6.0 is recommended for full functionality, but not required to play the courses. Sound card, with speakers or headphones is recommended, but not required to play the courses. JavaScript must be enabled. Netscape and AOL browsers not supported.

Copyright Information:

  • Oracle is a registered trademark of Oracle Corporation.
  • Developer/2000, Oracle Forms, Oracle Reports, Oracle Graphics, and Oracle Procedure Builder are trademarks of Oracle Corporation.

Terms of Use:

None

Copyright © 2005 MindLeaders. All rights reserved.