Making the Most of the Best of PL/SQL with Steven Feuerstein

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

Steven Feuerstein's seminars move at a fast pace and complement feature descriptions with lots of code examples (students can download and run for themselves all code presented in the seminar).

Oracle PL/SQL is a robust and powerful language for developing applications that work with Oracle Database. However as Oracle has increased the feature set of PL/SQL, it has become more and more challenging for developers to apply those features in a way that produces high quality code: code that runs efficiently and is easy to maintain.

In this seminar, Steven Feuerstein presents the most important features of PL/SQL, and explores how to apply those features so that the resulting code is easy to und…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: SQL & MySQL, PL/SQL, Programming (general), IT Security, and Web Accessibility.

Steven Feuerstein's seminars move at a fast pace and complement feature descriptions with lots of code examples (students can download and run for themselves all code presented in the seminar).

Oracle PL/SQL is a robust and powerful language for developing applications that work with Oracle Database. However as Oracle has increased the feature set of PL/SQL, it has become more and more challenging for developers to apply those features in a way that produces high quality code: code that runs efficiently and is easy to maintain.

In this seminar, Steven Feuerstein presents the most important features of PL/SQL, and explores how to apply those features so that the resulting code is easy to understand, maintain and enhance. From high level principles to specific techniques, this course will give you the information you need to transform your PL/SQL programs into high quality code of which you can be proud.

Why should you attend this seminar?
Developers, like all people, develop habits in programming, and rarely find the time to explore the nuances and new features of a language. This course will open your eyes to new possibilities with PL/SQL, and new ways to write PL/SQL programs that result in more powerful, more readable code.

Target audience:
All developers, from beginner to expert, will benefit from Steven's ideas and examples.


Audience
  • PL/SQL Developer
  • Database Administrators

Course Topics Utilities to analyze memory consumption and elapsed time of your PL/SQL programs Key compiler features: automatic optimization, compile-time warnings and conditional compilation Data caching options in PL/SQL, from package-based variables to the new Oracle11g function result cache Bulk processing of SQL statements: how to use FORALL and BULK COLLECT to improve performance of row-by-row SQL processing by an order of magnitude or more Use of the NOCOPY hint to reduce the overhead of passing IN OUT arguments Critical error management features, from tracing back to the source of an error to suppression of errors at the row level in SQL operations. Creating modular code, the key to maintainability, with a focus on nested subprograms and package design Dynamic SQL: features and best practices for EXECUTE IMMEDIATE, plus guidance on the use of DBMS_SQL.
Course Objectives
  • You will be able to construct PL/SQL program units that use the latest and greatest features of the language.
  • You will also be better-prepared to analyze the code of others and offer suggestions for ways to improve their code.

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.