Oracle PL/SQL Development Course

Read more about the Oracle PL/SQL Development course overview, prices and how to book.

Course Objectives: What Will I Learn?

Delegates with the requisite background who complete the Oracle PL/SQL Development course will be able to:

• Use PL/SQL Developer in a productive fashion.
• Create, debug and maintain PL/SQL packages, types, procedures, functions and triggers.
• Formulate program flow using selection, iteration and error control statements.
• Use language elements such as blocks, parameters, local variables, arrays, temporary tables and cursors.

Intended Audience: Is This The Right Course For Me?

This course is intended for:

• The Oracle PL/SQL Development course is intended for developers who require a PL/SQL foundation in order to create, debug and maintain types, packages, procedures, functions and triggers.

Course Prerequisites: Am I Ready For The Course?

Delegates who wish to attend the Oracle PL/SQL Development course must have programming experience and either our SQL Fundamentals course or familiarity with the more common aspects of SQL (Standard SQL or Oracle's version).

Please ensure you meet the prerequisites for the Oracle PL/SQL Development Course before you attend the course. Read the importance of course prerequisites to understand why this is necessary.

Course Contents: What Does The Course Cover?

Fundamentals

Database components. •  Standard & 3rd party tools. •  Architecture & Storage. •  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. •  Literals. •  Expressions. •  Operators. •  Data types. •  Scalar and aggregate functions. •  Constraints. •  Indices. •  Views. •  Materialized queries. •  Object comments. •  Temporary tables. •  Sequences. •  Joins. •  Transactions & save points. •  Set operations. •  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. •  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).

Download the Oracle PL/SQL Development course contents in PDF format for easy printing.

Home   |    Top of this page   |    Contact Us    Schedule   |    Course List   |    FAQ   |    Sitemap

Essential Skills for IT