 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|||||||
|
|
|
|
|
|||
 |
|||
 |
Course Title:
Advanced PL/SQL
Course Code: STL-0R3 |
||
| Course Description: | So you already know the rudiments of PL/SQL and you want to find out about Procedures, Functions and Packages. This course moves the delegate on from the basics to more complex issues with PL/SQL. | ||
| What You Will Achieve: | Familiarity with PL/SQL Procedures, Functions and Packages - an appreciation of how these items fit in to PL/SQL makes the detail behind them easier to digest. | ||
| Who Should Attend: | Delegates already familiar with Oracle SQL and wishing to find out enough about Oracle's PL/SQL language. Familiarity with SQL is required; fluency would enhance the delegate's experience. | ||
| Pre-Requisites: | Introductory knowledge of SQL and a grasp of the basics of PL/SQL is also required. This course is meant to be a natural follow-on to the Introduction to PL/SQL course. Note that with any "Advanced" course these often are misread as being "Accelerated". Introductory PL/SQL knowledge is presumed for this course. | ||
| Course Content: | Course
Content This course will cover the following topics: Short refresher on PL/SQL basics (syntax and keywords) Procedures Parameters and Parameter Modes (in, out, in/out) Functions and return values Functions in the database callable from SQL Permission for others on database program units Package concepts Per-session data Advantages of using a Package Pre-supplied Packages from Oracle Course Material: Each delegate receives their own personal textbook which includes material for the course and may include material beyond the course. The present textbook of choice is "Oracle PL/SQL" by Rosenzweig and Silvestra; the right to substitute better material is reserved if such text becomes available. |
||
| Follow-on Courses: | Anyone
continuing on the Oracle "Developer" route ought to consider the Reports course or the Forms course. If you are contemplating both it may be useful to learn Reports first before you learn Forms (Reports is output-only from the database; Forms is output AND input which makes the tool more complex). Oracle Reports Oracle Forms |
||
| Course Duration: | 3 Days | ||
| Course Price: | P.O.A. | ||
| Contact: | Sentia Training Limited t: 0141-955-0370 e: courses@sentiatraining.com |
||
