WHAT WE DO - Training & Mentoring
Oracle 10g: Program with PL/SQL
Learning Objectives & Approach:
The objective of this course is to provide an introduction to the PL/SQL programming language and teach students to develop database server-side PL/SQL program units within an Oracle database.
Key Topics:
During this course, students will learn about:
- the environment and context in which PL/SQL operates
- the advantages and benefits of PL/SQL within a database environment
- declaring program variables and complex data types
- developing logic within PL/SQL program blocks
- fetching data from the database into program variables
- returning program output to users
- handling program exceptions
- using explicit and implicit database cursors
- using the advanced features of nested blocks and subprograms
- how to take advantage of new features such as regular expression support and the handling of string literals within program code
- application partitioning within a client/server or multi-tiered web-based architecture
- the basic form and structure of program units stored within the database
- building and maintaining database stored program units
- encapsulating stored units within packages and taking advantage of accompanying advanced programming techniques such as cursor variables and cursor expressions
- handling intricate theoretical challenges, such as mutating tables
- building and maintaining DML-event and system-event database triggers
- the storage and execution model for database programs and how one can write efficient programs to maximize performance
- using system-supplied packages to extend the power of SQL statements and PL/SQL applications
Targeted Participants:
Oracle professionals, including Application Designers and Application Developers and Database Administrators.
Prerequisites:
Oracle 10g: Introduction to SQL or equivalent knowledge.
Course Fee:
For public courses, $2,475.00 (CAD) per participant. Group rates are available for both public and private courses - please inquire.
Registration:
Courses can be held at your site, or on-site at our training facility located in downtown Calgary, Alberta (Canada). Your team can join a public course, or request a private session.
To register for this course, use the "Register" link below.
Next public course: Sep 13 - 17