- Java Programming
- Advanced Java Programming
- Java Servlets & JSP
- Enterprise JavaBeans
- J2EE Development
- J2EE Overview
- J2ME Development
- Struts Development
- Spring Development
- JSF Programming
- SQL Fundamentals
- Advanced SQL for DB2
- Oracle PL/SQL Development
- Linux Fundamentals
- Perl Programming
- Project Management for IT
- Introduction to Programming
- Technical Documentation
Want to avoid schedule changes?
If you book four (4) delegates on a course, we guarantee that the course will proceed on the scheduled dates. In other words, we will not change the dates or postpone the course.
Schedule at a glance:
August 2008
| Java: | 02-06 11-15** |
| Advanced C: | 04-08 |
| Client-side web: | 04-08 |
| Standard C: | 11-15 |
| JEE Overview: | 18 |
| JEE Development: | 18-22 |
| ASP.NET: | 18-22 |
| Tech Doc: | 20-22 |
| Java Servlets & JSP: | 25-29 |
| Linux Fundamentals: | 25-29 |
| JavaScript: | 27-29 |
* 4-day course at 80% of course fee
** Customised course
View the complete schedule
Oracle PL/SQL Development Course
Course Description
This course is aimed at developers as it focuses primarily on the programming elements of Oracle's PL/SQL Language. It also includes some of the more advanced Oracle SQL features and extensions to standard ANSI SQL.
| Duration: | 5 days |
|---|---|
| Cost: | R6,900.00 excl VAT |
| Code: | PLSQL |
Prerequisites
Programming experience and either our SQL Fundamentals course or familiarity with the more common aspects of SQL (Standard SQL or Oracle's version).
Intended Audience
Developers who require a PL/SQL foundation in order to create, debug and maintain: types, packages, procedures, functions and triggers.
Contents
- Fundamentals
- Database components. • Standard & 3rd party tools. • Storage & Architecture. • Networking. • Creating & using databases. • Data dictionary. • Security. • Table spaces. • Clusters. • Indexes. • Schemas. • Synonyms. • Links.
- PL/SQL Developer
- Features. • Installation. • Applicability to various tasks. • Integration of Oracle's HTHL help files. • Customization. • Views. • Windows. • Database exploration. • Code editor. • Command window. • Ad hoc queries. • Statistics.
- Oracle SQL
- ANSI SQL vs Oracle SQL. • Data types. • Literals. • Expressions. • Operators. • Scalar & aggregate functions. • Constraints. • Indices. • Views. • Materialized queries. • Object comments. • Temporary tables. • Sequences. • Joins. • Set operations. • Transactions & save points. • Limiting rows & ranking. • Regular expressions. • Performance. • Explain plan.
- PL/SQL
- Procedural features. • Relationship with SQL. • Blocks. • Declarations. • Host variables. • PL/SQL variables, constants, collections & objects. • Error codes. • Statements: selection, iteration, error handling (exceptions). • Cursors. • Packages. • Libraries. • Other data structures. • Dynamic SQL.
- Stored Procedures
- Structure. • Parameters. • Output parameters. • Local variables. • Arrays. • Temporary Tables. • Calling from interactive tools & other languages.
- Functions
- Structure. • Return values. • Functions that access tables (issues & solutions).
- Triggers
- Concepts. • Syntax. • Table & Row triggers. • Before & After triggers. • Old vs New data. • Performance issues & other considerations. • Allowable actions.
- Miscellaneous
- Good coding practices. • Documentation. • Oracle File System (OFS). • Other development scenarios.
Download the Oracle PL/SQL Development course contents in PDF format for easy printing.
Need a course date? Please contact us at tel: (+27) 12 666 2020 or email us at info@incusdata.com for the next available course date.
Ready to book? Just fill out our course enrolment form and fax it to us at (+27) 12 666 2021 or email it to us at info@incusdata.com.
