DBO11G5 - Introduction to Oracle® 11g PL/SQL Programming

AUD$ 2,550
Academy IT strive to provide you with the training you need when you need it most. If you require a course and can’t attend on the dates provided or if they are not suitable to your staffing or project timelines – please call PH: (08) 7324 9800 to negotiate an alternative booking time.

About this course

A Relational Database Management System (RDBMS) is a software system that allows you to create and manage a relational database. Minimum requirements for such a system are defined by both ANSI and ISO. PL/SQL is Oracle’s Procedural Language for SQL. It is Oracle’s database programming language for creating stored procedures, functions, database triggers, and object methods. PL/SQL can be used for implementing business rules, computing algorithms, manipulating data, and for stand-alone programs. The Oracle® 11g release has greatly enhanced the features and functionality of PL/SQL. Students will write stored procedures, functions, packages, and triggers, and implement complex business rules in Oracle. Students will learn programming, management, and security issues of working with PL/SQL program units. Programming topics will include the built-in packages that come with Oracle, the creation of triggers, and stored procedure features.

 

Prerequisites

A good working knowledge of Oracle 11g SQL features is required. Programming experience in a high-level language, such as COBOL™, Java™, or Perl is also required.

 

Audience

Application developers and database administrators.

To view the course outline please ensure you have Adobe Reader installed.

Get Adobe Reader

Download DBO11G5 - Introduction to Oracle® 11g PL/SQL Programming (PDF)

| Powered by nopCommerce